Ibatis Simple Getting Started tutorial

Http://www.cnblogs.com/ycxyyzw/archive/2012/10/13/2722567.html

IBatis Introduction:

IBatis is an open source project for Apache, an O/R Mapping solution, IBatis is the biggest feature is the small, quick to get started. If you don't need too many complex features, IBatis is the simplest solution to meet your requirements and be flexible enough, and now IBatis has been renamed MyBatis.

Official website: http://www.mybatis.org/

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 Advantages and Disadvantages:

Advantages:

1, reduce the amount of code, simple;

2, performance enhancement;

3. SQL The statement is separated from the program code;

4. Enhance the portability;

Disadvantages:

1, compared with hibernate, SQL needs to write its own;

2, the number of parameters can only have one, multiple parameters is not very convenient;

Ibatis Simple Getting Started tutorial