- 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("登录失败");
}
%>