讲义教案讲稿

MyBatis课堂演示源码（增删改查<?xmlversion="1.0"encoding="UTF-<!DOCTYPEconfigurationPUBLIC"-////DTDConfig3.0//EN""http://<environments<environment<transactionManagertype="jdbc"<dataSource<propertyname="driver"value="com.mysql.jdbc.Driver"<propertyname="url"cloud_study"<propertyname="username"value="root"<propertyname="password"value="123456"<mappermapper配置文件<?xmlversion="1.0"encoding="UTF-8"<!DOCTYPEmapperPUBLIC"-////DTDMapper3.0//EN""http://<mapper<insertid="addUser"parameterType="fession.mybatis.User"useGeneratedKeys="true"keyProperty="id">insertintouser(userName,corp)<selectid="getUser"parameterType="int"selectid,userName,corpfromuserwhereid=#{id}<updateid="updateUser"parameterType="fession.mybatis.User">updateusersetuserName=#{userName},corp=#{corp}whereid=#{id}<deleteid="deleteUser"parameterType="fession.mybatis.User">deletefromuserwhereid=BeanspublicclassUser{privateintprivateStringuserName;privateStringcorp;publicUser(Integerid,StringuserName,String{this.id=id;this.userName=userName;this.corp=corp;}publicUser(StringuserName,String{this.userName=userName;this.corp=corp;}publicint{return}publicvoidsetId(int{this.id=}publicString{return}publicvoidsetUserName(String{this.userName=}publicString{return}publicvoidsetCorp(String{this.corp=}}接口定义类packagepublicinterfaceUserOppublicvoidaddUser(Useruser);publicvoidupdateUser(Useruser);publicvoiddeleteUser(intid);publicUsergetUser(intid);}测试 importjava.io.InputStream;importorg.apache.ibatis.session.SqlSession;publicclass oMyBatisMoreOp{publicstaticvoidmain(String[]{}publicstaticvoidmoreOp()//1.配置文Stringresource=2InputStreamis 3创建SqlSessionFactorysessionFactory=newSqlSessionsession=sessionFactory.openSession(true);try{5UserOpuserOp=session.getMapper(UserOp.class);Useruser=newUser("XiaoMing","Netease");user=userOp.getUser(user.getId());System.out.