根据用户名模糊查询
(1)定义接口中的方法
(2)语句
(3)配置
(4)通过session.getMapper()返回的对象不是实现类对象
UserDao.java
public interface UserDao {
public User findById(int id);
List<User> findByKeyWord(String s);
}
UserDao.xml
<select id="findById" parameterType="int" resultType="com.syy.bean.User">
select * from user where id=#{id};
</select>
<select id="findByKeyWord" parameterType="string" resultType="com.syy.bean.User">
select * from user where username like #{keyword}
</select>
test.java
@Test
public void test01(){
SqlSession sqlSession = MySessionUtils.getSession();
UserDao dao=sqlSession.getMapper(UserDao.class);
User user= dao.findById(1);
System.out.println(user);
sqlSession.close();
}
@Test
public void test02(){
SqlSession sqlSession = MySessionUtils.getSession();
UserDao dao=sqlSession.getMapper(UserDao.class);
List<User> list=dao.findByKeyWord("张%");
System.out.println(list);
sqlSession.close();
}
删除数据
(1)定义接口中的方法
(2)语句
(3)配置
(4)通过session.getMapper()返回的对象不是实现类对象
UserDao.java
public interface UserDao {
void deleteById(int id);
}
UserDao.xml
<delete id="deleteById" parameterType="int">
delete from user where id=#{id};
</delete>
test.java
@Test
public void test03(){
SqlSession sqlSession = MySessionUtils.getSession();
UserDao dao=sqlSession.getMapper(UserDao.class);
dao.deleteById(22);
sqlSession.commit();
sqlSession.close();
}
插入数据
(1)定义接口中的方法
(2)语句
(3)配置
(4)通过session.getMapper()返回的对象不是实现类对象
UserDao.java
public interface UserDao {
void saveUser(User user);
}
UserDao.xml
<insert id="saveUser" parameterType="com.wzx.bean.User">
insert into user value(null,#{username},#{birthday},#{sex},#{address})
</insert>
test.java
@Test
public void test04(){
SqlSession sqlSession = MySessionUtils.getSession();
//返回的是实现接口的实现类对象
UserDao dao = sqlSession.getMapper(UserDao.class);
User user = new User();
user.setId(100);
user.setUsername("赵四");
user.setAddress("东北");
user.setBirthday(new Date());
sqlSession.commit();
sqlSession.close();
}
在SqlMapConfig.xm中给类取别名
<typeAliases>
<package name="com.wzx.bean"/>
</typeAliases>