mySQL配置文件报静态代码块执行异常,连接数据库失败，mySQL已开

weixin_42504422 2018-06-27 09:27:32

public class JDBCUtilsConfig {
private static Connection con ;
private static String driverClass;
private static String url;
private static String username;
private static String password;
/*public static void main(String[] args) throws Exception{
readConfig();
System.out.println(driverClass);
System.out.println(url);
System.out.println(username);
System.out.println(password);

}*/
//打印的几项都没有任何问题
/*static {
try {
readConfig();
Class.forName(driverClass);
con = DriverManager.getConnection(url, username, password);
}catch(Exception ex) {
throw new RuntimeException("连接数据库失败");
}
}*/

private static void readConfig() throws Exception{
InputStream in = JDBCUtilsConfig.class.getClassLoader().getResourceAsStream("database.properties");
Properties pro = new Properties();
pro.load(in);
driverClass=pro.getProperty("driverClass");
url = pro.getProperty("url");
username = pro.getProperty("username");
password = pro.getProperty("password");
}

public static Connection getConnection() {
return con;
}

...全文

82 1 打赏收藏转发到动态举报

写回复

用AI写文章

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

weixin_42504422 2018-06-27

打赏
举报

//方便大家阅读

public class JDBCUtilsConfig {

	private static Connection con ;

	private static String driverClass;

	private static String url;

	private static String username;

	private static String password;

	/*public static void main(String[] args) throws Exception{

		readConfig();

		System.out.println(driverClass);

		System.out.println(url);

		System.out.println(username);

		System.out.println(password);

	//这里打印的几项确定没有问题	

	}*/

	static {

		try {

			readConfig();

			Class.forName(driverClass);

			con = DriverManager.getConnection(url, username, password);

		}catch(Exception ex) {

			throw new RuntimeException(ex+"连接数据库失败");

		}

	}

	

	private static void readConfig() throws Exception{

		InputStream in = JDBCUtilsConfig.class.getClassLoader().getResourceAsStream("database.properties");

		 Properties pro = new Properties();

		 pro.load(in);

		 driverClass=pro.getProperty("driverClass");

		 url = pro.getProperty("url");

		 username = pro.getProperty("username");

		 password = pro.getProperty("password");

	}

	

	public static Connection getConnection() {

		return con;

	}