problem in type 4 driver

[Punit Jain]

i m getting an error in this code..

public class FirstServlet extends HttpServlet {
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
		String firstname=request.getParameter("firstname");		
		String lastname=request.getParameter("lastname");	
		String query = "INSERT INTO student values ('"+firstname+"','"+lastname+"')";
		try{
		Class.forName("com.mysql.jdbc.Driver");
		 Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/student data?user=root&pass=");
		Statement st=conn.createStatement();
		int i = st.executeUpdate(query);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
}

error is in these two line:

Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/student data?user=root&pass=");
Statement st=conn.createStatement();

and error is:

Type mismatch: cannot convert from java.sql.Statement to com.mysql.jdbc.Statement

although i have added mysqlConnector to my jar files, but still i m getting the same error..???

[Rob Spoor]

You should never import any driver specific classes, but instead program against the JSE interfaces. You've probably used an IDE to resolve the import and chose the wrong one. So instead of importing com.mysql.jdbc.Statement, import java.sql.Statement.

[Punit Jain]

yeah , i m using IDE..
thanks...