1:先准备SQL函数
if object_id('zf_a332_getname') is not null
drop function zf_a332_getname
go
create function zf_a332_getname(@sgehr varchar(20))
returns nvarchar(50)
as
begin
declare @S nvarchar(50)
select @S = oa_name from zv_hrm where ehr_num = @sgehr
if len(@s)=0
begin
set @s = '未找到EHR编号对应姓名,请联系管理员。'
end
return @S
end
go
select dbo.zf_a332_getname('107011') as sgname
2:准备取数JSP文件:json_a332_getRecord.jsp
<%@ page language="java" import="java.util.*" contentType="text/html; charset=gbk" %>
<%@ page import="java.io.*"%>
<%@ page import="weav