Javaweb新手,配置jndi后连接数据后总出现异常
报错出现在 myConn = ds.getConnection();
修改my.ini后还是会出现这种问题
配置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("