JDBC学生管理系统

一、准备工作：

1、创建名为lib的Folder文件，将mysql-connector-java-5.1.44-bin.jar包复制到lib文件里，再单击鼠标右键，点击Build Path/Add to Build Path。

2、在MySQL数据库实例test中创建名为student的表。

二、编写代码：

1、com.zzu.tool包中的类：

package com.zzu.tool.db;

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

public class DBLink {
	private Connection getConnection() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			String url="jdbc:mysql://127.0.0.1:3306/test";
			return DriverManager.getConnection(url,"root","root");
		}catch (Exception e) {
			e.printStackTrace();
		}
		return null;
	}
	public boolean update(String sql) {
		Connection connection = null;
		Statement statement = null;
		try {
			connection = getConnection();
			statement = connection.createStatement();
			int affect = statement.executeUpdate(sql);
			return affect>0;
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			close(statement,connection);
		}
		return false;
	}
	public void select(String sql,IRowMapper rowMapper) { 
		Connection connection = null;                            
		Statement statement = null;
		ResultSet resultSet = null;
		try {
			connection = getConnection();
			statement = connection.createStatement();
			resultSet = statement.executeQuery(sql);
			rowMapper.rowMapper(resultSet);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			close(resultSet,statement,connection);
		}
	}
	public boolean exist(String sql) { 
		Connection connection = null;                            
		Statement statement = null;
		ResultSet resultSet = null;
		try {
			connection = getConnection();
			statement = connection.createS