JDBC基本语句插入、查询

//定义驱动程序
private String demo = “com.mysql.jdbc.Driver”;
//定义url；jdbc是协议；mysql数据库系统管理名称，localhost：3306本地数据库端口，test为数据库名
private String url = “jdbc:mysql://localhost:3306/test?”
+ “useUnicode=true&characterEncoding=UTF8”; //表示使用Unicode字符集
private String user = “root”; //Mysql用户名
private String pass = “root”;//密码
----------------------------------------------
//插入语句
String insertSql = “insert into student values(?,?)”;
//建立连接
Class.forName(demo);
// 获得数据连接
Connection conn = DriverManager.getConnection(url, user, pass);
// 创建一个Statement对象
PreparedStatement ps = conn.prepareStatement(insertSql);
ps.setString(1, num);//设置参数1
ps.setString(2, name);//设置参数2
ps.executeUpdate();// 执行sql语句
conn.close();// 关闭数据库连接对象

//查询语句
Class.forName(demo);
Connection conn = DriverManager.getConnection(url, user, pass);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(“select * from student”);//结果返回
while (rs.next()) {//当还有下一个未读数据
String num = rs.getString(“S#”);
String name = rs.getString(“Sname”);
System.out.println(“学号：” + num + " 用户名：" + name);
}