1. Introduction and configuration of MyBatis + Spring + MySql

One of MyBatis learning, MyBatis introduction and MyBatis configuration MyBatis + Spring + MySqlMyBatis learning 2, SQL statement ing file (1) resultMapMyBatis learning 2, SQL statement ing file (2) add, delete, modify, query, parameter, cache MyBatis learning 3, dynamic SQL statement MyBatis learning 4, MyBatis configuration file 1.1 MyBatis

MyBatis Learning 1. MyBatis introduction and configuration MyBatis + Spring + MySql MyBatis learning 2. SQL statement ing file (1) resultMap MyBatis learning 2. SQL statement ing file (2) add, delete, modify, query, parameters, cache MyBatis learning 3. dynamic SQL statement MyBatis learning 4. MyBatis configuration file 1.1 MyBatis

MyBatis 1. Introduction and configuration of MyBatis + Spring + MySql

MyBatis 2. SQL statement ing file (1) resultMap

MyBatis 2. SQL statement ing file (2) addition, deletion, modification, query, parameter, and Cache

MyBatis 3. dynamic SQL statements

MyBatis learning 4. MyBatis configuration file

1.1MyBatis Overview

MyBatis is a persistent layer framework that allows you to customize SQL, stored procedures, and advanced mappings. MyBatis distinct removes most of the JDBC code, manual setting parameters, and result set re-acquisition. MyBatis only uses simple XML and annotations to configure and Map basic data types, Map interfaces, and POJO to database records. Compared with "one-stop" ORM solutions such as Hibernate and Apache OJB, Mybatis is a "semi-automated" ORM implementation.
Jar package to be used: mybatis-3.0.2.jar (mybatis core package ). Mybatis-spring-1.0.0.jar (combined with Spring ).

:
Http://ibatis.apache.org/tools/ibator
Http://code.google.com/p/mybatis/

1.2 MyBatis + Spring + MySql simple configuration 1.2.1 build a Spring Environment

1. Create a maven web project;
2. Add the Spring framework and configuration file;
3. Add the required jar packages (spring framework, mybatis, mybatis-spring, and junit) in pom. xml );
4. modify the configuration files of web. xml and spring;
5. Add a jsp page and the corresponding Controller;
6. Test.

See http://limingnihao.iteye.com/blog/830409.Use Maven of Eclipse to build the SpringMVC Project

1.2.2 create a MySql database

Create a course selection management database for students.
Table: Student table, class table, instructor table, Course table, and student course selection table.
Logical Relationship: Each student has a class; each class corresponds to a class teacher; each teacher can only be a class teacher;

Use the following SQL statement to create a database. First, create a student table and insert data (more than 2 data records ).

For more SQL statements, download the project source file in resource/SQL.

SQL code

1. /* Create a database */

2. CREATEDATABASE STUDENT_MANAGER;

3. USE STUDENT_MANAGER;

5. /***** Create a student table *****/

6. CREATETABLE STUDENT_TBL

7. (

8. STUDENT_ID VARCHAR (255) PRIMARYKEY,

9. STUDENT_NAME VARCHAR (10) NOTNULL,

10. STUDENT_SEX VARCHAR (10 ),

11. STUDENT_BIRTHDAY DATE,

12. CLASS_ID VARCHAR (255)

13. );

15. /* Insert student data */

16. INSERTINTO STUDENT_TBL (STUDENT_ID,

17. STUDENT_NAME,

18. STUDENT_SEX,

19. STUDENT_BIRTHDAY,

20. CLASS_ID)

21. VALUES (123456,

22. 'Xxx ',

23. 'Femal ',

24. '2017-08-01 ',

25. 121546

26. )

Create the MySql. properties configuration file used to connect to mysql.

Mysql. properties code

1. Jdbc. driverClassName = com. mysql. jdbc. Driver

2. Jdbc. url = jdbc: mysql: // localhost: 3306/student_manager? User = root & password = limingnihao & useUnicode = true & characterEncoding = UTF-8

1.2.3 build the MyBatis Environment

The order is casual. The current order is because you can modify as few files as possible.

1.2.3.1 create object class: StudentEntity

Java code

1. Publicclass StudentEntity implements Serializable {

3. Privatestaticfinallong serialVersionUID = 3096154202413606831L;

4. Private ClassEntity classEntity;

5. Private Date studentBirthday;

6. Private String studentID;

7. Private String studentName;

8. Private String studentSex;

10. Public ClassEntity getClassEntity (){

11. Return classEntity;

12. }

14. Public Date getStudentBirthday (){

15. Return studentBirthday;

16. }

18. Public String getStudentID (){

19. Return studentID;

20. }

22. Public String getStudentName (){

23. Return studentName;

24. }

26. Public String getStudentSex (){

27. Return studentSex;

28. }

30. Publicvoid setClassEntity (ClassEntity classEntity ){

31. This. classEntity = classEntity;

32. }

34. Publicvoid setStudentBirthday (Date studentBirthday ){

35. This. studentBirthday = studentBirthday;

36. }

38. Publicvoid setStudentID (String studentID ){

39. This. studentID = studentID;

40. }

42. Publicvoid setStudentName (String studentName ){

43. This. studentName = studentName;

44. }

46. Publicvoid setStudentSex (String studentSex ){

47. This. studentSex = studentSex;

48. }

49. }

1.2.3.2 create a data access interface

The dao interface corresponding to the Student Class: StudentMapper.

Java code

1. Publicinterface StudentMapper {

3. Public StudentEntity getStudent (String studentID );

5. Public StudentEntity getStudentAndClass (String studentID );

7. Public List GetStudentAll ();

9. Publicvoid insertStudent (StudentEntity entity );

11. Publicvoid deleteStudent (StudentEntity entity );

13. Publicvoid updateStudent (StudentEntity entity );

14. }

1.2.3.3 create an SQL ing statement File

StudentMapper. xml

Xml Code

14. </p></li><li><p> SELECT * from STUDENT_TBL ST</p></li><li><p> WHERE ST.STUDENT_ID = #{studentID}</p></li><li><p>

19. </p></li><li><p> SELECT * from STUDENT_TBL</p></li><li><p>

1.2.3.4 create a mapper configuration file for MyBatis

Create the MyBatis profile: mybatis-config.xml in src/main/resource.

Xml Code

1.2.3.5 modify the Spring configuration file

It mainly adds the bean of the SqlSession production factory class: SqlSessionFactoryBean (in the mybatis. spring package ). You must specify the configuration file location and dataSource.
Bean corresponding to the data access interface. Created through MapperFactoryBean. You need to execute the full name of the interface class and reference the SqlSession factory bean.

Xml Code

You can also use annotations instead of defining mapper beans:

Add StudentMapper to Annotation

Java code

1. @ Repository

2. @ Transactional

3. Publicinterface StudentMapper {

4. }

The corresponding scan needs to be added to the dispatcher-servlet.xml:

Xml Code

1.2.4 test StudentMapper

Use SpringMVC for testing, create a TestController, configure tomcat, and access the index. do page for testing:

Java code

1. @ Controller

2. Publicclass TestController {

4. @ Autowired

5. Private StudentMapper studentMapper;

7. @ RequestMapping (value = "index. do ")

8. Publicvoid indexPage (){

9. StudentEntity entity = studentMapper. getStudent ("10000013 ");

10. System. out. println ("name:" + entity. getStudentName ());

11. }

12. }

Test with Junit:

Java code

1. Test with Junit:

2. Java code

3. @ RunWith (value = SpringJUnit4ClassRunner. class)

4. @ ContextConfiguration (value = "test-servlet.xml ")

5. Publicclass StudentMapperTest {

7. @ Autowired

8. Private ClassMapper classMapper;

10. @ Autowired

11. Private StudentMapper studentMapper;

13. @ Transactional

14. Publicvoid getStudentTest (){

15. StudentEntity entity = studentMapper. getStudent ("10000013 ");

16. System. out. println ("" + entity. getStudentID () + entity. getStudentName ());

18. List StudentList = studentMapper. getStudentAll ();

19. For (StudentEntity entityTemp: studentList ){

20. System. out. println (entityTemp. getStudentName ());

21. }

23. }

24. }