1.jdbc.properties mysql
Driver=com.mysql.jdbc.Driver
Url=jdbc:mysql://localhost:3306/jsp_db?useSSL=false
Username=root
Password=root
2.ConnectionFactory
package com.qdtx.util;
import java.io.IOException;import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;
public class ConnectionFactory {
private static String driver;
private static String url;
private static String username;
private static String password;
private static final ConnectionFactory factory = new ConnectionFactory();
private static Connection conn;
static {
Properties prop = new Properties();
InputStream in = ConnectionFactory.class.getClassLoader().getResourceAsStream("jdbc.properties");
try {
prop.load(in);
} catch (IOException e) {
e.printStackTrace();
System.out.println("配置文件错误");
}
driver = prop.getProperty("Driver");
url = prop.getProperty("Url");
username = prop.getProperty("Username");
password = prop.getProperty("Password");
}
private ConnectionFactory() {
}
public static ConnectionFactory getInstance() {
return factory;
}
public Connection getConnection() {
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, username, password);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
}
3.ConectionFatoryTest
package com.qdtx.util;
import java.sql.Connection;
public class ConectionFatoryTest {
public static void main(String[] args) throws Exception {
ConnectionFactory cf = ConnectionFactory.getInstance();
Connection conn = cf.getConnection();
System.out.println(conn.getAutoCommit());
}
}