由于进行此方法的实现,需要用到文件db和数据库工具类DButil,这里先将这两个东西处理好。
db:文件名db.properties,注意后缀,可以在上一篇文章找到相关注意事项。
db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost:3306/test11
db.username=username
db.password=password
DButil:
package day04;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class DButil {
private static String driver;
private static String url;
private static String name;
private static String password;
private static Connection conn;
static {
try {
Properties p=new Properties();
InputStream in=DButil.class.getResourceAsStream("db.properties");
p.load(in);
driver=p.getProperty("db.driver");
url=p.getProperty("db.url");
name=p.getProperty("db.username");
password=p.getProperty("db.password");
} catch (IOException e) {
e.printStackTrace();
}
}
public static Connection getConn(){
try {
Class.forName(driver);