1.@select注解
接口
//查询所有供应商 @Select( "select * from smbms_provider") public List<Provider> getAllProvider(String proName);
测试类
//查询数据 @Test public void SelectTest(){ List<Provider> provider = providerTest.getAllProvider("BJ_GYS002"); for (Provider providers:provider) { System.out.println(providers.getPid()); } }
2.@insert注解
接口
//添加供应商 @Insert("insert into smbms_provider (proCode,proName,proContact,proPhone,proAddress,proDesc,createdBy,creationDate,proFaxint) " + " values(#{proCode},#{proName},#{proContact},#{proPhone},#{proAddress},#{proDesc},#{createdBy},#{creationDate},#{proFaxint})") public int addProvider(Provider provider);
测试类
//添加数据 @Test public void AddTest(){ Provider provider=new Provider(); provider.setProCode("BJ_E1234"); provider.setProName("北京臭豆腐公司"); provider.setCreationDate(new Date()); provider.setCreatedBy(BigInteger.valueOf(1)); provider.setProAddress("北京市海淀区"); provider.setProPhone("13011028454"); provider.setProContact("zn"); provider.setProDesc("非常臭"); provider.setProFaxint("438-54250"); int addProvider = providerTest.addProvider(provider); sqlSession.commit(); System.out.println(addProvider); }
3.@delete注解
接口
//删除供应商 @Delete(" delete from smbms_provider where id=#{value}") public int delProvider(int id);
测试类
@Test //删除数据 public void deleteTest(){ int delProvider = providerTest.delProvider(26); sqlSession.commit(); System.out.println(delProvider); }
4.@update注解
//修改供应商 @Update(" update smbms_provider set proCode=#{proCode},proName=#{proName},proContact=#{proContact},proPhone=#{proPhone},proAddress=#{proAddress},proFaxint=#{proFaxint},proDesc=#{proDesc} where id=#{id}") public int updaProvider(Provider provider);
测试类
@Test //修改数据 public void updateTest(){ Provider provider=new Provider(); provider.setPid(24); provider.setProCode("ZN_ZN250"); provider.setProName("北京臭豆腐公司"); provider.setCreationDate(new Date()); provider.setCreatedBy(BigInteger.valueOf(1)); provider.setProAddress("北京市海淀区"); provider.setProPhone("13011028454"); provider.setProContact("郑楠"); provider.setProDesc("非常臭"); provider.setProFaxint("438-54250"); int i = providerTest.updaProvider(provider); sqlSession.commit(); System.out.println(i); }
5.关联查询一对多—@many注解
6.关联查询多对一——@one注解