springmvc+spring+mybatis整合

springmvc+spring+mybatis整合

首先在整合这个框架的时候，想想其一般的步骤是怎样的，先有个步骤之后，不至于在后面的搞混了，这样在整合的时候也比较清晰些。

然后我们就细细的一步一步来整合。

1 创建一个Web项目。

2 导入Mybatis3、Spring4、SpringMVC4、连接数据库（我使用的数据库是mysql）的jar包。

我所用的包：

spring-websocket-4.2.0.RELEASE.jar

3 创建Mybatis3、Spring4、SpringMVC4、连接数据库的配置文件。

4 配置web.xml

1

2

3xmlns="https://www.360docs.net/doc/3014192814.html,/xml/ns/javaee"

4xmlns:xsi="https://www.360docs.net/doc/3014192814.html,/2001/XMLSchema-instance" 5xsi:schemaLocation="https://www.360docs.net/doc/3014192814.html,/xml/ns/javaee

6https://www.360docs.net/doc/3014192814.html,/xml/ns/javaee/web-app_2_5.xsd">

7

8 9

10contextConfigLocation 11

12/WEB-INF/classes/applicationContext.xml,

13

14

15

16

17

18

19

20log4jConfigLocation 21/WEB-INF/log4j.xml

22

23

24

25log4jRefreshInterval 2660000

27

28

29

30

31webAppRootKey

32ssm.root

33

34

35

36

37default

38/static/*

39

40

41

42

43

44mvc

45org.springframework.web.servlet.DispatcherServlet

46

48

49contextConfigLocation

50/WEB-INF/classes/mvc-servlet.xml

51

52

53

54mvc

55/

56

57

58

59

60

61encodingFilter

62org.springframework.web.filter.CharacterEncodingFilter

63

64encoding

65UTF-8

66

67

68

69forceEncoding

70true

71

72

73

74encodingFilter

75/*

76

77

78

79

80loginFilter

81com.cy.ssm.filter.LoginFilter

82

83

84loginFilter

85/*

86

87

88

89org.springframework.web.context.ContextLoaderListener 90

91

92

93org.springframework.web.util.Log4jConfigListener

94

95

96

97index.jsp

98

99

5 datasource.properties 连接数据库

1 jdbc.driver=com.mysql.jdbc.Driver

2 jdbc.url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=UTF-8

3 https://www.360docs.net/doc/3014192814.html,ername=root

4 jdbc.password=root

6 mybatis.cfg.xml文件

"https://www.360docs.net/doc/3014192814.html,/dtd/mybatis-3-config.dtd" >

7 mvc-servlet.xml

1

2

3xmlns:xsi="https://www.360docs.net/doc/3014192814.html,/2001/XMLSchema-instance"

xmlns:context="https://www.360docs.net/doc/3014192814.html,/schema/context"

4xmlns:mvc="https://www.360docs.net/doc/3014192814.html,/schema/mvc"

5xsi:schemaLocation="https://www.360docs.net/doc/3014192814.html,/schema/beans

6https://www.360docs.net/doc/3014192814.html,/schema/beans/spring-beans-3.0.xsd

7https://www.360docs.net/doc/3014192814.html,/schema/context

https://www.360docs.net/doc/3014192814.html,/schema/context/spring-context-3.0.xsd

8https://www.360docs.net/doc/3014192814.html,/schema/mvc

9https://www.360docs.net/doc/3014192814.html,/schema/mvc/spring-mvc-3.0.xsd">

10

11

12

13

14

15

16

17

18 19

20

21

22

23

25比如传进来的逻辑视图名为WEB-INF/jsp/hello，则该该jsp视图页面应该存放在“WEB-INF/jsp/hello.jsp”；-->

26

27 28

29

30

31

8 applicationContext.xml

1

2

3xmlns:xsi="https://www.360docs.net/doc/3014192814.html,/2001/XMLSchema-instance"

xmlns:context="https://www.360docs.net/doc/3014192814.html,/schema/context"

4xmlns:aop="https://www.360docs.net/doc/3014192814.html,/schema/aop"

xmlns:tx="https://www.360docs.net/doc/3014192814.html,/schema/tx"

5xsi:schemaLocation="https://www.360docs.net/doc/3014192814.html,/schema/beans

6https://www.360docs.net/doc/3014192814.html,/schema/beans/spring-beans-3.0.xsd

7https://www.360docs.net/doc/3014192814.html,/schema/aop

8https://www.360docs.net/doc/3014192814.html,/schema/aop/spring-aop-3.0.xsd

9https://www.360docs.net/doc/3014192814.html,/schema/tx

10https://www.360docs.net/doc/3014192814.html,/schema/tx/spring-tx-3.1.xsd

11https://www.360docs.net/doc/3014192814.html,/schema/context

12https://www.360docs.net/doc/3014192814.html,/schema/context/spring-context-4.2.xsd">

13

14

15

16

17

18

expression="org.springframework.stereotype.Controller"/>

19

20

21

22

23

24

25

26

27classpath:datasource.properties

28

29

30

31

32 33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

57

58

59

60

61

62

63

64rollback-for="https://www.360docs.net/doc/3014192814.html,ng.Exception"/>

65

66rollback-for="https://www.360docs.net/doc/3014192814.html,ng.Exception"/>

67

69

71 72 73 74 75 76

77

78

79

80

81

82

83

84

85

9 配置文件都差不多配置好了，接下来就写个测试的。

UserBean.java

1package com.cy.ssm.beans;

2

3import java.io.Serializable;

4

5public class UserBean implements Serializable {

6

7

8private static final long serialVersionUID = -2682305557890221059L;

9private Integer id;

10private String username;

11private String password;

12private Double account;

13public UserBean() {

14super();

15// TODO Auto-generated constructor stub

16}

17public UserBean(Integer id, String username, String password, Double account) { 18super();

19this.id = id;

https://www.360docs.net/doc/3014192814.html,ername = username;

21this.password = password;

22this.account = account;

23}

24public Integer getId() {

25return id;

26}

27public void setId(Integer id) {

28this.id = id;

29}

30

31public String getUsername() {

32return username;

33}

34public void setUsername(String username) {

https://www.360docs.net/doc/3014192814.html,ername = username;

36}

37public String getPassword() {

38return password;

39}

40public void setPassword(String password) {

41this.password = password;

42}

43public Double getAccount() {

44return account;

45}

46public void setAccount(Double account) {

47this.account = account;

48}

49@Override

50public String toString() {

51return "UserBean [account=" + account + ", id=" + id + ", password=" 52+ password + ", username=" + username + "]";

53}

54 }

UserMapper.java

1package com.cy.ssm.mapper;

2

3import java.util.List;

4import java.util.Map;

5

6

7import org.apache.ibatis.annotations.Delete;

8import org.apache.ibatis.annotations.Insert;

9import org.apache.ibatis.annotations.Options;

10import org.apache.ibatis.annotations.Param;

11import org.apache.ibatis.annotations.Result;

12import org.apache.ibatis.annotations.ResultMap;

13import org.apache.ibatis.annotations.Results;

14import org.apache.ibatis.annotations.Select;

15import org.apache.ibatis.annotations.Update;

16

17import https://www.360docs.net/doc/3014192814.html,erBean;

18

19

20public interface UserMapper {

21

22

23/**

24* 登录

25* @param userName

26* @param password

27* @return

28* @throws Exception

29*/

30@Select("select * from t_user where username=#{un} and password=#{pw}")

31@Results({

32

33@Result(id=true,property="id",column="id",javaType=Integer.class),

34@Result(property="username",column="username",javaType=String.class),

35@Result(property="password",column="password",javaType=String.class),

36@Result(property="account",column="account",javaType=Double.class)

37})

38public UserBean login(@Param("un")String username,@Param("pw")String password);

39/**

40* 新增用戶

41* @param user

42* @return

43* @throws Exception

44*/

45@Insert("insert into t_user value (null,https://www.360docs.net/doc/3014192814.html,ername,user.password,user.account)")

46@Options(useGeneratedKeys=true,keyProperty="user.id")

47public int insertUser(@Param("user")UserBean user) throws Exception;

48

49

50/**

51* 修改用戶

52* @param user

53* @param id

54* @return

55* @throws Exception

56*/

57@Update(" update t_user set username=#{https://www.360docs.net/doc/3014192814.html,ername},password=#{u.password},account=#{u.account} where id=#{id}")

58public int updateUser (@Param("u")UserBean user,@Param("id")int id) throws Exception;

59

60/**

61* 刪除用戶

62* @param id

63* @return

64* @throws Exception

65*/

66@Delete(" delete from t_user where id=#{id} ")

67public int deleteUser(int id) throws Exception;

68

69

70/**

71* 根据id查询用户信息

72* @param id

73* @return

74* @throws Exception

75*/

76

77@Select(" select * from t_user where id=#{id}")

78@Results({

79

80@Result(id=true,property="id",column="id",javaType=Integer.class),

81@Result(property="username",column="username",javaType=String.class), 82@Result(property="password",column="password",javaType=String.class), 83@Result(property="account",column="account",javaType=Double.class) 84})

85public UserBean selectUserById(int id) throws Exception;

86/**

87* 查询所有的用户信息

88* @return

89* @throws Exception

90*/

91

92@Select(" select * from t_user")

93@ResultMap("userMap")

94public List selectAllUser() throws Exception;

95

96

97/**

98* 批量增加

99* @param user

100* @return

101* @throws Exception

102*/

103public int batchInsertUser(@Param("users")List user) throws Exception; 104

105/**

106* 批量删除

107* @param list

108* @return

109* @throws Exception

110*/

111public int batchDeleteUser(@Param("list")List list) throws Exception; 112

113

114/**

115* 分页查询数据

116* @param parma

117* @return

118* @throws Exception

119*/

120public List pagerUser(Map parmas) throws Exception; 121

122/**

123*

124* 分页统计数据

125* @param parma

126* @return

127* @throws Exception

128*/

129public int countUser(Map parmas) throws Exception;

130

131

132

133

134 }

UserMapper.xml

1

2

"https://www.360docs.net/doc/3014192814.html,/dtd/mybatis-3-mapper.dtd">

3

4

5

6

7 8 9 10

11

12

13

14

15insert into t_user values

16

17(null,#{https://www.360docs.net/doc/3014192814.html,ername},#{users.password},#{users.account})

18

19

20

21

22

23delete from t_user where id in (

24

25#{id}

26

27)

28

29

30

31

32

33

34

37

38select * from t_user where 1=1

39

40and username like '%${username}%'

41

42limit ${index},${pageSize}

43

44

45 46select count(*) from t_user where 1=1

47

48and username like '%${username}%'

49

50

51

52

ILoginService.java

1package com.cy.ssm.service;

2

3

4import https://www.360docs.net/doc/3014192814.html,erBean;

5

6public interface ILoginService {

7

8public UserBean Login(String username,String password);

9

10

11 }

LoginServiceImpl.java

1package com.cy.ssm.service.impl;

2

3import javax.annotation.Resource;

4

5import org.springframework.stereotype.Service;

6

7import https://www.360docs.net/doc/3014192814.html,erMapper;

8import https://www.360docs.net/doc/3014192814.html,erBean;

9import com.cy.ssm.service.ILoginService;

10 @Service

11public class LoginServiceImpl implements ILoginService{

12

13@Resource

14private UserMapper um;

15

16

17@Override

18public UserBean Login(String username, String password) {

19return um.login(username, password);

20}

21

22 }

LoginController .java

1package com.cy.ssm.controller;

2

3

4import javax.annotation.Resource;

5import javax.servlet.http.HttpServletRequest;

6

7import org.apache.log4j.Logger;

8import org.springframework.stereotype.Controller;

9import org.springframework.web.bind.annotation.RequestMapping; 10import org.springframework.web.servlet.ModelAndView;

11

12import https://www.360docs.net/doc/3014192814.html,erBean;

13import com.cy.ssm.service.ILoginService;

14

15

16

17 @Controller

18public class LoginController {

19private Logger log = Logger.getLogger(this.getClass());

20

21@Resource

22private ILoginService loginServiceImpl;

23

24@RequestMapping("/login")

25public ModelAndView login(HttpServletRequest req,UserBean user){

https://www.360docs.net/doc/3014192814.html,(user);

27

28ModelAndView mv = new ModelAndView();

29UserBean u=loginServiceImpl.Login(user.getUsername(), user.getPassword()); 30

31if(u != null){

32

33req.getSession().setAttribute("user", u);

34mv.addObject("password", u.getPassword());

35System.out.println(u.getPassword());

36}

37mv.setViewName("index");

38return mv;

39}

40

41

42

43 }

jsp页面；

login.jsp

1

2

3

4

5

6

index.jsp

${password }

测试：

点击提交

整体大概就这样了！

本文作者：hellokitty