封装DB

封装DB

Java代码 
package com.zm.bbs; 
 
import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.sql.Statement; 
 
public class DB { 
    public static Connection getConn(){ 
        Connection conn=null; 
        try { 
            Class.forName("com.mysql.jdbc.Driver"); 
        } catch (ClassNotFoundException e) { 
            // TODO Auto-generated catch block 
            e.printStackTrace(); 
        } 
        try { 
            conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/bbs","root","root"); 
        } catch (SQLException e) { 
            // TODO Auto-generated catch block 
            e.printStackTrace(); 
        } 
        return conn; 
    } 
     
    public static Statement getStmt(Connection conn){ 
        Statement stmt=null; 
        try { 
            stmt=conn.createStatement(); 
        } catch (SQLException e) { 
            // TODO Auto-generated catch block 
            e.printStackTrace(); 
        } 
        return stmt; 
    } 
    public static ResultSet getRs(Statement stmt,String sql){ 
        ResultSet rs=null; 
        try { 
            rs=stmt.executeQuery(sql); 
        } catch (SQLException e) { 
            // TODO Auto-generated catch block 
            e.printStackTrace(); 
        } 
        return rs; 
    } 
     
    public static void close(ResultSet rs){ 
        if(rs!=null){ 
            try { 
                rs.close(); 
            } catch (SQLException e) { 
                // TODO Auto-generated catch block 
                e.printStackTrace(); 
            } 
            rs=null; 
        } 
    } 
     
    public static void close(Statement stmt){ 
        if(stmt!=null){ 
            try { 
                stmt.close(); 
            } catch (SQLException e) { 
                // TODO Auto-generated catch block 
                e.printStackTrace(); 
            } 
            stmt=null; 
        } 
    } 
     
    public static void close(Connection conn){ 
        if(conn!=null){ 
            try { 
                conn.close(); 
            } catch (SQLException e) { 
                // TODO Auto-generated catch block 
                e.printStackTrace(); 
            } 
            conn=null; 
        } 
    } 
}

  作者“不做浮躁的人!!!”