查询:
Sql代码
select * from table_name
删除:
java代码
delete from table_name where 条件
修改:
Sql代码
update table_name set 字段=新值 where 条件
动态添加条件:
Java代码
select * from table_name where 1=1;
Java代码
select * table_name where 字段 like '%8'
查询:
Sql代码
select * from table_name
删除:
java代码
delete from table_name where 条件
修改:
Sql代码
update table_name set 字段=新值 where 条件
动态添加条件:
Java代码
select * from table_name where 1=1;
Java代码
select * table_name where 字段 like '%8'