使用Java代码关联数据库制作一个简单的图书馆管理系统【附全代码】

使用Java代码关联数据库制作一个简单的图书馆管理系统

1、首先创建一个File ，后缀名为properties方便我们代码中使用关键字，减少代码

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/myschool?useSSL=false
user=root
password=root

2、创建一个自己的工具类，目的同上

package com.huzheng.jdbc;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;



public class JDBCUtils {
   

	private static String driver;
	private static String url;
	private static String user;
	private static String password;
	
//	封装四个参数
	
	static {
   
		//初始化4个参数
		Properties properties = new Properties();
		try {
   
			properties.load(new FileInputStream("jdbc.properties"));
			
			driver = properties.getProperty("driver");
			url = properties.getProperty("url");
			user = properties.getProperty("user");
			password = properties.getProperty("password");
			
		} catch (FileNotFoundException e) {
   
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
   
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	//加载驱动
		static{
   
			 try {
   
				Class.forName(driver);
			} catch (ClassNotFoundException e) {
   
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	
	//封装获取连接
		public static Connection getConnection() {
   
			 try {
   
				return DriverManager.getConnection(url, user, password);
			} catch (SQLException e) {
   
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			 return null;
		}
	
	//封装关闭资源
		public static void closeAll(ResultSet rs,Statement pstmt,Connection conn) {
   
			try {
   
				if(rs != null) {
   
					rs.close();
				}
			} catch (SQLException e) {
   
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
   
				if(pstmt != null) {
   
					pstmt.close();
				}
				
			} catch (SQLException e) {
   
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
   
				if(conn != null) {
   
					conn.close();