一般认为连接数据库,会把密码写在程序中,这是不方便的,也是不安全的,现在我为大家介绍一种方法。就是把密码放在users.properties配置文件上面,这样一来即方便了管理,也更加安全了。(纪念一下我大二Web课程设计)
users.properties
jdbc.drivers=com.mysql.jdbc.Driver
jdbc.url=jdbc\:mysql\://127.0.0.1/bookshop?useUnicode\=true&characterEncoding\=UTF-8
jdbc.username=root
jdbc.password=12345
java 连接数据库的具体代码:
package com.book.db;
/**
*
* @autor yinxing
*
*
*/
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;
public class DBconnection {
public DBconnection(){
}
private String resource = "users.properties";
private Properties props = null;
// 得到数据库连接
public Connection getConnection()
{
try
{
props = new Properties();
InputStream in = getClass().getResourceAsStream(resource);
props.load(in);
String drivers = props.getProperty("jdbc.drivers");
String url = props.getProperty("jdbc.url");
String username = props.getProperty("jdbc.username");
String password = props.getProperty("jdbc.password");
Class.forName(drivers);//加载数据库驱动
return DriverManager.getConnection(url, username, password);
}
catch (Exception ex)
{
ex.printStackTrace();
System.out.println("连接数据库异常发生 : " + ex.getMessage());
}
return null;
}
}