文章目录
技术需求
1.创建并初始化数据库
2.创造项目并完成基本项目搭建
3.定义user类
4.导入依赖性和工具包
5.service类的编写
6.dao类编写
7.selvet编写
8.前端页面编写
总结
技术需求
需要掌握技术Java,selvet,html即可
1.创建并初始化数据库
2.创造项目并完成基本项目搭建
3.定义user类
private String username;
private String password;
private String nickname;
private String gender;
private int role;
4.导入依赖性和工具包
5.service类的编写
package com.example.labone.service;
import com.example.labone.domain.User;
public interface Userservice {
User login(String username,String password);
}
service接口编写
package com.example.labone.service.impl;
import com.example.labone.dao.Userdao;
import com.example.labone.dao.impl.userdaoimpl;
import com.example.labone.domain.User;
import com.example.labone.service.Userservice;
public class Userserviceimpl implements Userservice {
Userdao userdao=new userdaoimpl();
@Override
public User login(String username, String password) {
return userdao.SelectByPasswordAndUsername(username,password);
}
}
service的接口实现类编写
6.dao类编写
dao的接口类编写
package com.example.labone.dao;
import com.example.labone.domain.User;
public interface Userdao {
User SelectByPasswordAndUsername(String username, String password);
}
dao接口实现类的编写
package com.example.labone.dao.impl;
import com.example.labone.dao.Userdao;
import com.example.labone.domain.User;
import com.example.labone.utils.JdbcUtil;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import java.sql.SQLException;
public class userdaoimpl implements Userdao {
QueryRunner runner = new QueryRunner(JdbcUtil.getDataSource());
@Override
public User SelectByPasswordAndUsername(String username, String password) {
String sql = "select * from user where username = ? and password = ?";
try {
return runner.query(sql,new BeanHandler<>(User.class),username,password);
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
}
7.selvet编写
package com.example.labone.web;
import com.example.labone.domain.User;
import com.example.labone.service.Userservice;
import com.example.labone.service.impl.Userserviceimpl;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
@WebServlet(name = "LoginServlet", value = "/Login")
public class LoginServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Userservice userservice = new Userserviceimpl();
request.setCharacterEncoding("utf-8");
response.setContentType("text/html; charset=utf-8");
String username = request.getParameter("username");
String password = request.getParameter("password");
System.out.println(username+password);
User user= userservice.login(username,password);
if(user==null){
doGet(request,response);
}else {
if(user.getRole()==1){
System.out.println("此用户为管理员");
}else{
System.out.println("此用户为普通用户");
}
}
}
}
8.前端页面编写
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<form action="http://localhost:8080/Login" method="post">
<div>
<input type="text" name="username" class="username" placeholder="用户名" autocomplete="off"/>
</div>
<div>
<input type="password" name="password" class="password" placeholder="密码" oncontextmenu="return false" onpaste="return false" />
</div>
<button id="submit" type="submit">登录</button>
</form>
</body>
</html>
总结
例如:以上就是今天要讲的内容,本文仅仅简单介绍了pandas的使用,而pandas提供了大量能使我们快速便捷地处理数据的函数和方法。