Import java.sql.Connection;
Import Java.sql.DriverManager;
Import java.sql.PreparedStatement;
Import Java.sql.ResultSet;
public class Test {
public static final String dbdriver = "Com.mysql.jdbc.Driver";
Define the connection address of the MySQL database
public static final String Dburl = "Jdbc:mysql://localhost:3306/test"; Connect to a database named T in native MySQL
Connection user name for MySQL database
public static final String DBUSER = "root";
Connection password for MySQL database
public static final String Dbpass = "123456";
public static void Main (String args[]) {
PreparedStatement PS = null;
ResultSet rs = null;
Connection ct = null;
try {
Load Driver
Class.forName (Dbdriver);
Get Connected
ct = drivermanager.getconnection (dburl,dbuser,dbpass);
String sql = "SELECT * from User_login where id=?";
Ps=ct.preparestatement (SQL);
Ps.setstring (1, "1");
Rs=ps.executequery ();
while (Rs.next ()) {
String name = rs.getstring ("username");
SYSTEM.OUT.PRINTLN (name);
}
} catch (Exception e) {
E.printstacktrace ();
}
}
}