dbconnection.java~6~

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

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;
        System.out.println("数据库连接成功.........");
    } catch (SQLException ex) {
        ex.printStackTrace();
        return null;
    } catch (ClassNotFoundException ex) {
        ex.printStackTrace();
        return null;
    }

    }
}