封装JDBC工具类进行操作

package com.java12.jdbc.intro;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class JDBCDemo6 {
	/**
	 * 
	 *	 把数据库操作封装成一个工具类
	 * 
	 */
	 static Connection connection;
	 static Properties properties;
	 static String url;
	static {
		properties = new Properties();
		try {
			properties.load(JDBCDemo6.class.getClassLoader().getResourceAsStream("text_info"));	
		} catch (IOException e) {
			System.out.println("配置文件读取错误");
			e.printStackTrace();
		} 	
		url = properties.getProperty("url");
	}
	public static Connection getconnection() {
		try {
			connection = DriverManager.getConnection(url, properties);
		} catch (SQLException e) {	
			System.out.println("数据库连接失败");
			e.printStackTrace();
		}
		return connection;
	}
	public static void close(ResultSet set,PreparedStatement prepareStatement,Connection conn) {
		
			try {
				if(set != null) {
					set.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
			try {
				if(prepareStatement != null) {
					prepareStatement.close();
				}
				
			} catch (SQLException e) {
				e.printStackTrace();
			}
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
	}

}

package com.java12.jdbc.intro;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class JDBCDemo5 {
	/**
	 * 
	 * 测试封装的工具类是否能用
	 * 
	 */
	public static void text_jdbc() {
		Connection conn = JDBCDemo6.getconnection();
		String sql = "select * from users where id = ? ";
		try {
			PreparedStatement prepareStatement = conn.prepareStatement(sql);
			prepareStatement.setInt(1, 8);
			ResultSet resultSet = prepareStatement.executeQuery();
			
			while(resultSet.next()) {
				System.out.println(resultSet.getObject("name"));
			}
			JDBCDemo6.close(resultSet, prepareStatement, conn);
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("sql执行失败");
		}

	}
	public static void main(String[] args) {
		JDBCDemo5.text_jdbc();
	}
}