JDBC实现学生管理系统(连接到MySQL数据库)

工具：

package main;

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

public class DBlink {
	/*try {
		Class.forName("com.mysql.jdbc.Driver");//加载驱动
		String url = "jdbc:mysql://127.0.0.1:3306/test1";//指定连接到哪个数据库，127.0.0.1是本机
		connection=DriverManager.getConnection(url, "root", "root");获取数据库连接
		statement = connection.createStatement();
		long result = statement.executeLargeUpdate(sql);
		statement.close();//如果上面代码出现异常，则该行代码及其下面代码无法执行，所以资源无法释放；比如sql语句语法错误，则statement和connection无法释放
    	connection.close();*/
	private static Connection getConnection() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			String url = "jdbc:mysql://127.0.0.1:3306/test1";
			return DriverManager.getConnection(url, "root","root");
		} catch (Exception e) {
			e.printStackTrace();
		}
		return null;
	}
	
	public static void select(String sql,IRowMapper rowMapper ) {//接口无法创建对象，所以rowMapper参数一定指向IRowMapper接口实现类对象，rowMapper上转型对象
		//此处的rowMapper就是一个形参，到时候接口实现类里的实参再传给它
		Connection connection =null;
		Statement statement =null;
		ResultSet resultSet =null;
		
		try {
			
			connection = getConnection();
			statement = connection.createStatement();
			resultSet = statement.executeQuery(sql);
			rowMapper.rowMapper(resultSet);//因为rowMapper参数指向IRowMapper接口实现类对象，所以此处将调用接口实现类中所实现的rowMapper方法  多态。
			
			
		} catch (Exception e) {

			e.printStackTrace();
		}finally {
			close(resultSet,statement,connection);
		}
	}


	public boolean exist(String sql) {
		Connection connection =null;
		Statement statement =null;
		ResultSet