ibatis增删改查

《ibatis增删改查》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、张国良编辑publicListquereyAll();//查询全部publicStudentsquereyById(intsid);//查询单条voidsaveStudents(Studentsstudents);//添加voiddelStudents(intid);//删除voidupdateStudents(Studentsstudents);//更新select*fromstudents

2、ass="int"resultClass="Students">select*fromstudentswheresid=#sid#insertintostudents(sid,sname,major,birth,score)values(#sid#,#sname#,#major#,#birth#,#score#)updatestudentss

3、etsname=#sname#,major=#major#,birth=#birth#,score=#score#wheresid=#sid#deletestudentswheresid=#sid#张国良编辑张国良编辑privatestaticSqlMapClientsqlMapClient=null;static{try{Readerreader=com.ibatis.common.resources.Resources.getResourceAsRea

4、der("com/cstp/SqlMapConfig.xml");sqlMapClient=com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(reader);reader.close();}catch(IOExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}}publicListquereyAll(){//TODOAuto-generatedmethodstubListlist=null;t

5、ry{list=sqlMapClient.queryForList("queryAll");}catch(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}returnlist;}publicStudentsquereyById(intsid){//TODOAuto-generatedmethodstubStudentsstudent=null;try{student=(Students)sqlMapClient.queryForObject("queryById",sid);}catch(SQL

6、Exceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}returnstudent;}张国良编辑张国良编辑publicvoiddelStudents(intid){//TODOAuto-generatedmethodstubtry{sqlMapClient.delete("delStudents",id);}catch(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}}publicvoidsaveStudents(Studen

7、tsstudents){//TODOAuto-generatedmethodstubtry{sqlMapClient.insert("saveStudents",students);}catch(SQLExceptione){//TODOAuto-generatedcatchblocke.printStackTrace();}}publicvoidupdateStudents(Studentsstudents){//TODOAuto-generatedmethodstubtry{sqlMap