jsp mysql 连接错误
老师布置的作业，用jsp连接mysql数据库。我准备了3个文件，index。jsp用于从表单中获取数据（用户名和密码），JDBConnection.java是一个javabean。check。jsp用于检验用户输入的数据（先获取传递过来的用户名和密码，然后检索数据库，做比较，进行简单的判断）。操蛋的j2ee老师，你让我们这些没学java的人情何以堪啊。。。。。
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
代码：
index。jsp
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <base href="<%=basePath%>"> <title>My JSP 'index.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> </head> <body> <form method="get" action="check.jsp"> <table> <tr><td>用户名：<input type="text" name="username" value=""></td></tr> <tr><td>密码：<input type="password" name="password" value=""></td></tr> <tr><td><input type="submit" value="提交" ></td> <td valign="top"><br></td><td valign="top"><br></td><td valign="top"><br></td><td valign="top"><br></td><td><input type="reset" value="取消" ></td></tr> </table> </form> </body></html>
package yours;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class JDBConnection{ private final String dbDriver="com.mysql.jdbc.Driver"; private final String url="jdbc:mysql://localhost:3306/char1_2"; private final String userName="root"; private final String password="1991016"; private Connection con; public JDBConnection() { try{ Class.forName(dbDriver).newInstance(); }catch (Exception e) { System.out.println("未能成功加载驱动!"); } } public boolean createConnection() { try{ con=DriverManager.getConnection(url,userName,password); con.setAutoCommit(true); }catch(SQLException e) { return false; } return true; } public ResultSet executeQuery(String sql) { ResultSet rs; try { if(con==null) createConnection(); Statement stmt =con.createStatement(); rs=stmt.executeQuery(sql); }catch(Exception e) { return null; } return rs; } public void closeConnection() { if(con!=null) { try{ con.close(); }catch(SQLException e) { } } }}
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <base href="<%=basePath%>"> <title>My JSP 'check.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body><%@ page import="java.sql.*" %> <jsp:useBean id="mysql" scope="page" class="yours.JDBConnection"/><%String username=new String(request.getParameter("username"));//接收传递过来的用户名String password=new String(request.getParameter("password"));//接收传递过来的密码String sql="select * from table1";ResultSet rs=null;mysql.createConnection();rs=mysql.executeQuery(sql);String usr1=null;//获取数据库中的用户名String passwd1=null;//获取用户名中的密码boolean flag=false;while(rs.next()){usr1=rs.getString("username");passwd1=rs.getString("password");if(usr1==username&&passwd1==password){out.println("欢迎你，用户："+usr1.toString());flag=true;break;//找到记录就跳出循环//}}if(flag)out.println("没找到你的用户名，"+username.toString()+"没有注册！");rs.close();mysql.closeConnection(); %> </body></html>