JDBC连接数据库_DBConnection0.java_20130912

最新推荐文章于 2021-03-04 17:02:14 发布

sh666_

最新推荐文章于 2021-03-04 17:02:14 发布

阅读量865

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/shihuafu_/article/details/11618895

版权

java 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

package JDBCDemo;
import java.sql.*;
public class DBConnection {
	public static String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	//public static String url = "jdbc:sqlserver://127.0.0.1:1434;DatabaseName=member";
	public static String url = "jdbc:sqlserver://SHIHUAFU/SHIHUASQLSERVER:1433;DatabaseName=member";
	public static String username="sa";
	public static String password="shihua";
	
	public static Connection getConn(){
		Connection conn = null;
		if (conn==null) {
			try {
				Class.forName(driverName);
				conn = DriverManager.getConnection(url,username,password);				
			} catch (ClassNotFoundException e) {
				// TODO: handle exception
				System.out.println("jar包可能未导入");
			}catch (SQLException e) {
				// TODO: handle exception
				System.out.println("请检查数据库url和用户名密码");
			}
		}
		return conn;
	}	
}