注册 登录
编程论坛 J2EE论坛

servlet编程问题

tianshikun 发布于 2013-01-04 09:26, 475 次点击
这个程序错在哪里?为什么会连接不了数据库:
try{
            
        
            Class.forName("org.gjt.mm.mysql.Driver");
            logconn=java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3307/lvddb","root","15186986877");
            logStmt=logconn.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE,
                    java.sql.ResultSet.CONCUR_READ_ONLY);
            strq="select user,password from lvduserdb";
            logRst=logStmt.executeQuery(strq);
            user2=logRst.getString("username");
            pass2=logRst.getString("password");
            if(user1.equals(user2)&&pass1.equals(pass2)){
                RequestDispatcher dispatcher=request.getRequestDispatcher("asssportcom.jsp");
                dispatcher.forward(request,response);
            }else{
                RequestDispatcher dispatcher=request.getRequestDispatcher("login.html");
                dispatcher.forward(request,response);
            }
        }catch(SQLException e){
            System.out.println(e.toString());
        }catch(Exception e){
        System.out.println(e.toString());
        }
        finally{
            System.out.println("0");
        }
2 回复
#2
zhoufeng19882013-01-08 00:19
1、你的MySQL JDBC驱动是对的吗?org.gjt.mm.mysql.Driver这个是早期的驱动,现在一般都用com.mysql.jdbc.Driver。
2、jdbc:mysql://localhost:3307/lvddb,这个URL是正确的吗?
#3
skyusrlx2013-01-15 23:14
默认端口是3306吧,确定没有更改过端口啥的? 同意楼上的观点
1