学习java的第51天
我命由我不由天!!!
下面为一个非常简单的登录案例
package com.qf.Job;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
@WebServlet(name = "job",urlPatterns = "/job")
public class job extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("UTF-8");
resp.setContentType("text/html;charset=UTF-8");
String username = req.getParameter("username");
String password = req.getParameter("password");
Connection connection = DButil.getConnection();
// System.out.println(connection);
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
String sql = "select * from un";
try {
preparedStatement = connection.prepareStatement(sql);
resultSet = preparedStatement.executeQuery();
while(resultSet.next()){
String uname = resultSet.getString(1);
String psw = resultSet.getString(2);
if(uname.equals(username) && psw.equals(password)){
System.out.println("登陆成功");
resp.sendRedirect("/day11/html/win.html");
break;
}
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DButil.closeAll(connection,preparedStatement,resultSet);
}
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req, resp);
}
}
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>登录</title>
</head>
<body>
<form action="../job" method="post">
<input type="text" name="username" placeholder="请输入账号"></br>
<input type="password" name="password" placeholder="请输入密码"></br>
<input type="submit" value="登录">
</form>
</body>
</html>