封装DB

页面导航:首页 > 数据库 > DB2 > 封装DB

封装DB

来源: 作者: 时间:2016-01-23 11:15 【

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 { pub...

代码 
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..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; 
        } 
    } 
}

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

Tags:

相关文章

    文章评论

    最 近 更 新
    热 点 排 行
    Js与CSS工具
    代码转换工具
    
    <