1、cn.properties文件的写法
2、调用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();
}
}
}