IBatis Simple Introduction and Basic primer

　The term ibatis is derived from the combination of "Internet" and "Abatis", an open source project launched by Clinton begin in 2002. Was hosted by Google on June 16, 2010 and renamed MyBatis. is a SQL-based mapping support for Java and • NET persistence layer framework.

The persistence layer framework provided by Ibatis includes SQL maps and Data Access Objects (DAO), as well as a Jpetstore instance developed using this framework. Ibatis is a "semi-automated" ORM implementation relative to "one-stop" ORM solutions such as Hibernate and APACHEOJB. IBATIS is currently available in three languages, including: Java,. NET and Ruby. The so-called "semi-automatic" may be somewhat jerky in understanding. Throughout the current mainstream ORM (Object relational mapping), both Hibernate and Apache OJB provide a more complete encapsulation of the database structure, providing a full set of mapping mechanisms from Pojo to database tables. Programmers often only need to define the Pojo to the database table mapping, can be provided by Hibernate or OJB methods to complete the persistence layer operation. Programmers do not even need to be proficient in SQL, and HIBERNATE/OJB automatically generates the corresponding SQL and invokes the JDBC interface to execute according to the established storage logic. The following conditions are not good:1. Some or all of the system's data comes from an existing database, and security concerns only provide a few select SQL (or stored procedures) for the development team to obtain the required data, and the specific table structure is not exposed. 2. In the development specification, all database operations that involve the business logic section must be implemented in the database layer by the stored procedure (for the financial industry to which the author is working, ICBC, Bank of China, Bank of communications are strictly specified in the development specification)3. The huge amount of system data processing and the extremely stringent performance requirements often mean that we have to achieve system performance design metrics through highly optimized SQL statements (or stored procedures). "semi-automated" ibatis, but just solved the problem. The "semi-automatic" here is "fully automated", which provides a comprehensive database encapsulation mechanism relative to hibernate etc.ORM implementations, the "fully automated" ORM implements the mapping between POJO and database tables, as well as the automatic SQLbuild and execute. The focus of Ibatis is the mapping relationship between Pojo and SQL. In other words, IbatisSQL execution is not automatically generated for programmers at run time. The specific SQL needs to be written by the programmer and then mappedThe required parameters for SQL, and the returned result fields to the specified POJO. using the ORM mechanism provided by Ibatis, for the business logic implementation personnel, the face is pure Java object,This layer is basically consistent with the ORM implementation through hibernate, and for specific data operations, HibernateSQL statements are generated automatically, and Ibatis requires developers to write specific SQL statements. Relative Hibernate etc."Fully automatic" ORM mechanism, ibatis with the workload of SQL development and database portability is the cost, for the systemThe design provides a greater freedom of space. As a useful complement to the "fully automated" ORM implementation, the presence of Ibatisbe meaningful.

Build Ibatis Development environment:

1, import the relevant jar package, Ibatis-2.3.0.677.jar, Mysql-connector-java-5.1.6-bin.jar

2. Write the configuration file:

The properties file for the JDBC connection

General configuration file, Sqlmapconfig.xml

About each entity's mapping file (map file)

Demo :

Student.java:

2. Package com.iflytek.entity;
6. Import Java.sql.Date;
10. /**
12. * @author Xudongwang 2011-12-31
14. *
16. * Email:[email protected]
18. *
20. */
22. Publicclass Student {
24. Note that there is a need to ensure that there is a parameterless construction method, because the mappings, including hibernate, are reflected, and if there are no parameterless constructs, problems may occur.
26. Privateint ID;
28. private String name;
30. Private Date birth;
32. Privatefloat score;
36. Publicint GetId () {
38. return ID;
40. }
44. Publicvoid setId (int id) {
46. This.id = ID;
48. }
52. Public String GetName () {
54. return name;
56. }
60. Publicvoid setName (String name) {
62. THIS.name = name;
64. }
68. Public Date Getbirth () {
70. return birth;
72. }
76. Publicvoid Setbirth (Date birth) {
78. This.birth = birth;
80. }
84. Publicfloat Getscore () {
86. return score;
88. }
92. Publicvoid SetScore (float score) {
94. This.score = score;
96. }
100. @Override
102. Public String toString () {
104. Return "id=" + ID + "\tname=" + name + "\tmajor=" + Birth + "\tscore="
106. + score + "\ n";
108. }
112. }

Sqlmap.properties:

1. Driver=com.mysql.jdbc.driver
2. Url=jdbc:mysql://localhost:3306/ibatis
3. Username=root
4. Password=123

Student.xml:

2. <?xmlversion= "1.0" encoding= "UTF-8"?>
4. <! DOCTYPE sqlmap Public "-//ibatis.apache.org//dtd SQL Map 2.0//en"
6. "Http://ibatis.apache.org/dtd/sql-map-2.dtd">
10. <sqlMap>
12. <!--by Typealias allows us to use the student entity class below without having to write the package name--
14. <typealiasalias= "Student" type= "com.iflytek.entity.Student"/>
18. <!--so you don't have to change the Java code---
20. <!--ID represents the SQL statement in Select, ResultClass indicates the type of return result--
22. <selectid= "selectallstudent" resultclass= "Student">
24. SELECT * FROM
26. Tbl_student
28. </select>
32. <!--Parameterclass represents the contents of the parameter--
34. <!--#表示这是一个外部调用的需要传进的参数, which can be understood as placeholders--
36. <selectid= "Selectstudentbyid" parameterclass= "int" resultclass= "Student">
38. SELECT * from Tbl_student where id= #id #
40. </select>
44. <!--note the type of resultclass here, using the student type depends on queryForList or queryforobject-
46. <selectid= "Selectstudentbyname" parameterclass= "String"
48. resultclass= "Student">
50. Select Name,birth,score from tbl_student where name
52. '% $name $% '
54. </select>
58. <insertid= "addstudent" parameterclass= "Student">
60. INSERT INTO
62. Tbl_student (Name,birth,score) values
64. (#name #, #birth #, #score #)
66. <selectkeyresultclass= "int" keyproperty= "id">
68. SELECT @ @identity as inserted
70. <!--Here we need to explain the generation of different database primary keys in different ways for each database:-
72. <!--Mysql:select last_insert_id () as VALUE--
74. <!--mssql:select @ @IDENTITY as value--
76. <!--Oracle:select Stockidsequence. Nextval as VALUE from DUAL to
78. <!--It's also important to note that different database manufacturers generate primary keys differently, and some are pre-generated (pre-generate) primary keys, such as Oracle and PostgreSQL.
80. Some are post-generation (post-generate) primary keys, such as MySQL and SQL Server so if it's an Oracle database, you'll need to write selectkey before insert-->
82. </selectKey>
84. </insert>
88. <deleteid= "Deletestudentbyid" parameterclass= "int">
90. <!--#id # ID can be taken arbitrarily, but the above insert will have an effect, because the name above will be found in the properties of the student.
92. <!--We can also understand that if there is a # placeholder, then Ibatis will call the properties in Parameterclass to assign value--
94. Delete from tbl_student where id= #id #
96. </delete>
100. <updateid= "updatestudent" parameterclass= "Student">
102. Update Tbl_student Set
104. Name= #name #,birth= #birth #,score= #score # where id= #id #
106. </update>
110. </sqlMap>

Description

If there is no ibatis hint in the XML, then window--preference--> xml-->xml Catalog---> Click Add

Select URI URI: Select on local file system

IBATISDEMO1/WEBCONTENT/WEB-INF/LIB/SQL-MAP-CONFIG-2.DTD file;

Key Type: Select schema location;

Key: Need to be networked, not recommended for use;

Sqlmapconfig.xml:

2. <?xmlversion= "1.0" encoding= "UTF-8"?>
4. <! DOCTYPE sqlmapconfig Public "-//ibatis.apache.org//dtd SQL Map Config 2.0//en"
6. "Http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
10. <sqlMapConfig>
12. <!--the configuration file that references the JDBC Property--
14. <propertiesresource= "com/iflytek/entity/sqlmap.properties"/>
16. <!--transaction Management using JDBC--
18. <transactionmanagertype= "JDBC">
20. <!--data Source-
22. <datasourcetype= "simple">
24. <propertyname= "JDBC. Driver "value=" ${driver} "/>
26. <propertyname= "JDBC. Connectionurl "value=" ${url} "/>
28. <propertyname= "JDBC. Username "value=" ${username} "/>
30. <propertyname= "JDBC. Password "value=" ${password} "/>
32. </dataSource>
34. </transactionManager>
36. <!--Here you can write a mapping file for multiple entities--
38. <sqlmapresource= "Com/iflytek/entity/student.xml"/>
40. </sqlMapConfig>

Studentdao:

2. Package Com.iflytek.dao;
6. Import java.util.List;
10. Import com.iflytek.entity.Student;
14. /**
16. * @author Xudongwang 2011-12-31
18. *
20. * Email:[email protected]
22. *
24. */
26. Publicinterface Studentdao {
30. /**
32. * Add student Information
34. *
36. * @param student
38. * Student Entity
40. * @return Returns whether the add succeeded
42. */
44. Publicboolean addstudent (Student Student);
48. /**
50. * Delete Student information based on student ID
52. *
54. * @param ID
56. * Student ID
58. * @return Delete is successful
60. */
62. Publicboolean Deletestudentbyid (int id);
66. /**
68. * Update student Information
70. *
72. * @param student
74. * Student Entity
76. * @return Update is successful
78. */
80. Publicboolean updatestudent (Student Student);
84. /**
86. * Check all student information
88. *
90. * @return Return to Student list
92. */
94. Public list<student> selectallstudent ();
98. /**
100. * Students ' information is blurred according to student's name
102. *
104. * @param name
106. * Student Name
108. * @return Student Information List
110. */
112. Public list<student> selectstudentbyname (String name);
116. /**
118. * Check student information based on student ID
120. *
122. * @param ID
124. * Student ID
126. * @return Student Object
128. */
130. Public Student Selectstudentbyid (int id);
134. }

Studentdaoimpl:

2. Package Com.iflytek.daoimpl;
6. Import java.io.IOException;
8. Import Java.io.Reader;
10. Import java.sql.SQLException;
12. Import java.util.List;
16. Import com.ibatis.common.resources.Resources;
18. Import com.ibatis.sqlmap.client.SqlMapClient;
20. Import Com.ibatis.sqlmap.client.SqlMapClientBuilder;
22. Import Com.iflytek.dao.StudentDao;
24. Import com.iflytek.entity.Student;
28. /**
30. * @author Xudongwang 2011-12-31
32. *
34. * Email:[email protected]
36. *
38. */
40. Publicclass Studentdaoimpl implements Studentdao {
44. privatestatic sqlmapclient sqlmapclient = null;
48. Reading configuration Files
50. static {
52. try {
54. Reader reader = Resources
56. . Getresourceasreader ("Com/iflytek/entity/sqlmapconfig.xml");
58. Sqlmapclient = sqlmapclientbuilder.buildsqlmapclient (reader);
60. Reader.close ();
62. } catch (IOException e) {
64. E.printstacktrace ();
66. }
68. }
72. Publicboolean addstudent (Student Student) {
74. Object object = null;
76. Boolean flag = false;
78. try {
80. Object = Sqlmapclient.insert ("addstudent", student);
82. System.out.println ("Add return value of Student information:" + object);
84. } catch (SQLException e) {
86. E.printstacktrace ();
88. }
90. if (Object! = null) {
92. Flag = true;
94. }
96. return flag;
98. }
102. Publicboolean Deletestudentbyid (int id) {
104. Boolean flag = false;
106. Object object = null;
108. try {
110. Object = Sqlmapclient.delete ("Deletestudentbyid", id);
112. System.out.println ("Delete Student information return value:" + Object + ", here returns the number of rows affected");
114. } catch (SQLException e) {
116. E.printstacktrace ();
118. }
120. if (Object! = null) {
122. Flag = true;
126. }
128. return flag;
132. }
136. Publicboolean updatestudent (Student Student) {
138. Boolean flag = false;
140. Object object = false;
142. try {
144. Object = Sqlmapclient.update ("updatestudent", student);
146. SYSTEM.OUT.PRINTLN ("Update the return value of student information:" + Object + ", returns the number of rows affected");
148. } catch (SQLException e) {
150. E.printstacktrace ();
152. }
154. if (Object! = null) {
156. Flag = true;
158. }
160. return flag;
162. }
166. Public list<student> selectallstudent () {
168. List<student> students = NULL;
170. try {
172. Students = sqlmapclient.queryforlist ("selectallstudent");
174. } catch (SQLException e) {
176. E.printstacktrace ();
178. }
180. return students;
182. }
186. Public list<student> selectstudentbyname (String name) {
188. List<student> students = NULL;
190. try {
192. Students = sqlmapclient.queryforlist ("Selectstudentbyname", name);
194. } catch (SQLException e) {
196. E.printstacktrace ();
198. }
200. return students;
202. }
206. Public Student Selectstudentbyid (int id) {
208. Student Student = null;
210. try {
212. Student = (student) Sqlmapclient.queryforobject (
214. "Selectstudentbyid", id);
216. } catch (SQLException e) {
218. E.printstacktrace ();
220. }
222. return student;
224. }
226. }

Testibatis.java:

2. Package com.iflytek.test;
6. Import Java.sql.Date;
8. Import java.util.List;
12. Import Com.iflytek.daoimpl.StudentDaoImpl;
14. Import com.iflytek.entity.Student;
18. /**
20. * @author Xudongwang 2011-12-31
22. *
24. * Email:[email protected]
26. *
28. */
30. Publicclass Testibatis {
34. Publicstaticvoid Main (string[] args) {
36. Studentdaoimpl Studentdaoimpl = new Studentdaoimpl ();
40. SYSTEM.OUT.PRINTLN ("test Insert");
42. Student addstudent = new Student ();
44. Addstudent.setname ("John Doe");
46. Addstudent.setbirth (date.valueof ("2011-09-02"));
48. Addstudent.setscore (88);
50. System.out.println (Studentdaoimpl.addstudent (addstudent));
54. SYSTEM.OUT.PRINTLN ("Test based on ID query");
56. System.out.println (Studentdaoimpl.selectstudentbyid (1));
60. SYSTEM.OUT.PRINTLN ("Test fuzzy query");
62. list<student> mohulists = studentdaoimpl.selectstudentbyname ("Li");
64. for (Student student:mohulists) {
66. SYSTEM.OUT.PRINTLN (student);
68. }
72. SYSTEM.OUT.PRINTLN ("Test query All");
74. list<student> students = studentdaoimpl.selectallstudent ();
76. for (Student student:students) {
78. SYSTEM.OUT.PRINTLN (student);
80. }
84. System.out.println ("Delete student information by id");
86. System.out.println (Studentdaoimpl.deletestudentbyid (1));
90. SYSTEM.OUT.PRINTLN ("Test update student Information");
92. Student updatestudent = new Student ();
94. Updatestudent.setid (1);
96. Updatestudent.setname ("Li 41");
98. Updatestudent.setbirth (date.valueof ("2011-08-07"));
100. Updatestudent.setscore (21);
102. System.out.println (Studentdaoimpl.updatestudent (updatestudent));
106. }
108. }

IBatis Simple Introduction and Basic primer