Java SE 使用JDBC对mysql数据库的增删改查 （法二）

Insert1.java

package school;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class Insert1 {

	public static void main(String[] args) throws Exception {
		// TODO Auto-generated method stub
		Class.forName("com.mysql.cj.jdbc.Driver");
		  Connection conn = DriverManager.getConnection(
		    "jdbc:mysql://localhost:3306/school?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false", "root", "root");
		  
		  Statement stat = conn.createStatement();
		  String sql = "INSERT INTO T_STUDENT(STUNO,STUNAME,STUSEX) VALUES('12436109','fantasy','m')";
		  
		  int i = stat.executeUpdate(sql);
		  System.out.println("请求权" + i + "请求权");
		  stat.close();
		  conn.close();
	}

}

Select.java

package school;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class select1 {

	public static void main(String[]args) throws Exception{
		Class.forName("com.mysql.cj.jdbc.Driver");
		  Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/School?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false","root","root");
		  Statement stat = conn.createStatement();
		  String sql =
		"SELECT STUNO,STUNAME FROM T_STUDENT WHERe STUSEX='m'";
		  ResultSet rs = stat.executeQuery(sql);
		  while(rs.next()){
		   String stuno = rs.getString("STUNO");
		   String stuname = rs.getString("STUNAME");
		   System.out.println(stuno + "  " + stuname);
		  }
		  stat.close();
		  conn.close();
		
	}
	
}