jsp mysql 连接异常-Java教程-爱易网页

jsp mysql 连接异常

日期：2014-05-17　浏览次数：20683 次

jsp mysql 连接错误
老师布置的作业，用jsp连接mysql数据库。我准备了3个文件，index。jsp用于从表单中获取数据（用户名和密码），JDBConnection.java是一个javabean。check。jsp用于检验用户输入的数据（先获取传递过来的用户名和密码，然后检索数据库，做比较，进行简单的判断）。操蛋的j2ee老师，你让我们这些没学java的人情何以堪啊。。。。。
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
代码：
index。jsp

Assembly code


<%@ 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>

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
JDBConnection.java（在包yours下）的源码:

Assembly code

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);

免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。

jsp mysql 连接异常

相关资料更多>

推荐阅读更多>