傳入?yún)?shù)param，查找數(shù)據(jù)庫(kù)中有沒(méi)有param對(duì)應(yīng)的記錄
private static final String SQL_GET = "SELECT count(*) as c FROM alarm t %s;";
public boolean exist(String param) {
boolean exist = false;
String condition = "";
if (param.equals("id")) {
condition = "WHERE t.id = '" + id + "'";
} else if (param.equals("name")) {
condition = "WHERE t.name = '" + name + "'";
} else {
condition = "WHERE t.meter = '" + meter + "'";
}
String sql = String.format(SQL_GETALARMEXIST, condition);
try {
Connection conn = DriverManager.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = sm.executeQuery(sql);
while (rs.next()) {
exist = rs.getInt("c") > 0;
}
} catch (Exception e) {
e.printStack();
} finally {
conn.close(sm);
}
return exist;
}
傳入id則以id拼接WHERE子句，依此類圖，但是總覺(jué)得不夠靈活，在不使用其他框架的前提下，有沒(méi)有什么更靈活的實(shí)現(xiàn)方式呢？
添加回答
舉報(bào)
0/150
提交
取消