xml文件的中sql的写法:
下面文件的文件名:sql_config.xml
<?xml version="1.0" encoding="UTF-8"?>
<java version="1.6.0-beta2" class="java.beans.XMLDecoder">
<object id="alarm_message" name="alarm_message"
class="twaver.Node">
<!--保存人员关系信息 -->
<void method="putClientProperty">
<string>alarm_selectRenationInfo_sql</string>
/*sql name*/
<string>
insert into CFG_RELATIONAL_RULES(RULER_ID,USER_ID) values(@RULER_ID,@USER_ID);
</string>
/*sql desc*/
</void>
<void property="name">
<string>alarm_message</string>
</void>
</object>
</java>
获得sql的连接以后,即connection 和 prparestatment 对象以后:执行下面的语句:
String sql = SqlConfigFactory.getDataBox("alarmmessage").getElementByName(
"alarm_message").getClientProperty("alarm_deleteRulerByRulerName_sql")
.toString();
sql = sql.replace("@FORWARD_RULE_NAME", ruler.getRulerName());
// 删除规则sql
System.out.println("删除规则sql" + sql);
stmt.addBatch(sql);