iBATIS实现的一个例子

技术2022-05-11 1

http://www.builder.com.cn/2007/0730/438668.shtml

这里把我学习ibatis时候，一个实现的例子发上来，供参考。

工程目录结构如下：

//1、SQL MAP配置文件

SqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd ">

<!-- <transactionManager type="JTA" > <property name="UserTransaction" value="java:comp/env/jdbc/framework"/> <dataSource type="JNDI"> <property name="DataSource" value="java:comp/env/jdbc/ibatistest"/> </dataSource> </transactionManager>

//2、SQL Map配置文件拥有唯一的<properties>元素，这样做后，在属性文件中定义的属性可以作为变量在SQL Map配置文件及其包含的所有SQL Map映射文件中引用

SqlMapConfig.xml

driver=com.microsoft.jdbc.sqlserver.SQLServerDriver url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ibatistest;SelectMethod=Cursor;

username=xiaofeng password=xiaofeng

//3、SQL Map XML映射

person.xml

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd "> <sqlMap namespace="Student">

</resultMap> <resultMap id="get-course-result" class="course"> <result property="cno" column="Cno"/> <result property="cname" column="cname"/> <result property="ccredit" column="Ccredit"/> </resultMap> <resultMap class="intro" id="get-intro-result"> <result property="sno" column="Sno"/> <result property="idescription" column="Idescription"/> </resultMap>  <select id="getStudent" parameterClass="String" resultMap="get-student-result"> select * from STUDENT WHERE Sname=#value# </select> <select id="getCourse" parameterClass="Integer" resultMap="get-course-result"> select * from COURSE WHERE Cno=#value# </select> <select id="getIntro" parameterClass="Integer" resultMap="get-intro-result"> select *from INTRO WHERE Sno=#value# </select> <select id="getSc" parameterClass="Integer" resultClass="SC"> select Cno,Grade from SC WHERE Sno=#sno# </select>

<insert id="insertStudent" parameterClass="student"> INSERT INTO STUDENT (Sno,Sname,Ssex,Sage,Sdept) VALUES (#sno#,#sname#,#ssex#,#sage#,#sdept#) </insert> <update id="updateStudent" parameterClass="student"> UPDATE STUDENT SET Sname= #sname#, Ssex= #ssex#, Sage=#sage#, Sdept=#sdept# WHERE Sno = #sno# </update> <delete id="deleteStudent" parameterClass="student"> DELETE STUDENT WHERE Sno = #sno# </delete> </sqlMap>

//４、AppSqlConfig.java

package com.study.xiaofeng; import com.ibatis.sqlmap.client.SqlMapClient; import java.io.Reader; import com.ibatis.common.resources.*; import com.ibatis.sqlmap.client.SqlMapClientBuilder;

public class AppSqlConfig { private static final SqlMapClient sqlMap; static { try { String resource ="com/study/xiaofeng/maps/SqlMapConfig.xml"; Reader reader = Resources.getResourceAsReader (resource); sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException ("Error initializing MyAppSqlConfig class. Cause: "+e); } } public static SqlMapClient getSqlMapInstance () { return sqlMap; } }

//test.java

package com.study.xiaofeng; import com.ibatis.sqlmap.client.SqlMapClient; import java.sql.*; import java.util.List; //JTA import javax.naming.InitialContext; import javax.transaction.UserTransaction; public class Test { public static void update(int no,String name,String sex,int age,String dept){ com.ibatis.sqlmap.client.SqlMapClient client = null; try{ client=new AppSqlConfig().getSqlMapInstance(); client.startTransaction(); Student student=new Student(); student.setSno(no); student.setSname(name); student.setSsex(sex); student.setSage(age); student.setSdept(dept); client.update("updateStudent",student); client.commitTransaction(); }catch(SQLException e)finally { try catch (SQLException e) } } public static void insertStudent(int no,String name,String sex,int age,String dept){ com.ibatis.sqlmap.client.SqlMapClient client = null; try{ client=new AppSqlConfig().getSqlMapInstance(); client.startTransaction(); Student student=new Student(); student.setSno(no); student.setSname(name); student.setSsex(sex); student.setSage(age); student.setSdept(dept); client.insert("insertStudent",student); client.commitTransaction(); }catch(SQLException e)finally { try catch (SQLException e) } } //一个对象直接作为属性，实现关联 public static Student getStudent(){ com.ibatis.sqlmap.client.SqlMapClient client = null; Student student=null; try{ client=new AppSqlConfig().getSqlMapInstance(); client.startTransaction(); student = (Student)client.queryForObject("getStudent","xiaofeng"); client.commitTransaction(); }catch(SQLException e)finally{ try catch (SQLException e) } return student; } //多个对象放到List中作为一个属性实现关联，但是得嵌套查询。测试一对多的关联查询 //也可以实现多对多 public static void reStudent(String name){ com.ibatis.sqlmap.client.SqlMapClient sqlMap = null; sqlMap=new AppSqlConfig().getSqlMapInstance(); try{ sqlMap.startTransaction(); List studentList=sqlMap.queryForList("getStudent",name); for(int i=0;i<studentList.size();i++){ Student student=(Student)studentList.get(i); System.out.println("姓名（表1）："+student.getSname()); for(int k=0;k<student.getSc().size();k++){ SC sc=(SC)student.getSc().get(k); Course course=(Course)sqlMap.queryForObject("getCourse", sc.getCno()); System.out.print("课程号（表2）："+sc.getCno()); System.out.print("------课程名（表3）："+course.getCname().trim()+"------分数（表2）: "+sc.getGrade()+"n"); } } sqlMap.commitTransaction(); }catch(SQLException e)finally{ try catch (SQLException e) } } public static void main(String args[]){ // update(2004131301,"xiaofeng","男",23,"信息"); reStudent("name2"); Student student=getStudent(); System.out.println("表4 描述："+student.getIntro().getIdescription()); // insertStudent(2004131305,"xiaofeng5","男",23,"信息"); ; } }

//Course.java

package com.study.xiaofeng; import java.io.Serializable; public class Course implements Serializable{ private int cno; private String cname; private int ccredit; public int getCno(){ return this.cno; } public void setCno(int no) public String getCname(){ return this.cname; } public void setCname(String name) public int getCcredit(){ return this.ccredit; } public void setCcredit(int credit) }

//Intro.java

package com.study.xiaofeng; import java.io.Serializable; public class Intro implements Serializable{ private int sno; private String idescription; public int getSno(){ return this.sno; } public void setSno(int sno) public String getIdescription(){ return this.idescription; } public void setIdescription(String description) }

//Sc.java

package com.study.xiaofeng; import java.io.Serializable; public class SC implements Serializable{ private int sno; private int cno; private int grade; private Course course; public int getSno(){ return this.sno; } public void setSno(int no) public int getCno(){ return this.cno; } public void setCno(int no) public int getGrade(){ return this.grade; } public void setGrade(int grade) public Course getCourse(){ return this.course; } public void setCourse(Course course) }

//Student.java

package com.study.xiaofeng; import java.io.Serializable; import java.util.List; public class Student implements Serializable{ private int sno; private String sname; private String ssex; private int sage; private String sdept; private List sc; private Intro intro; public int getSno(){ return this.sno; } public void setSno(int no) public String getSname(){ return this.sname; } public void setSname(String name) public String getSsex(){ return this.ssex; } public void setSsex(String sex) public int getSage(){ return this.sage; } public void setSage(int age) public String getSdept(){ return this.sdept; } public void setSdept(String dept) public List getSc(){ return this.sc; } public void setSc(List sc) public Intro getIntro(){ return this.intro; } public void setIntro(Intro intro) }

//运行结果如下：

专利

最新回复(0)