dbconnection.java

来自「一个图片管理程序」· Java 代码 · 共 29 行

package com.sunnitech.bean;

import java.sql.Connection;
import java.sql.DriverManager;


public class DBConnection {
    public static Connection getDBConnection() {
        Connection conn = null;

        //String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
        //String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=PicViewDB";
        String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
        String url = "jdbc:odbc:PicDB";
        String user = "sa";
        String pwd = "3a93pc";

        try {
            Class.forName(driver).newInstance();
            conn = DriverManager.getConnection(url, user, pwd);
        } catch(Exception e) {
            System.out.println("DBConnect error: " + e.toString());

            return null;
        }

        return conn;
    }
}