---
title: "J2EE预览：使用XML封装JDBC语句设计"
author: "java1573"
date: "2007-09-17T12:31:24Z"
tags: []
slug: "j2ee-xml-jdbc"
draft: false
lastmod: "2007-09-17T12:31:24Z"
id: 124704
url: "https://java1573.iteye.com/blog/124704"
---

xml内容示例:  
&lt;sql id="001" comment="查询学生信息"&gt;&lt;/sql&gt;  
    select * fom t\_stu a  
    where a.stu\_id='{0}'  
    and a.stu\_name='{1}'

&lt;sql id="002" comment="更新学生信息"&gt;&lt;/sql&gt;  
    update t\_stu a  
    set a.comment='学生{1}'||'学号:{0}'  
    where set a.stu\_id='{0}'

java 伪代码：

String sql = sqlUtil.getSQLByID("001");  
String comment = sqlUtil.getCommentByID("001");  
sql.setParamMeterByName(0,"100");  
sql.setParamMeterByName(1,"张三");

这时sql字符串的内容实际为：  
sql =   "select * fom t\_stu a  where a.stu\_id='100'  and a.stu\_name='张三';

stmt.executesql(sql);  
println(comment+"执行成功!");