查詢：

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'