iBATIS实现的一个例子

最新推荐文章于 2017-11-28 11:12:00 发布

abo38416

最新推荐文章于 2017-11-28 11:12:00 发布

阅读量81

点赞数

文章标签： java 数据库

原文链接：http://www.cnblogs.com/zhaoxd/archive/2013/05/31/3110188.html

版权

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

工程目录结构如下：

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)
}