JDBC Operation under Application

Create a new Java project name called TEXTJDBC, create a new com.zss.www package under the SRC folder, and build a class:usedadabase in the package

Build a lb library in MySQL and create a table in it: student, table with Name,age,sex

The Usedadabase code is as follows:

 Packagecom.zss.www;ImportJava.sql.DriverManager;ImportJava.sql.ResultSet;Importjava.sql.Statement;Importcom.mysql.jdbc.Connection; Public classUsedadabase { Public Static voidMain (string[] args)throwsException {//TODO auto-generated Method StubString driver= "Com.mysql.jdbc.Driver"; String URL= "JDBC:MYSQL://LOCALHOST:3306/LB"; String username= "Root"; String Password= "11"; Connection Conn=NULL;        Class.forName (driver); Conn=(Connection) DriverManager. getconnection (Url,username,password); Statement stmt=NULL; ResultSet RS=NULL; stmt=(Statement) conn.createstatement (); RS=stmt.executequery ("Select*from student");  while(Rs.next ()) {System.out.println ("Name=" +rs.getstring (1)); System.out.println ("Age=" +rs.getstring (2)); System.out.println ("Sex=" +rs.getstring (3));        } rs.close ();        Stmt.close ();            Conn.close (); }}

JDBC Operation under Application