1、动态SQL操作之查询
查询条件不确定,需要根据情况产生SQL语法,这种情况叫动态SQL
select emp_id,emp_name,emp_sal from emp
and emp_id = #{pid}
and emp_name like #{pname}
and emp_sal < #{psal}
2、动态SQL操作之更新
更新条件不确定,需要根据情况产生SQL语法,这种情况叫动态SQL
update emp
emp_name = #{pname},
emp_sal = #{psal},
where emp_id = #{pid}
3、动态SQL操作之删除
根据多个id进行删除
delete from emp where emp_id in
#{pid}
delete from emp where emp_id in
#{pid}
4、动态SQL操作之添加
根据条件,添加数据
emp_id,
emp_name,
emp_sal,
#{id},
#{name},
#{sal},
insert into emp() values()
5、参考代码
准备SQLCREATE TABLE Emp(
emp_id INT(5) PRIMARY KEY,
emp_name VARCHAR(20),
emp_sal DOUBLE(8,2)
);
Emp.javapackage com.rk.entity;
public class Emp {
private Integer id;
private String name;
private Double sal;
public Emp(){}
public Emp(Integer id, String name, Double sal) {
this.id = id;
this.name = name;
this.sal = sal;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}</