dbconnection.java~5~

生成主键生成主键生成主键生成主键生成主键生成主键生成主键生成主键生成主键生成主键生成主键生成主键

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);
        return conn;
    } catch (SQLException ex) {
        ex.printStackTrace();
        return null;
    } catch (ClassNotFoundException ex) {
        ex.printStackTrace();
        return null;
    }

    }
}