The Third------JAVA使用servlet实现简单登录操作
主要操作
- 简单页面编写(前端)
- 获取数据库数据
- 判断数据是否正确
- 输出
结果截图
代码展示
首先新建web项目,编写前端代码index.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>$Title$</title>
</head>
<body>
<form action="/login" method="post">
username:<input name="username" type="text">
password:<input name="password" type="password">
<input type="submit" value="login">
</form>
</body>
</html>
修改web.xml
<servlet>
<servlet-name>HelloServlet</servlet-name>
<servlet-class>com.zr.servlet.HelloServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>HelloServlet</servlet-name>
<url-pattern>/hello</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>LoginServlet</servlet-name>
<servlet-class>com.zr.servlet.LoginServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>LoginServlet</servlet-name>
<url-pattern>/login</url-pattern>
</servlet-mapping>
连接数据库(这里使用了The Second中的代码片)
用户和密码使用自己获取
String sql = "select * from tb_user where username = ? and password = ?";
statement = connection.prepareStatement(sql);
statement.setString(1,username);
statement.setString(2,password);
resultSet = statement.executeQuery();
while (resultSet.next()) {
User user = new User();
user.setId(resultSet.getInt(1));
user.setUsername(resultSet.getString(2));
user.setPassword(resultSet.getString(3));
userList.add(user);
新建类
HelloServlet和LoginServlet
主要连接在LoginServlet
获取参数
String usern = req.getParameter("username");
String passw = req.getParameter("password");
创建UserDao对象 传入User对象
UserDao find = new UserDao();
List<User> userList = find.login(usern,passw);
if (userList.isEmpty()){
resp.getWriter().write("no"+userList);//为空则输出no
}else {
resp.getWriter().write("ok"+userList);
}
由于没有设置utf-8所以输出格式使用了英文,如果使用中文则加上 <meta charset="utf-8">