import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
import java.util.logging.Level;
import java.util.logging.Logger;
public class Conn {
private String fileName="/db.properties";//这里是指放在classes下,如果有包的话,前面加包名即可。例:/com/web/db.properties
private String driver = "";
private String url = "";
private String username ="";
private String password = "";
Connection conn=null;
public Connection getConn(){
Properties p = new Properties();
try {
InputStream in = Conn.class.getResourceAsStream(fileName);//这里有人用new FileInputStream(fileName),不过这种方式找不到配置文件。有人说是在classes下,我调过了,不行。
p.load(in);
in.close();
if(p.containsKey("driver")){
this.driver = p.getProperty("driver");
}
if(p.containsKey("url")){
this.url = p.getProperty("url");
}
if(p.containsKey("user")){
this.username = p.getProperty("user");
}
if(p.containsKey("password")){
this.password = p.getProperty("password");
}
} catch (IOException ex) {
Logger.getLogger(Conn.class.getName()).log(Level.SEVERE, null, ex);
}
System.out.println(p.getProperty("driver"));
try {
Class.forName(this.driver);
conn = DriverManager.getConnection(this.url,this.username,this.password);
} catch (SQLException ex) {
ex.printStackTrace();
System.out.print("获取连接异常");
} catch (ClassNotFoundException ex) {
System.out.print("加载驱动出错");
ex.printStackTrace();
}
return conn;
}
}
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
import java.util.logging.Level;
import java.util.logging.Logger;
public class Conn {
private String fileName="/db.properties";//这里是指放在classes下,如果有包的话,前面加包名即可。例:/com/web/db.properties
private String driver = "";
private String url = "";
private String username ="";
private String password = "";
Connection conn=null;
public Connection getConn(){
Properties p = new Properties();
try {
InputStream in = Conn.class.getResourceAsStream(fileName);//这里有人用new FileInputStream(fileName),不过这种方式找不到配置文件。有人说是在classes下,我调过了,不行。
p.load(in);
in.close();
if(p.containsKey("driver")){
this.driver = p.getProperty("driver");
}
if(p.containsKey("url")){
this.url = p.getProperty("url");
}
if(p.containsKey("user")){
this.username = p.getProperty("user");
}
if(p.containsKey("password")){
this.password = p.getProperty("password");
}
} catch (IOException ex) {
Logger.getLogger(Conn.class.getName()).log(Level.SEVERE, null, ex);
}
System.out.println(p.getProperty("driver"));
try {
Class.forName(this.driver);
conn = DriverManager.getConnection(this.url,this.username,this.password);
} catch (SQLException ex) {
ex.printStackTrace();
System.out.print("获取连接异常");
} catch (ClassNotFoundException ex) {
System.out.print("加载驱动出错");
ex.printStackTrace();
}
return conn;
}
}
本文介绍了一个使用Java进行数据库连接的方法,通过从配置文件读取数据库连接参数,包括驱动、URL、用户名和密码,并利用这些参数建立数据库连接。
4927

被折叠的 条评论
为什么被折叠?



