JavaJDBC实现数据库（MySQL）增删改查

package javaTest;

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

public class Util {
	public static void register() {
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			System.out.println("加载数据库驱动类失败");
		}
	}
	
	public static Connection getConnection() {
		register();
		String url ="jdbc:mysql://localhost/Student?&useSSL=false&serverTimezone=UTC";
		String user = "root";
		String pass = "123456";
		Connection con =null;
		try {
			con = DriverManager.getConnection(url,user,pass);
			System.out.println("数据库连接成功");
		}catch(Exception e)
		{
			e.printStackTrace();
			System.out.println("数据库连接失败");
		}
		return con;
	}
	
}

package javaTest;

import java.sql.*;
import javaTest.Util;

public class Test {

	public static void main(String[] args) {
		try {
			//insert();
			//update();
			//delete();
			Select();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	static void insert() throws SQLException{
		Connection con = Util.getConnection();
		Statement st = con.createStatement();
		//返回值表示本次影响的行数
		int rs = st.executeUpdate("insert into Login (UserName,Password)values('Admin','Admin')");
		System.out.println("影响行数"+rs);
		st.close();
		con.close();
	}
	
	static void update() throws SQLException{
		Connection con = Util.getConnection();
		Statement st = con.createStatement();
		//返回值表示本次影响的行数
		int rs = st.executeUpdate("update Login set Password='user' where id =1");
		System.out.println("影响行数"+rs);
		st.close();
		con.close();
	}
	
	static void delete() throws SQLException{
		Connection con = Util.getConnection();
		Statement st = con.createStatement();
		//返回值表示本次影响的行数
		int rs = st.executeUpdate(" delete from Login where id =1 ");
		System.out.println("影响行数"+rs);
		st.close();
		con.close();
	}
	
	static void Select() throws SQLException{
		Connection con = Util.getConnection();
		Statement st = con.createStatement();
		ResultSet rs = st.executeQuery("Select id as \"序列\",UserName,Password from Login");
		//用于判断是否有下一条数据，有则ture没有则false,并让下标下移
		while(rs.next())
		{
			System.out.println(rs.getInt("序列")+","+rs.getString(2)+","+rs.getString(3));
		}
		st.close();
		con.close();
	}
}