cn.properties配置的用法

1、cn.properties文件的写法

driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://127.0.0.1:1433; databaseName=shopping
username=sa
password=123

2、调用properties文件的写法

package com;
import java.util.*;
import java.io.*;
import java.sql.*;
public class DBUtil {
	Connection cn = null;
	Properties p = null;
	public Connection getConn(){
		p = new Properties();
		try {
			p.load(DBUtil.class.getClassLoader().getResourceAsStream("cn.properties"));
			String driver =p.getProperty("driver");
			String url = p.getProperty("url");
			String username = p.getProperty("username");
			String password = p.getProperty("password");
			Class.forName(driver);
			cn = DriverManager.getConnection(url,username,password);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return cn;
	}
	
	public void closeConn(){
		try {
			if(cn!=null)
			cn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}