hi friends,
I am new at servlets and have attempted to make a connection with MySql but i get a new error each time i try to execute the stuff...i m placing my code here...please reply at the earliest if anybody is able to spot the error or has another code to execute the same...thanx!!
The code........
import java.util.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.text.*;
import java.sql.*;
import java.net.*;
import java.awt.*;
import java.awt.event.*;
public class Sample2 extends HttpServlet
{
public void doGet(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
try
{
String host = "localhost:8080";
String database="ans";
String driver = com.mysql.jdbc.Driver.class.getName();
String dbName = "jdbc:mysql://" + host + "/" +database ;
String userName = "root";
String password = "root";
Class.forName(driver);
Connection conn = DriverManager.getConnection(dbName, userName, password);
Statement statement = conn.createStatement();
String query="Select * from test";
ResultSet rs=statement.executeQuery(query);
printResultSet(response,rs);
rs.close();
statement.close();
conn.close();
}
catch(SQLException ex)
{
out = response.getWriter();
response.setContentType("text/html");
out.println ("SQL Exception: " + ex.getMessage ());
}
catch (Exception ex)
{
out = response.getWriter();
response.setContentType("text/html");
out.println ("Exception: " + ex.getMessage ());
}
}
private void printResultSet ( HttpServletResponse resp,ResultSet rs ) throws SQLException, IOException
{
try
{
PrintWriter out = resp.getWriter();
out.println("<html>");
out.println("<head><title>jbs jdbc/mysql servlet</title></head>");
out.println("<body>");
out.println("<center>");
out.println("<h3>jbsJDBCServlet</h3>");
out.println("<h3>Data Retrieved:</h3>");
out.println("<table border='1'>");
int numCols = rs.getMetaData().getColumnCount ();
while ( rs.next() )
{
out.println("<tr>");
for (int i=1; i<=numCols; i++)
{
out.print("<td>" + rs.getString(i) + "</td>" );
}
out.println("</tr>");
}
out.println("</table>");
out.println("</center>");
out.println("</body>");
out.println("</html>");
out.close();
}
catch ( IOException except)
{
}
}
}
ans4u
servlet accessing MySql ....error
