Friday, March 9, 2012 BY Keith Boone
这个32行的程序是为了让JSP页面能够根据Trifolia Workbench database 构建一个 IHE SVS Value Set 的实现。它完全没有处理任何错误,如果变量匹配的话 就得到 valueset, valuesetmember and dictionarycodesystem表中的数据。
<?xml version="1.0" encoding="ISO-8859-1" ?>
<svs:RetrieveValueSetResponse xmlns:svs="urn:ihe:iti:svs:2008" xmlns:html="http://www.w3.org/1999/xhtml"><%@
taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %><%@
taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %><%@
taglib uri="http://java.sun.com/jsp/jstl/xml" prefix="x"
%><sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/templatedb"
user="user" password="password"
/><sql:query dataSource="${snapshot}" var="valueset"
>SELECT valueSetName, description, ID from valueset WHERE OID = ?;
<sql:param>${param.id}</sql:param>
</sql:query>
<svs:ValueSet version="" displayName="${valueset.rowsByIndex[0][0]}" id="${param.id}">
<svs:ConceptList xml:lang="en-US">
<sql:query dataSource="${snapshot}" var="members"
>SELECT m.code code, m.displayName displayname, m.codeSystemOID codeSystemOID, cs.codeSystemName codeSystemName
FROM valuesetmember m
LEFT JOIN dictionarycodesystem cs
ON m.codeSystemOID = cs.OID
WHERE m.valueSetOId = ?;
<sql:param>${param.id}</sql:param>
</sql:query
>
<c:forEach var="row" items="${members.rows}">
<svs:Concept code="${row.code}" displayName="${row.displayName}" codeSystem="${row.codeSystemOID}" codeSystemName="${row.codeSystemName}" />
</c:forEach>
</svs:ConceptList>
</svs:ValueSet>
</svs:RetrieveValueSetResponse>
如何使用
1 安装MySQL Community Edition and JDBC Drivers
2.安装Trifolia Workbench (zip)
3.安装JSTL Libraries and MySQL JDBC Drivers into your Web Application
4.将上面的源码复制到RetrieveValueSet.jsp
5.根据MySQL的安装 更改用户名和密码
6.在WEB-INF文件夹下的web.xml中添加如下行
<servlet>
<description>A Servlet conforming to the IHE SVS Profile</description>
<display-name>IHE SVS Servlet</display-name>
<servlet-name>RetrieveValueSet</servlet-name>
<jsp-file>/RetrieveValueSet.jsp</jsp-file>
</servlet>
<servlet-mapping>
<servlet-name>RetrieveValueSet</servlet-name>
<url-pattern>/RetrieveValueSet</url-pattern>
</servlet-mapping>
转载本文请联系原作者获取授权,同时请注明本文来自王海生科学网博客。 链接地址: https://wap.sciencenet.cn/blog-615874-548059.html
上一篇:
译自Liberating Consolidated CDA Templates from the Trifolia 下一篇:
译自The XSLT document() function