1.项目是maven,下面是pom.xml
1.先集成spring
org.springframework
spring-core
5.1.4.RELEASE
org.springframework
spring-context
5.1.4.RELEASE
org.springframework
spring-context-support
5.1.4.RELEASE
org.springframework
spring-aop
5.1.4.RELEASE
org.springframework
spring-aspects
5.1.4.RELEASE
org.springframework
spring-tx
5.1.4.RELEASE
org.springframework
spring-jdbc
5.1.4.RELEASE
org.springframework
spring-web
5.1.4.RELEASE
2.集成MVC
org.springframework
spring-webmvc
5.1.4.RELEASE
3.集成mybatis
org.mybatis
mybatis
3.5.0
4.集成mybatis-spring
org.mybatis
mybatis-spring
2.0.0
5.集成c3p0
com.mchange
c3p0
0.9.5.2
6.集成jstl
javax.servlet.jsp.jstl
jstl-api
1.2
org.apache.taglibs
taglibs-standard-impl
1.2.5
7.集成mysql驱动
mysql
mysql-connector-java
8.0.14
2.按下图搭建项目框架
1.首先是domain.User代码
public class User implements Serializable {
private Integer id;
private String username;
private String loginname;
private String password;
private Integer status;
private Date createDate;
public User() {
super();
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getLoginname() {
return loginname;
}
public void setLoginname(String loginname) {
this.loginname = loginname;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public Integer getStatus() {
return status;
}
public void setStatus(Integer status) {
this.status = status;
}
public Date getCreateDate() {
return createDate;
}
public void setCreateDate(Date createDate) {
this.createDate = createDate;
}
@Override
public String toString() {
return "User [id=" + id + ", username=" + username + ", loginname="
+ loginname + ", password=" + password + ", status=" + status
+ ", createDate=" + createDate + "]";
}
}
2.数据协议层
public interface UserDao {
public User selectByLoginnameAndPassword();
public User selectById(Integer id);
public void deleteById(Integer id);
public void update(User user);
public List selectByPage();
public Integer count(Map params);
public void save(User user);
public User selectByLoginnameAndPassword(String loginname, String password);
}
3.服务协议层
public interface UserService {
User login(String loginname,String password);
User findUserById(Integer id);
//List findUser(User user,PageModel pageModel);
void removeUserById(Integer id);
void modifyUser(User user);
void addUser(User user);
}
4.服务层
public class UserServiceImpl implements UserService {
@Autowired
private UserDao userDao;
public User login(String loginname, String password) {
return userDao.selectByLoginnameAndPassword(loginname, password);
}
public User findUserById(Integer id) {
return userDao.selectById(id);
}
public void removeUserById(Integer id) {
userDao.deleteById(id);
}
public void modifyUser(User user) {
userDao.update(user);
}
public void addUser(User user) {
userDao.save(user);
}
}
5.然后在web.xml中配置spring
org.springframework.web.context.ContextLoaderListener
contextConfigLocation
classpath:applicationContext*.xml
6.在web.xml中配置SpringMvc
springmvc
org.springframework.web.servlet.DispatcherServlet
contextConfigLocation
classpath:springmvc-config.xml
1
springmvc
/
7.在web.xml中配置编码过滤器(post乱码)
characterEncodingFilter
org.springframework.web.filter.CharacterEncodingFilter
encoding
UTF-8
characterEncodingFilter
/*
8.配置applicationContext.xml
1. mybatis:scan会扫描com.yongxing.manager.dao包里的所有接口当作Spring的bean配置,之后可以进行依赖注入
2.扫描com.yongxing.manager包下面的java文件,有Spring的相关注解的类,则把这些类注册为Spring的bean
3.加载数据源参数
4.配置数据源
5.配置SqlSessionFactory
9.置SpringMvc
1.自动扫描该包,SpringMVC会将包下用了@controller注解的类注册为Spring的controller
2.设置默认配置方案
3.使用默认的Servlet来响应静态文件
4.视图解析器
10.配置Mapper接口
/p>
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
select * from user_inf
11.配置登录页控制器
@Controller
public class LoginController {
@RequestMapping("/login")
public ModelAndView login(ModelAndView mv) {
System.out.println("login");
mv.setViewName("login");
return mv;}}
12.配置查询页控制器
@Controller
public class UserController {
@Autowired
private UserDao userDao;
@RequestMapping(value = "/all")
public String del() {
List list = userDao.selectByPage();
for (int x = 0; x < list.size(); x++) {
User user = list.get(x);
System.out.println(user.getUsername());
}
return null;
}
}
未完待续。。。。