db.java 连接数据库文件
package com.hyan.db;
import java.util.ResourceBundle;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.Properties;
import java.io.FileInputStream;
import java.io.InputStream;
import java.io.IOException;
public class db {
private static String drivers;
private static String url;
private static String user;
private static String password;
static {
//这里读db.properties文件
//InputStream in = Object.class.getResourceAsStream("src/db.properties");
try {
Properties prop = new Properties();
InputStream in = new FileInputStream("src/db.properties");
prop.load(in);
url = prop.getProperty("url").trim();
drivers = prop.getProperty("drivers").trim();
user = prop.getProperty("user").trim();
password = prop.getProperty("password").trim();
} catch (IOException e) {
e.printStackTrace();
}
}
public static Connection getConnection() throws SQLException {
package com.hyan.db;
import java.util.ResourceBundle;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.Properties;
import java.io.FileInputStream;
import java.io.InputStream;
import java.io.IOException;
public class db {
private static String drivers;
private static String url;
private static String user;
private static String password;
static {
//这里读db.properties文件
//InputStream in = Object.class.getResourceAsStream("src/db.properties");
try {
Properties prop = new Properties();
InputStream in = new FileInputStream("src/db.properties");
prop.load(in);
url = prop.getProperty("url").trim();
drivers = prop.getProperty("drivers").trim();
user = prop.getProperty("user").trim();
password = prop.getProperty("password").trim();
} catch (IOException e) {
e.printStackTrace();
}
}
public static Connection getConnection() throws SQLException {