jdbcUtils的使用

jdbcUtils使用

主函数

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

public static void main(String[] args) throws SQLException {
		//调用工具类的方法
		Connection conn = jdbcUtils.getConnection();
		//编写sql语句
		String sql = "select sname from sort";
		//预编译
		PreparedStatement pas = conn.prepareStatement(sql);
		//处理结果集
		ResultSet rs = pas.executeQuery();
		while(rs.next()){
			System.out.println(rs.getString("sname"));
		}
		//关闭资源
		jdbcUtils.close(conn,pas,rs);
	}

写jdbcUtils的连接驱动

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

public class jdbcUtils {
	private static final String driverClassName;
	private static final String url;
	private static final String username;
	private static final String password;
	//编写静态代码块
	static{
		//1.注册驱动
		driverClassName = "com.mysql.jdbc.Driver";
		//2.获得连接
		url = "jdbc:mysql://localhost:3306/mybase";
		username = "root";
		password = "123456";
	}
	//编写注册驱动
	public static void loadDriver(){
		try {
			Class.forName(driverClassName);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	//获得连接
	public static Connection getConnection(){
		Connection conn = null;
		try { 
			loadDriver();
			conn = DriverManager.getConnection(url,username,password);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}
	//释放资源
	public static void close(Connection conn, Statement st){
		if(conn != null){
			try{
				conn.close();
			}catch(SQLException e){
				e.printStackTrace();
			}
			conn = null; 
		}
		conn = null; 
		if(st != null){
			try{
				st.close();
			}catch(SQLException e){
				e.printStackTrace();
			}
		}
		st = null;
	}
	//释放资源
	public static void close(Connection conn, Statement st,ResultSet rs){
		if(conn != null){
			try{
				conn.close();
			}catch(SQLException e){
				e.printStackTrace();
			}
			conn = null; 
		}
		conn = null; 
		if(st != null){
			try{
				st.close();
			}catch(SQLException e){
				e.printStackTrace();
			}
		}
		st = null;
		if(rs != null){
			try{
				rs.close();
			}catch(SQLException e){
				e.printStackTrace();
			}	 
		}
		rs = null;
	}
}

另一种形式的配置方法

特别注意配置的时候不要加分号