dbutil.java

java开发中的 数据分页

package com.jgxy.util;

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

public class DBUtil {
	private static String drv = "com.mysql.jdbc.Driver";

	private static String url = "jdbc:mysql://localhost:3306/page";

	private static String usr = "root";

	private static String pwd = "root";

	public static Connection getConnection(){
		Connection conn=null;
		try{
			Class.forName(drv);
			conn=DriverManager.getConnection(url, usr, pwd);
		}catch(ClassNotFoundException e){
			e.printStackTrace();
		}catch(SQLException e){
			e.printStackTrace();
		}
		catch(Exception e){
			e.printStackTrace();
		}
		return conn;
	}
	
	public static Statement getStatement(Connection conn){
		Statement stmt=null;
		try{
			stmt=conn.createStatement();
		}catch(SQLException e){
			e.printStackTrace();
		}
		return stmt;
	}
	
	public static PreparedStatement getPreparedStatement(Connection conn,String sql){
		PreparedStatement pstmt=null;
		try{
			pstmt=conn.prepareStatement(sql);
		}catch(SQLException e){
			e.printStackTrace();
		}
		return pstmt;
	}
	
	public static ResultSet getResultSet(Statement stmt,String sql){
		ResultSet rs=null;
		try{
			rs=stmt.executeQuery(sql);
		}catch(SQLException e){
			e.printStackTrace();
		}
		return rs;
	}
	
	public static void closeConn(Connection conn) {
		try {
			if (conn != null)
				conn.close();
		} catch (SQLException e) {
		}
	}

	public static void closeStm(Statement stm) {
		try {
			if (stm != null)
				stm.close();
		} catch (SQLException e) {
		}
	}

	public static void closeRs(ResultSet rs) {
		try {
			if (rs != null)
				rs.close();
		} catch (SQLException e) {
		}
	}

}