//连接的工具类
package Connection;
import java.sql.*;
import java.util.Properties;
import java.io.*;
public class JdbcUtils {
private static Properties props = null;
static {
try{
InputStream in = JdbcUtils.class.getClassLoader()
.getResourceAsStream("dbconfig.properties");
props = new Properties();
props.load(in);
} catch(Exception e){
e.printStackTrace();
}
try{
Class.forName(props.getProperty("driverClassName"));
}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
public static Connection getConnection()throws Exception{
return DriverManager.getConnection(props.getProperty("url"),
props.getProperty("userName"),
props.getProperty("password"));
}
}
//jsp调用
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"
import="java.sql.*,Connection.JdbcUtils"
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
My JSP 'Demo.jsp' starting page
<%
try{
out.println("aa");
Connection con = JdbcUtils.getConnection();
out.println(con);
} catch(Exception e){
e.printStackTrace();
}
%>
//错误提示
HTTP Status 500 - javax.servlet.ServletException: java.lang.ExceptionInInitializerError
求指点
