qq_35025339 2017-03-08 12:32 采纳率: 0%
浏览 1036

有关jsp运用jdbc,数据库设置并没有错呀,但是jsp就是老是空指针异常

  1. package connector;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class User {

private  String username="";
private  String password="";
public User(){};
public User(String username, String password){
    this.username = username;
    this.password = password;
}
public  String getUsername() {
    return username;
}
public  void setUsername(String username) {
    this.username = username;
}
public  String getPassword() {
    return password;
}
public  void setPassword(String password) {
    this.password = password;
}
//查看是否存在该用户以及是否密码正确
public boolean isUser() throws Exception{
    Connection ct = Database.getCon();
    if(ct==null)
        System.out.println("ct is null");
    Statement st = ct.createStatement();
    ResultSet rs = st.executeQuery("select * from usernameandpassword");
    while(rs.next()){
        if(rs.getString("username").equals(this.username) && rs.getString("password").equals(this.password))
            return true;
    }
    return false;
}

}
2. package connector;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Database {
private static final String USER="root";
private static final String PASSWORD="root";
private static final String URL="jdbc:mysql://localhost:3306/debate";
private static Connection con=null;
private static PreparedStatement pstat;

public Database(){}
static{
    try {
        Class.forName("com.mysql.jdbc.Driver");
        con = DriverManager.getConnection(URL,USER,PASSWORD);
    } catch (Exception e) {
        e.printStackTrace();
    }
}
public static Connection getCon(){
        return con;
}

}
3. <%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ page import="connector.User" %>
<!DOCTYPE html>



do_login


<% request.setCharacterEncoding("utf-8"); %>
<%!String username="";String password=""; %>
<%!User user = new User(); %>
<%
username=request.getParameter("username");
password=request.getParameter("password");
user.setUsername(username);
user.setPassword(password);
if(user.isUser()){
out.println("登录成功");
}else{
out.println("登录失败");
}
%>


  • 写回答

3条回答 默认 最新

  • 关注

    把报错信息贴出来一下

    评论

报告相同问题?

悬赏问题

  • ¥20 有关区间dp的问题求解
  • ¥15 多电路系统共用电源的串扰问题
  • ¥15 slam rangenet++配置
  • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
  • ¥15 对于相关问题的求解与代码
  • ¥15 ubuntu子系统密码忘记
  • ¥15 信号傅里叶变换在matlab上遇到的小问题请求帮助
  • ¥15 保护模式-系统加载-段寄存器
  • ¥15 电脑桌面设定一个区域禁止鼠标操作
  • ¥15 求NPF226060磁芯的详细资料