数据库连接

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());
}
}