样例 sql 语句:
create table emp1(
id varchar2(20) primary key,
name varchar2(20)unique not null,
password varchar2(6)check(length(password)=6)not null,
salary number(8,2),
age varchar2(3),
sex varchar2(3)check(sex in('男','女')),
entryday date,
status varchar(2)check(status in('1','2')));--创建 序列
create sequence empid_seq start with 1 increment by 1;--查询表
select * from emp1
package com.dao;import com.entity.Empl1;import java.util.List;import org.apache.ibatis.annotations.Param;publicinterfaceEmp1Dao{//登录 查询 当传入的参数为多个(大于一个) 则用注解注明 注解内的变量名应与具体sql语句用于变量名一致,如下列 登录功能public Empl1 fandNameAndPassDao(@Param("name")String name,@Param("password") String password);//注册 添加publicvoidaddEmp1Dao(Empl1 emp);//展示所有 public List<Empl1>fianEmp1AllDao();//根据 id 查询 一个对象public Empl1 fandByIdEmp1Dao(String id);//根据 id 删除publicvoiddeleteByIdEmp1Dao(String id);//根据 id 修改publicvoidupdateByIdEmp1Dao(Empl1 emp);//模糊查询 根据名称查询public List<Empl1>likefindall(String name);//根据名称查询一个人的对象public Empl1 fiandByNameEmp1Dao(String name);//获取 总条数publicintFindEmpl1Count();}
第五步 创建 Dao接口对应的MapperImpl.xml文件(取代jdbc实现类)
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.dao.Emp1Dao"><!-- 登录 --><select id="fandNameAndPassDao" resultType="com.entity.Empl1">
select * from Emp1 where name =#{name}and password=#{password}</select><!-- 注册 --><insert id="addEmp1Dao" parameterType="com.entity.Empl1">
insert into emp1(id,name,password,salary,age,sex,entryday,status)values(empid_seq.nextval,#{name},#{password},#{salary},#{age},#{sex},#{entryday},#{status})</insert><!-- 展示所有 --><select id="fianEmp1AllDao" resultType="com.entity.Empl1">
select * from Emp1
</select><!--根据 id 查询 一个对象 --><select id="fandByIdEmp1Dao" resultType="com.entity.Empl1">
select * from Emp1 where id =#{id}</select><!--根据 id 修改 --><update id="updateByIdEmp1Dao" parameterType="com.entity.Empl1">
update emp1 set name=#{name},salary=#{salary},age=#{age} where id=#{id}</update><!--根据 id 删除 --><delete id="deleteByIdEmp1Dao">
delete emp1 where id = #{id}</delete><!--模糊查询 根据名称查询 --><select id="likefindall" resultType="com.entity.Empl1">
select * from emp1 where name like '%'||#{name}||'%'</select><!--根据名称查询一个人的对象 --><select id="fiandByNameEmp1Dao" resultType="com.entity.Empl1">
select * from Emp1 where name =#{name}</select><!--获取本表数据的总条数 --><select id="FindEmpl1Count" resultType="int">
select count(*) from Emp1
</select></mapper>