JSP connection MySQL Database

Jar package import;

Code:

<%@ page language= "Java"Import= "java.util.*" pageencoding= "gb2312"%> <%@ pageImport= "java.sql.Connection"%> <%@ pageImport= "Java.sql.DriverManager"%> <%@ pageImport= "Java.sql.ResultSet"%> <%@ pageImport= "java.sql.SQLException"%> <%@ pageImport= "Java.sql.DriverManager"%> <%@ pageImport= "Java.sql.Statement"%>Connection con; Statement SQL; ResultSet rs;Try{Class.forName ("Com.mysql.jdbc.Driver"). newinstance ();}Catch(Exception e) {out.print (e);}Try{String URI= "Jdbc:mysql://localhost:3306/mysql"; Con=drivermanager.getconnection (URI, "root", "xxxxxxx")); SQL=con.createstatement (); RS=sql.executequery ("Select Host,user from User"); Out.print ("<table border=2>"); Out.print ("<tr>"); Out.print ("<th width=100>" + "Host"); Out.print ("<th width=100>" + "User"); Out.print ("</tr>");  while(Rs.next ()) {Out.print ("<tr>"); Out.print ("<td>" +rs.getstring (1) + "</td>"); Out.print ("<td>" +rs.getstring (2) + "</td>"); Out.print ("</tr>"); } out.print ("</table>"); Con.close ();}Catch(SQLException E1) {Out.print (e1);}%></body>
JSP connection MySQL Database