idea 连接mysql出问题_IDEA tomcat连接数据库出现问题?

Javaweb新手,配置jndi后连接数据后总出现异常

报错出现在 myConn = ds.getConnection();

04348cf4fa759c4d26e18c36549febae.png

修改my.ini后还是会出现这种问题

5dbd62543cf3b5d2febe63d1bde55166.png

配置jndi的context.xml文件

maxActive="100" maxIdle="30" maxWait="10000"

username="root" password="000000"

driverClassName="com.mysql.jdbc.Driver"

url="jdbc:mysql://localhost:3306/studentinfo?">

web.xml文件

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"

version="3.1">

jdbc/studentinfo

javax.sql.DataSource

Container

StudentServlet

init.StudentServlet

StudentServlet

/StudentServlet

java文件

public class StudentServlet extends HttpServlet{

@Override

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

response.setContentType("text/html;charset=GB2312");

PrintWriter out = response.getWriter();

out.println("");

out.println("

StudentInfo");

if((request.getParameter("sno") == null || request.getParameter("sno").equals("input number"))){

out.println("

");

out.println("");

out.println("学号查询:");

out.println("
");

out.println("

");

}else if (!(request.getParameter("sno").equals("input number"))){

Vector vc = new Vector();

out.println("

");

out.println("");

out.println("学生学号:");

out.println("

");

out.println("
");

out.println("

out.println("

学号姓名语文数学");

try {

if((vc = accessDB(Integer.parseInt((String)request.getParameter("sno")))) != null){

out.println("

");

out.println("

" + vc.elementAt(0) + "");

out.println("

" + vc.elementAt(1) + "");

out.println("

" + vc.elementAt(2) + "");

out.println("

" + vc.elementAt(3) + "");

out.println("

");

}

}catch (Exception e){

out.println("

");

out.println("

没有记录:");

out.println("

");

out.println("数据库里没有你要查询得记录");

e.printStackTrace();

}

out.println("

");

}

out.println("");

out.println("

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值