mapper.xml dao实现类 sqlDevlope图形化工具 dos命令行
ssm框架：写到mapper.xml文件中
<mapper namespace="com.xdl.dao.DeptDao">
<select id="findAll" resultType="com.xdl.entity.Dept">
select * from DEPT order by DEPTNO
</select>
<insert id="save" parameterType="com.xdl.entity.Dept">
insert into DEPT (DEPTNO,DNAME,LOC)
values (dept_seq.nextval,#{dname},#{loc})
</insert>
</mapper>
ssh框架：写到daoImpl类中
@Resource
private HibernateTemplate template;
@Override
public List<Dept> findAll() {
String hql = "from Dept order by deptno";
List list = template.find(hql);
return list;
}