iBatis_学习笔记.doc

iBatis 学习笔记 Author : meetweb mail: 环境配置1. 导入ibatis-26.jar mysql-connector-java-5.1.6-bin.jar导入配置文件SqlMapConfig.xml SqlMpertiesdriver=com.mysql.jdbc.Driverurl=jdbc:mysql://testusername=rootpassword=adminStudent.xml select * from student 2. 建立对应表-类文件 3. package com.it;4.5. import java.sql.Date;6.7. public class Note 8. private int sid=0;9. private String sname=null;10. private String major=null;11. private Date birth=null;12. 执行文件 package com.it;import java.io.IOException;import java.io.Reader;import java.sql.SQLException;import java.util.List;import com.ibatis.sqlmap.client.SqlMapClient;public class IStudentDAOImpl implements IStudentDao private static SqlMapClient sqlMapClinet=null;static Reader reader;try reader = mon.resources.Resources.getResourceAsReader(com/it/SqlMapConfig.xml);sqlMapClinet=com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(reader);reader.close(); catch (IOException e) / TODO Auto-generated catch blocke.printStackTrace();public List queryAllN() / TODO Auto-generated method stubList studentList =null;try studentList=sqlMapClinet.queryForList(selectAllNote); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return studentList;public static void main(String args)IStudentDao dao=new IStudentDAOImpl();/dao.queryAllStudent();System.out.println(OK);/List myList=dao.queryAllStudent();for(Note student :dao.queryAllStudent()System.out.println(student.getSname();二 单表增删改操作Note.xml select * from Note select sid,sname,major,birth from Note where sid=#sid# insert into Note ( sid, sname, major, birth ) values( #sid#,#sname#,#major#,#birth#) update note set sname=#sname#, major=#major#, birth=#birth# where sid=#sid# delete from Note where sid=#sid# call swap_email_address (?)Note.Javapackage com.it;import java.sql.Date;public class Note private int sid=0; private String sname=null; private String major=null; private Date birth=null; private int book_oid; public int getBook_oid() return book_oid;public void setBook_oid(int bookOid) book_oid = bookOid;public int getSid() return sid;public void setSid(int sid) this.sid = sid;public String getSname() return sname;public void setSname(String sname) this.sname = sname;public String getMajor() return major;public void setMajor(String major) this.major = major;public Date getBirth() return birth;public void setBirth(Date birth) this.birth = birth;记得在sqlMapConfig.xml中加如下语句执行文件package com.it;/* *2010-10-8 *单表操作CRUD */import java.io.IOException;import java.io.Reader;import java.sql.Date;import java.sql.SQLException;import java.util.Iterator;import java.util.List;import com.ibatis.sqlmap.client.SqlMapClient;public class INoteDAOImpl implements INoteDao private static SqlMapClient sqlMapClinet=null;static Reader reader;try String resource=com/it/SqlMapConfig.xml;reader = mon.resources.Resources.getResourceAsReader(resource);sqlMapClinet=com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(reader);reader.close(); catch (IOException e) / TODO Auto-generated catch blocke.printStackTrace();public void addNoteBySequence(Note note) public void addNote(Note note) try sqlMapClinet.insert(insertNote, note); catch (SQLException e) e.printStackTrace(); public void delNoteById(int id) try sqlMapClinet.delete(deleteNoteById, id); catch (SQLException e) e.printStackTrace();public List queryAllNote() List noteList =null;try noteList=sqlMapClinet.queryForList(selectAllNote); catch (SQLException e) e.printStackTrace();return noteList;public Note queryNoteById(int id) Note note =null;try note=(Note)sqlMapClinet.queryForObject(selectNoteById, id); catch (SQLException e) e.printStackTrace();return note;public List queryNoteByName(String name) return null;public void updateNote(Note note) try sqlMapClinet.update(updateNoteById, note); catch (SQLException e) e.printStackTrace();public static void main( String args) INoteDao dao=new INoteDAOImpl();/dao.queryAllStudent();System.out.println(OK);/*for(Note student :dao.queryAllNote()System.out.println(student.getSname();System.out.println(dao.queryNoteById(1);*/Note note =new Note();note.setSid(10);note.setSname(xname1);note.setMajor(C#1);note.setBirth(Date.valueOf(2012-10-8);dao.addNote(note);/dao.updateNote(note);/dao.delNoteById(10);三 . 2个表关联查询Note.javapublic class Note private int sid=0; private String sname=null; private String major=null; private Date birth=null; private int book_oid; public int getBook_oid() return book_oid;public void setBook_oid(int bookOid) book_oid = bookOid;public int getSid() return sid;public void setSid(int sid) this.sid = sid;public String getSname() return sname;public void setSname(String sname) this.sname = sname;public String getMajor() return major;public void setMajor(String major) this.major = major;public Date getBirth() return birth;public void setBirth(Date birth) this.birth = birth;Note.javapackage com.it;import java.util.List;public class Book private int oid; private String name; private List notes; public int getOid() return oid;public void setOid(int oid) this.oid = oid;public String getName() return name;public void setName(String name) = name;public List getNotes() return notes;public void setNotes(List notes) this.notes = notes;Book.xml Note.xml select * from Note 测试package com.it;/* *2010-10-8 *2表关联 */import java.io.IOException;import java.io.Reader;import java.sql.Date;import java.sql.SQLException;import java.util.Iterator;import java.util.List;import com.ibatis.sqlmap.client.SqlMapClient;public class INoteDAOImpl implements INoteDao private static SqlMapClient sqlMapClinet=null;static Reader reader;try String resource=com/it/SqlMapConfig.xml;reader = mon.resources.Resources.getResourceAsReader(resource);sqlMapClinet=com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(reader);reader.close(); catch (IOException e) / TODO Auto-generated catch blocke.printStackTrace();public static void main( String args) try List books=sqlMapClinet.queryForList(selectAllBooks);System.out.println(books.size();Book book=(Book)books.get(0); /System.out.println(book.getName(); List notes=(List) book.getNotes(); for (Iterator iterator = notes.iterator(); iterator.hasNext();) Note note = (Note) iterator.next(); System.out.println(note.getBook_oid(); System.out.println(note.getSname(); catch (SQLException e) e.pr