Java Implementing a JDBC Connection DB instance

1 Importjava.sql.Connection;2 ImportJava.sql.DriverManager;3 ImportJava.sql.ResultSet;4 Importjava.sql.SQLException;5 Importjava.sql.Statement;6 7  Public classJdbctest {8     9     Private Static FinalString url= "Jdbc:mysql://127.0.0.1:3306/student";Ten     Private Static FinalString user= "Root"; One     Private Static FinalString password= "Root"; A  -      Public Static voidMain (string[] args)throwsClassNotFoundException, SQLException { -          the         //1. Loading drivers -Class.forName ("Com.mysql.jdbc.Driver"); -          -         //2. Get a data connection +Connection conn =drivermanager.getconnection (URL, USER, PASSWORD); -          +         //3. Create a claim with a connection to the database AStatement stmt =conn.createstatement (); at          -         //4. Execute SQL statements using claims -ResultSet rs = stmt.executequery ("Select * from Stu"); -          -         //5. Read the database Information -          while(Rs.next ()) { inString id = rs.getstring ("id"); -String name = rs.getstring ("name"); toString sex = rs.getstring ("Sex"); +String score = rs.getstring ("Score"); -System.out.println (id+ "Name:" +name+ ", Gender:" +sex+ ", Score:" +score); the         } *  $     }Panax Notoginseng      -}

Java Implementing a JDBC Connection DB instance