关于JSP连接数据库出现的问题,望大神指点
啊啊啊啊柴 2017-12-20 09:34:16 首先我说一下出现的问题吧
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ''@'localhost' (using password: YES))
................
Caused by: java.sql.SQLException: Access denied for user ''@'localhost' (using password: YES)
.................
然后这是我的连接池配置
<?xml version="1.0" encoding="UTF-8"?>
<Context>
<WatchedResource>WEB-INF/web.xml</WatchedResource> <!-- 监听资源 -->
<Resource
name="jdbc/dataexam"
auto="Container"
type="javax.sql.DataSource"
driverClassName="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://localhost:3306/dataexam"
usename="root"
password="962432174"
MaxActive="5000"
maxIdle="10"
maxWait="-1"
></Resource>
</Context>
然后是测试代码
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="javax.naming.Context" %>
<%@ page import="javax.sql.DataSource" %>
<%@ page import="javax.naming.InitialContext" %>
<%@ page import="java.sql.*" %>
<%@ page import="myclass.dal.*" %>
<%@ page import="myclass.bol.*" %>
<%@ page import="java.util.ArrayList" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
1234
<%DBAcess dba = new DBAcess();
examineeDal examd=new examineeDal();
ArrayList<examinee> list =new ArrayList<examinee>();
try{
int rsult=
examd.CreateExaminee("123635673879","黄呵呵","女","江西师范大学","江西南昌","17379245533","kind@163.com","123456","中级","");
out.print(rsult);
dba.getConnection();
if(dba.getConn()!=null){
out.println("已经获得DataSourece");
out.println("<br>");
String str="select * from examinee";
ResultSet rst = dba.query(str);
out.println("一下是读取的数据<br>");
while(rst.next()){
out.println("<br>");
out.println(rst.getString(1));
}
out.println("系统时间:"+DBAcess.getSysDate());
examinee exambean = null;
exambean=examd.getExamineeByID("123635673879");
out.println("<br><br>"+exambean.getExamID());
list=examd.getExamineeAll();
for(examinee e:list){
out.println("<br>这个是死通过ArrayList得到的值:"+e.getExamID());
}
}
}catch(Exception ne){
out.println("出现如下错误:<br>");
out.println(ne);
}finally{
dba.closeConnection();
out.println("<br>已关闭DataSource!");
}
%>
</body>
</html>
运行结果无法返回数据库的数据,也就意味无法连接数据库
运行结果为:
1234 0
已关闭DataSource!