public class Test
{
/** *//**
* Test Method
*/
private void service(){
String param[] = {
"name", "id"
};
Object values[] = {
"minli", 1
};
update("Customer", param, values);
}
/** *//**
* 更新 （該方法目前只針對一個查詢參數，至于多參數的可以在此基礎上更改，思路則不變）
* @params 為要更新實體當中的屬性，其中最后一個為查詢參數
*/
private void update(String entity, String[] params, Object[] values){
if (params == null || values == null)
throw new NullPointerException("param is null!");
if (params.length < 2 || values.length < 2)
throw new IllegalArgumentException("param is wrong");
if (params.length != values.length)
throw new IllegalArgumentException("param is wrong");
String updateHQL = updateSQL(entity, params, values);
//這個地方可以使用query來進行遍歷數組來賦值
System.out.println(updateHQL);
}
/** *//**
* 生成Update HQL語句
*/
private String updateSQL(String entity, String[] params, Object[] values){
String entityName = entity.toLowerCase();
String baseHQL = "update " + entity + " " + entityName + " set ";
for (int i = 0; i < params.length - 1; i++){
String param = params[i];
baseHQL += entityName + "." + param + "=:" + param;
if (i < params.length - 2)
baseHQL += ",";
}
String param = params[params.length - 1];
baseHQL += " where " + entityName + "." + param + "=:" + param;
return baseHQL;
}
public static void main(String[] args){
new Test().service();
}
}
