dbconnection.java

来自「生成主键生成主键生成主键生成主键生成主键生成主键生成主键生成主键生成主键生成主键」· Java 代码 · 共 27 行

package com.qidi;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.sql.*;
public class DBconnection {
    static String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
    static String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=mydata";
    static String user="sa";
    static String password="123456";

    public static Connection getConnection(){
    try {
        Class.forName(driver);
        Connection conn = DriverManager.getConnection(url, user, password);
        System.out.println("数据库连接成功.........");
        return conn;

    } catch (SQLException ex) {
        ex.printStackTrace();
        return null;
    } catch (ClassNotFoundException ex) {
        ex.printStackTrace();
        return null;
    }

    }
}