案例目录
win10,Idea,Tomcat 8.5,mysql 实现
案例过程
-
创建Maven项目
-
导入相关工具类
使用注解 -
部分相关代码展示
User.java
package entity;
import annotation.Column;
import annotation.PrimaryKey;
import annotation.Table;
import java.io.Serializable;
@Table("user")
public class User implements Serializable {
@Column
@PrimaryKey
private String id;
@Column
private String username;
@Column
private String password;
public String getId() { return id;}
public void setId(String id) { this.id = id;}
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;
}
}
TestAction.java
package dao;
import entity.User;
import jdbc.HelperDBUtil;
public class UserDao {
HelperDBUtil hdb = new HelperDBUtil();
//登录
public User login(User user){
String sql = "select * from user where username = ? and password = ?";
return hdb.findSingleBean(sql,User.class,user.getUsername(),user.getPassword());
}
//检查用户是否存在
public User findByName(String username){
String sql = "select * from user where username = ? ";
return hdb.findSingleBean(sql,User.class,username);
}
//注册
public Boolean add(User user){
return hdb.saveEntity(user);
}
}
struts.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.5//EN"
"http://struts.apache.org/dtds/struts-2.5.dtd">
<struts>
<!--配置-->
<!--后缀 以 为action 或者 php 或者无任何 结尾-->
<constant name="struts.action.extension" value="action,php,asp,,"/>
<!--测试阶段开启 更新 Struts.xml-->
<constant name="struts.configuration.xml.reload" value="true"/>
<!--
<package name="admin" namespace="/" extends="struts-default">
<action name="index22" class="com.opensymphony.xwork2.ActionSupport" method="execute">
<result>index.jsp</result>
</action>
<action name="test" class="control.TestAction" method="execute">
<result name="success">index.jsp</result>
</action>
</package>
-->
<include file="userStruts.xml"/>
</struts>
userStruts.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.5//EN"
"http://struts.apache.org/dtds/struts-2.5.dtd">
<struts>
<!--name 唯一标识 namespace 路径 extends 继承-->
<package name="test" namespace="/" extends="struts-default">
<!--name 唯一标示性 url 根据 name-->
<action name="test" class="controller.TestAction" method="test">
<result name="success">home.jsp</result>
</action>
</package>
<package name="user" namespace="/" extends="struts-default,json-default">
<!--name 唯一标示性 url 根据 name-->
<action name="login" class="controller.UserAction" method="login">
<result name="success">index.jsp</result>
<result name="error">fail.jsp</result>
</action>
<action name="findByName" class="controller.UserAction" method="findByName">
<result name="success" type="json">
<param name="root">user</param>
</result>
</action>
<action name="add" class="controller.UserAction" method="add">
<result name="success" type="json">
</result>
</action>
</package>
</struts>
login.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<label>登录</label>
<form action="login" method="post">
用户名:<input type="text" name="username"><br/>
密 码:<input type="password" name="password"><br/>
<input type="submit">
</form>
<hr>
<a href="register.jsp">注册</a>
</body>
</html>
register.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<script src="js/jquery-1.12.4.js"></script>
<body>
<hr>
<label>注册</label><br/>
用户名:<input type="text" id="name" name="username"><span id="msg"></span><br/>
密 码:<input type="password" name="password" id="password"><span id="msg2"></span><br/>
确认密码:<input type="password" name="password" id="password2"><span id="msg3"></span><br/>
<button id="add-button">注册</button>
<hr>
<a href="login.jsp">注册</a>
</body>
<script>
function cheakName() {
var name = $("#name").val();
if(name=='' || name==null){
$("#msg").html('请输入用户名');
return ;
}
var data = {username: name};
$.ajax({
typy: "get",
url: "http://localhost:8989/findByName",
data: data,
dataType: 'json',
success: function (res) {
if (res != null) {
$("#name").focus();
$("#name").css("border","2px solid red");
$("#msg").html('用户名已存在,请重新输入');
return ;
} else {
$("#name").css("border","");
$("#msg").html('?');
}
}
})
}
$(function () {
$("#name").blur(cheakName);
$('#add-button').click(function(event){
var name = $("#name").val();
var password = $("#password").val();
var password2 = $("#password2").val();
if(name=='' || name==null){
$("#msg").html('请输入用户名');
return ;
}
if(password=='' || password==null){
$("#msg2").html('请输入密码');
return ;
}
if(password2=='' || password2==null){
$("#msg3").html('请确认密码');
return ;
}
if(password!=password2){
$("#msg2").html('两次密码不一致');
return ;
}
$("#msg").html('?');
$("#msg2").html('?');
$("#msg3").html('?');
var data=
{
username:name,
password:password
};
$.ajax({
type:"POST",
url:"http://localhost:8989/add",
data:data,
dataType:'json',
success:function(res){
setTimeout(function(){
window.location.href = "login.jsp";
},600);
}
});
});
})
</script>
</html>
- 运行结果
朋友写的作业,没有样式,一个功能完整的小案例,下载(包含其中封装的几个工具类):
https://download.csdn.net/download/weixin_45044097/11863961
这是加了layUI前端,加了一二员工表,实现了增删改查的: