查询代码:
package JDBC;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class text {
private static String jdbcurl = "jdbc:mysql://localhost:3306/qwe";
private static String name = "root";
private static String password = "666666";
private static String jdbcname = "com.mysql.jdbc.Driver";
public Connection make_ready() throws Exception {
Class.forName(jdbcname);
Connection con = DriverManager.getConnection(jdbcurl, name, password);
return con;
}
public void make_close(Statement stmt, Connection con) throws Exception {
stmt.close();
con.close();
}
public static void main(String[] args) throws Exception // 为什么加,我也不知道。
{
String sql = "select * from student";
text x = new text();
Connection con = x.make_ready();
PreparedStatement pstmt = con.prepareStatement(sql);
ResultSet z=pstmt.executeQuery(); // 这个函数是用来统计有多少列的。
while(z.next())
{
int id=z.getInt("id");
String name=z.getString("name");
int age=z.getInt("age");
System.out.println(id+" "+name+" "+age);
}
x.make_close(pstmt, con);
}
}