eclipse用Maven配置SSM环境3
SSM的环境配置
在最近我们在学习SSM的过程中需要配置环境,因为是第一次配置所以想记录一下
我的配置环境是Java1.8 Tomcat8.5 还有mysql
前言
没有看到上一部分的可以去看看上一部分
eclipse用Maven配置SSM环境1
eclipse用Maven配置SSM环境2
配置完成后我们的进度也完成了一大半了
这篇文章也是配置环境的最终章
现在我们就来配置把
开始配置
在上一次的时候我把我的项目写到了这个样子 所以 我们现在接下来就在上次写的框架上继续进行框架的搭建
首先我们需要在com.lz.bean里面创建一个UserBean
package com.lz.bean;
public class UserBean {
private int userID;
private String userName;
private int userAge;
private String userGender;
private String userAddress;
private int userNumber;
public int getUserID() {
return userID;
}
public void setUserID(int userID) {
this.userID = userID;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public int getUserAge() {
return userAge;
}
public void setUserAge(int userAge) {
this.userAge = userAge;
}
public String getUserGender() {
return userGender;
}
public void setUserGender(String userGender) {
this.userGender = userGender;
}
public String getUserAddress() {
return userAddress;
}
public void setUserAddress(String userAddress) {
this.userAddress = userAddress;
}
public int getUserNumber() {
return userNumber;
}
public void setUserNumber(int userNumber) {
this.userNumber = userNumber;
}
public UserBean(int userID, String userName, int userAge, String userGender, String userAddress, int userNumber) {
super();
this.userID = userID;
this.userName = userName;
this.userAge = userAge;
this.userGender = userGender;
this.userAddress = userAddress;
this.userNumber = userNumber;
}
public UserBean() {
super();
}
@Override
public String toString() {
return "UserBean [userID=" + userID + ", userName=" + userName + ", userAge=" + userAge + ", userGender="
+ userGender + ", userAddress=" + userAddress + ", userNumber=" + userNumber + "]";
}
}
然后进行我们的mapper类的创建与编写
先写接口 IUser
package com.lz.mapper;
import java.util.List;
import com.lz.bean.UserBean;
public interface IUser {
public List<UserBean>selectAll();
//增加一个用户
public boolean addUser(UserBean user);
//删除
public boolean deleteUser(int id);
//更新
public int updateUser(UserBean user);
//查询
UserBean queryUserById(int id);
//查询用户
UserBean queryUserByName(String name);
}
下面是UserMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lz.mapper.IUser">
<!--查询全部-->
<select id="selectAll" resultType="user">
select * from user_tb
</select>
<!-- 添加 -->
<insert id="addUser" parameterType="user">
insert
user_tb
values(0,#{name},#{sex},#{cardNo},#{balance},#{level})
</insert>
<!--删除-->
<delete id="deleteUser" parameterType="Integer">
delete
from user_tb
where id=#{id}
</delete>
<!--更新-->
<update id="updateUser" parameterType="user">
update user_tb
set name=#{name},sex=#{sex},cardNo=#{cardNo},balance=#{balance},level=#{level}
where id=#{id} ;
</update>
<!--查询一个-->
<select id="queryUserById" resultType="user">
select * from user_tb
where id = #{id}
</select>
<!-- 查询用户名 -->
<select id="queryUserByName" resultType="user">
select * from user_tb where name=#{name}
</select>
</mapper>
写完mapper类后 我们进行service类的创建和编写
首先我们现创建一个接口IUserService
package com.ks.service;
import java.util.List;
import com.ks.bean.UserBean;
public interface IUserService {
//查询全部
public List<UserBean>getAllUser();
//增加一个用户
public boolean addUser(UserBean user);
//删除
public boolean deleteUser(int id);
//更新
public int updateUser(UserBean user);
//查询
public UserBean queryUserById(int id);
//查询用户
public UserBean queryUserByName(String name);
}
然后创建IUserImp
package com.ks.service;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.ks.bean.UserBean;
import com.ks.mapper.IUser;
@Service
public class IUserImp implements IUserService{
@Autowired
public IUser iu;
public IUser getIu() {
return iu;
}
public List<UserBean> getAllUser() {
// TODO Auto-generated method stub
return iu.selectAll();
}
public boolean addUser(UserBean user) {
// TODO Auto-generated method stub
return iu.addUser(user);
}
public boolean deleteUser(int id) {
// TODO Auto-generated method stub
return iu.deleteUser(id);
}
public int updateUser(UserBean user) {
// TODO Auto-generated method stub
return iu.updateUser(user);
}
public UserBean queryUserById(int id) {
// TODO Auto-generated method stub
return iu.queryUserById(id);
}
public UserBean queryUserByName(String name) {
// TODO Auto-generated method stub
return iu.queryUserByName(name);
}
}
接下来就是我们java代码最后的controller类的编写了
我们现创建一个UserController 然后进行编写
package com.lz.controller;
import java.util.ArrayList;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import com.lz.bean.UserBean;
import com.lz.service.*;
@Controller
public class UserController {
@Autowired
private IUserImp iip;
public IUserImp getIip() {
return iip;
}
//查询
@RequestMapping("queryUser")
public String queryUser(String queryUserName,Model model){
UserBean user=this.iip.queryUserByName(queryUserName);
if(queryUserName!=""){
List<UserBean> list=new ArrayList<UserBean>();
list.add(user);
model.addAttribute("list",list);
return "index.jsp";
}else{
return "redirect:ShowAllUser.do";
}
}
//修改
@RequestMapping("goupdate")
public String goupdate(UserBean user){
this.iip.updateUser(user);
return "redirect:ShowAllUser.do";
}
//修改查询
@RequestMapping("update")
public String update(int id,Model model) {
UserBean user=this.iip.queryUserById(id);
model.addAttribute("Quser",user);
return "updateUser.jsp";
}
//删除
@RequestMapping("delete")
public String deleteBook(int id) {
boolean flag=this.iip.deleteUser(id);
if(flag){
return "redirect:ShowAllUser.do";
}else{
System.out.println("删除失败");
return "index.jsp";
}
}
//添加
@RequestMapping("addUser")
public String addPaper(UserBean user) {
boolean flag=this.iip.addUser(user);
if(flag){
return "redirect:ShowAllUser.do";
}else{
return "addUser.jsp";
}
}
@RequestMapping("ShowAllUser")
public ModelAndView SHowAllUser(){
//获取前端传递过来的数据
int pageIndex=1;
int pageSize=5;
ModelAndView mv=new ModelAndView("/index.jsp");
mv.addObject("list", iip.getAllUser());
return mv;
}
}
在这里面我们进行各种业务逻辑的编写过程
这就是我们整体项目创建完成后的样子 接下来我们只需要编写前端JSP就可以了
addUser.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>修改信息</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- 引入 Bootstrap -->
<link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<div class="page-header">
<h1>
<small>修改信息</small>
</h1>
</div>
</div>
</div>
<form action="goupdate.do" method="post">
<input type="hidden" name="id" value="${Quser.id}"/><br><br><br>
用户名:<input type="text" name="name" value="${Quser.name}"><br><br><br>
用户性别:<input type="text" name="sex" value="${Quser.sex}"><br><br><br>
用户卡号:<input type="text" name="cardNo" value="${Quser.cardNo}"><br><br><br>
用户余额:<input type="text" name="balance" value="${Quser.balance}"> <br><br><br>
用户等级:<input type="text" name="level" value="${Quser.level}"><br><br><br>
<input type="submit" value="提交"/>
</form>
</div>
</body>
</html>
ShowPage.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>首页</title>
<style type="text/css">
a {
text-decoration: none;
color: black;
font-size: 18px;
}
h3 {
width: 180px;
height: 38px;
margin: 100px auto;
text-align: center;
line-height: 38px;
background: deepskyblue;
border-radius: 4px;
}
</style>
</head>
<body>
<h3>
<a href="ShowAllUser.do">点击进入列表页</a>
</h3>
</body>
</html>
index.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>首页</title>
<style type="text/css">
a {
text-decoration: none;
color: black;
font-size: 18px;
}
h3 {
width: 180px;
height: 38px;
margin: 100px auto;
text-align: center;
line-height: 38px;
background: deepskyblue;
border-radius: 4px;
}
</style>
</head>
<body>
<h3>
<a href="ShowAllUser.do">点击进入列表页</a>
</h3>
</body>
</html>
index.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>修改信息</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- 引入 Bootstrap -->
<link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<div class="page-header">
<h1>
<small>修改信息</small>
</h1>
</div>
</div>
</div>
<form action="goupdate.do" method="post">
<input type="hidden" name="id" value="${Quser.id}"/><br><br><br>
用户名:<input type="text" name="name" value="${Quser.name}"><br><br><br>
用户性别:<input type="text" name="sex" value="${Quser.sex}"><br><br><br>
用户卡号:<input type="text" name="cardNo" value="${Quser.cardNo}"><br><br><br>
用户余额:<input type="text" name="balance" value="${Quser.balance}"> <br><br><br>
用户等级:<input type="text" name="level" value="${Quser.level}"><br><br><br>
<input type="submit" value="提交"/>
</form>
</div>
</body>
</html>