ibatis增刪改查.doc

張國(guó)良編輯public List quereyAll();/ 查詢?nèi)縫ublic Students quereyById(int sid);/ 查詢單條void saveStudents(Students students);/ 添加void delStudents(int id);/ 刪除void updateStudents(Students students);/ 更新 select* from students select * from students where sid=#sid# insert into students (sid,sname,major,birth,score) values( #sid#,#sname#,#major#,#birth#,#score#) update students set sname=#sname#, major=#major#, birth=#birth#, score=#score# where sid=#sid# delete students where sid =#sid# private static SqlMapClient sqlMapClient = null;static try Reader reader = mon.resources.Resources.getResourceAsReader(com/cstp/SqlMapConfig.xml);sqlMapClient = com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(reader);reader.close(); catch (IOException e) / TODO Auto-generated catch blocke.printStackTrace();public List quereyAll() / TODO Auto-generated method stubList list = null;try list = sqlMapClient.queryForList(queryAll); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return list;public Students quereyById(int sid) / TODO Auto-generated method stubStudents student = null;try student = (Students) sqlMapClient.queryForObject(queryById, sid); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return student;public void delStudents(int id) / TODO Auto-generated method stubtry sqlMapClient.delete(delStudents, id); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();public void saveStudents(Students students) / TODO Auto-generated method stubtry sqlMapClient.insert(saveStudents, students); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();public void updateStudents(Students students) / TODO Auto-generated method stubtry sqlMapClient.update(updateStudents, students); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();/* * 【小破孩兒】版權(quán)所有 * * param args * author: 張國(guó)良 */public static void main(String args) / TODO Auto-generated method stubStudentsDAO dao = new StudentsDAOImpl();/ 1.全部查詢/ List list = dao.quereyAll();/ 2.單個(gè)查詢/ System.out.println(dao.quereyById(3);/ 3.插入/ Students students = new Students();/ students.setSid(10);/ students.setSname(小破孩兒);/ students.setMajor(QQ);/ students.setBirth(Date.valueOf(1988-8-24);/ 轉(zhuǎn)換成日期類型/ students.setScore(88);/ dao.saveStudents(students);/ 4.刪除/ dao.delStudents(10);/ 5.修改/ Students students = new Students();/ students.setSid(10);/ students.setSname(小破孩兒);/ studen