ssm框架搭建连接mysql_ssm框架搭建(示例代码)

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;

}

}

未完待续。。。。