完成 SSM 框架的搭建,并完成查询操作
完成 SSM 框架的搭建,并完成查询操作
一 、数据库创建
创建数据库java7,并在数据库下创建表tb_user
二、SSM框架搭建
目录结构如图所示
1.导包
- pom.xml文件
配置好pom.xml文件
2.创建目录结构 – MVC
2.1在main下创建java文件夹
在main下创建文件夹java专门用来存放java代码
在java文件夹下创建包com.zhongruan
在包com.zhongruan下创建包bean、dao、service、controller
在包bean下创建类User,
为实体类:去映射数据库字段
- User.class
package com.zhongruan.bean;
//实体类映射数据库字段
public class User {
//对属性的封装
private int id;
private String username;
private String password;
//getter and setter
public int getId() {
return id;
}
public void setId(int 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;
}
//构造方法
//传值方式:User user=new User(1,"dfsdf","1234")
public User(int id, String username, String password) {
this.id = id;
this.username = username;
this.password = password;
}
public User() {
}
//toString方法重写
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
}
在包dao下创建类UserDao
为数据库交互层
- UserDao
package com.zhongruan.dao;
import com.zhongruan.bean.User;
import java.util.List;
//UserDao数据库交互层
public interface UserDao {
//查询全部 List<User>userlist =new ArrayList()
List<User> findAllUser();
}
配置Spring框架,在main下新建文件夹resource
配置三个文件
在文件夹resource新建包mapper,这是一个对于user的mapper
在包mapper下新建文件UserMapper.xml,并配置
- 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.zhongruan.dao.UserDao" >
<select id="findAllUser" resultType="com.zhongruan.bean.User">
select * from tb_user;
</select>
</mapper>
在包service 下创建接口UserService
- UserService
package com.zhongruan.service;
import com.zhongruan.bean.User;
import java.util.List;
public interface UserService {
//查询全部
List<User> findAllUser();
}
再写service实现类
在包service创建包impl用来放实现类
在包impl下新建类UserServiceImpl
- UserServiceImpl
package com.zhongruan.service.impl;
import com.zhongruan.bean.User;
import com.zhongruan.dao.UserDao;
import com.zhongruan.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserDao userDao;
@Override
public List<User> findAllUser() {
return userDao.findAllUser();
}
}
配置 springMVC 和 web.xml
springMVC文件,拷贝web.xml文件
引入jsp页面
- index.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" isELIgnored="false"%>
<html>
<body>
<a href="${pageContext.request.contextPath}/user/findAllUser.do">查询全部</a>
</body>
</html>
编写controller
- UserController.class
package com.zhongruan.controller;
import com.zhongruan.bean.User;
import com.zhongruan.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import java.util.List;
@Controller
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;
@RequestMapping("/findAllUser.do")
public ModelAndView findAllUser(){
//调用service方法
List<User> userlist = userService.findAllUser();
ModelAndView mv=new ModelAndView();
mv.addObject("userlist",userlist);
mv.setViewName("allUser");
return mv;
}
}
结果:
点击查询全部