db.java

来自「Bug管理系统」· Java 代码 · 共 48 行

package db;

import java.sql.*;

//数据库操作类:只实现数据库的连接和关闭
public class Db{
    public Connection conn=null;
    public Db()
    {

    }
    //数据库连接方法
    public void getCon(String dbName){
        try {
            if (conn==null||(conn.isClosed())) {
                //Oracle驱动注册
                //Class.forName("oracle.jdbc.driver.OracleDriver");
                //conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:"+dbName,"scott","tiger");
                //SqlServer驱动注册
                Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
                conn = DriverManager.getConnection(
                        "jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=sa;databaseName=" +
                        dbName);
            }
        }
        catch (Exception e) {
            System.out.println("连接不成功！\n" + e.getMessage());
        }
    }
    //数据库的关闭方法
    public void closeConnection(){
        try {
            if (conn != null && (!conn.isClosed()))
                conn.close();
        }
        catch (Exception e) {
            System.out.println("关闭操作不成功！\n" + e.getMessage());
        }
    }
/*    static public void main(String args[])
    {
        Db d=new Db();
        d.getCon("pubs");
        System.out.println("adf");
        d.closeConnection();
    }*/
}