jdbc连接数据库--sql server

jdbc.properties

username=sa//sql 用户名
password=sa123//密码
url=jdbc:sqlserver://localhost:1433;databaseName=Bas//sql接口
driver=net.sf.log4jdbc.DriverSpy//jdbc

log4j.properties

log4j.rootLogger=INFO,appender1,appender2
log4j.appender.appender1=org.apache.log4j.ConsoleAppender
log4j.appender.appender1.layout=org.apache.log4j.TTCCLayout
log4j.appender.appender2=org.apache.log4j.FileAppender
log4j.appender.appender2.File=e:/fangjian.log
log4j.appender.appender2.layout=org.apache.log4j.TTCCLayout
log4j.logger.jdbc.sqlonly=DEBUG,sql
log4j.additivity.jdbc.sqlonly=true
log4j.appender.sql=org.apache.log4j.ConsoleAppender
log4j.appender.sqlThreshold=debug
log4j.appender.sqlTarget=System.out
log4j.appender.sqlEncoding=GBK
log4j.appender.sql.layout=org.apache.log4j.PatternLayout
log4j.appender.sql.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss.SSS} %m%n%n

可在网上下载 .jar

新建一个类

public class DButil {
	public static String username = null;
	public static String password = null;
	public static String driver = null;
	public static String url = null;

	// 封装 静态初始化块
	static {
		Properties properties = new Properties();
		// io流 读取jdbc.properties文件
		InputStream inputStream = DButil.class.getClassLoader()
				.getResourceAsStream("jdbc.properties");
		try {
			// 把io流放入Properties实例里
			properties.load(inputStream);
			// 连接数据库 、表名、引用Driver
			username = properties.getProperty("username");
			password = properties.getProperty("password");
			driver = properties.getProperty("driver");
			url = properties.getProperty("url");
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	// 封装数据库连接表
	public static Connection getConnection() throws ClassNotFoundException,
			SQLException {
		// 加载驱动
		Class.forName(driver);
		// 获取数据库表列名
		Connection connection = DriverManager.getConnection(url, username,
				password);
		return connection;
	}
	

	/**
	 * 封装 关闭
	 * 
	 * @param con
	 * @param ps
	 * @param rs
	 */
	public static void close(Connection con, PreparedStatement ps, ResultSet rs) {
		if (rs != null) {
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if (ps != null) {
			try {
				ps.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if (con != null) {
			try {
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}

	}

}