jdbconnection.java

电话号码查询系统 要求有电话录入

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

public class JDBConnection {

	private static Connection conn;

	public static Connection getConn() {
		String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
		String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433";
		String userName = "sa";
		String pwd = "";
		try {
			Class.forName(driverName);
			conn = DriverManager.getConnection(url, userName, pwd);
		} catch (ClassNotFoundException e) {
			System.out.println("装载驱动出错！");
		} catch (SQLException e) {
			System.out.println("获取数据库连接出错！");
			e.printStackTrace();
		}

		return conn;
	}
}