String ac = req.getParameter("ac"); if(ac==null) ac = "**********";
CDatabaseOra db = new CDatabaseOra(); ResultSet rs = null; db.InitOraDB();
try { if(!date.equals("")) { String sql="select * from AAS.AMS_KPITTAB a where a.txdate ="+date+" and a.rtype='"+rtype+"'"; sql+=" and a.region='"+rg+"' and a.agent_code='"+ac+"'"; rs = db.executeQuery(sql);
可以看看这个:
<script部分>
function new_XML_document() { try {
var doc = new ActiveXObject("MSXML.DOMDocument");
return doc;
} catch(err) {
return null;
}
}
function GetValue(rtype,rg,ac)
{
var mdd;
var md = new_XML_document(); if (md)
{
md.async = false;
md.load("../QueryKpit?date="+ym+"&rtype="+rtype+"&rg="+rg+"&ac="+ac);
if (md.parseError.errorCode == 0)
{
mdd = md.documentElement.firstChild;
}
}
var myHTML = "" ;
if(mdd)
{
myHTML = mdd.attributes.getNamedItem("name").value;
frmp1.input1.value = myHTML;
for(i=2; i<=21; i++)
{
seq = "input"+i;
mdd = mdd.nextSibling;
myHTML = mdd.attributes.getNamedItem("name").value;
frmp1.all[seq].value = myHTML;
}
}
else
{
for(i=1;i<=21;i++)
{
seq = "input"+i;
frmp1.all[seq].value="";
}
}
}
--------------------------------------------
<javaBean部分>
public class QueryKpit extends HttpServlet implements Servlet { /**
* @see javax.servlet.http.HttpServlet#void (javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
*/
public void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
resp.setContentType("text/html; charset=gbk");
PrintWriter out = resp.getWriter();
req.setCharacterEncoding("gbk");
String afyp="", accafyp="", sfyp="", accsfyp="", agpn="", agaccpn="";
String agavgpc="", agactr="", actagp="", mgrpn="", mgraccpn="", mgravgpc="";
String mgractr="", actmgrp="", mpbegin="", mpend="", smbegin="",smend="";
String ma="", agbegin="", agend="";
String date = req.getParameter("date");
if(date==null) date="";
String rtype = req.getParameter("rtype");
if(rtype==null) rtype = "";
String rg = req.getParameter("rg");
if(rg==null) rg = "*****";
String ac = req.getParameter("ac");
if(ac==null) ac = "**********";
CDatabaseOra db = new CDatabaseOra();
ResultSet rs = null;
db.InitOraDB();
try
{
if(!date.equals(""))
{
String sql="select * from AAS.AMS_KPITTAB a where a.txdate ="+date+" and a.rtype='"+rtype+"'";
sql+=" and a.region='"+rg+"' and a.agent_code='"+ac+"'";
rs = db.executeQuery(sql);
if(rs.next())
{
afyp = rs.getString(7);
accafyp = rs.getString(8);
sfyp = rs.getString(9);
accsfyp = rs.getString(10);
agpn = rs.getString(11);
agaccpn = rs.getString(12);
agavgpc = rs.getString(13);
agactr = rs.getString(14);
actagp = rs.getString(15);
mgrpn = rs.getString(16);
mgraccpn = rs.getString(17);
mgravgpc = rs.getString(18);
mgractr = rs.getString(19);
actmgrp = rs.getString(20);
mpbegin = rs.getString(21);
mpend = rs.getString(22);
smbegin = rs.getString(23);
smend = rs.getString(24);
ma = rs.getString(25);
agbegin = rs.getString(26);
agend = rs.getString(27);
}
rs.close();
db.Close();
}
}
catch(Exception e)
{
afyp = "";
accafyp = "";
sfyp = "";
accsfyp = "";
agpn = "";
agaccpn = "";
agavgpc = "";
agactr = "";
actagp = "";
mgrpn = "";
mgraccpn = "";
mgravgpc = "";
mgractr = "";
actmgrp = "";
mpbegin = "";
mpend = "";
smbegin = "";
smend = "";
ma = "";
agbegin = "";
agend = "";
}
out.println("<?xml version=\"1.0\" encoding=\"gbk\"?>");
out.println("<result-set>");
out.println("<hoafyp name=\""+afyp+"\"/>");
out.println("<hoaccafyp name=\""+accafyp+"\"/>");
out.println("<hosfyp name=\""+sfyp+"\"/>");
out.println("<hoaccsfyp name=\""+accsfyp+"\"/>");
out.println("<hoagpn name=\""+agpn+"\"/>");
out.println("<hoagaccpn name=\""+agaccpn+"\"/>");
out.println("<hoagavgpc name=\""+agavgpc+"\"/>");
out.println("<hoagactr name=\""+agactr+"\"/>");
out.println("<hoactagp name=\""+actagp+"\"/>");
out.println("<homgrpn name=\""+mgrpn+"\"/>");
out.println("<homgraccpn name=\""+mgraccpn+"\"/>");
out.println("<homgravgpc name=\""+mgravgpc+"\"/>");
out.println("<homgractr name=\""+mgractr+"\"/>");
out.println("<hoactmgrp name=\""+actmgrp+"\"/>");
out.println("<hompbegin name=\""+mpbegin+"\"/>");
out.println("<hompend name=\""+mpend+"\"/>");
out.println("<hosmbegin name=\""+smbegin+"\"/>");
out.println("<hosmend name=\""+smend+"\"/>");
out.println("<homa name=\""+ma+"\"/>");
out.println("<hoagbegin name=\""+agbegin+"\"/>");
out.println("<hoagend name=\""+agend+"\"/>");
out.println("</result-set>");
}
}
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head><body>
<TABLE class="" style="LINE-HEIGHT: 16pt" cellSpacing=0 borderColorDark=#ffffff cellPadding=1
bgColor=#dff1ff borderColorLight=#88c4ff border=1 ?bordercolordark="ffffff" > <TBODY>
<TR vAlign=top>
<TD vAlign=center width=80><DIV align=center><FONT size=2>用户名</FONT></DIV></TD>
<TD vAlign=center width=80><DIV align=center><FONT size=2>性别</FONT></DIV></TD>
<TD vAlign=center width=80><DIV align=center><FONT size=2>年龄</FONT></DIV></TD>
</TR><%
Connection conn = null;
String url = null;
try{ Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver);
//db_name 你的数据库名
//user: 用户名
//password:你的数据库登陆密码
url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName="
+ db_name + ";User=" + user + ";Password=" + password;
conn = DriverManager.getConnection(url);
Statement stat=conn.createStatement();
String SQL="select * from tablename";);//tablename:数据表名
ResultSet rs=stat.executeQuery(SQL
while(rs.next()){
%> <TR vAlign=top>
<TD vAlign=center width=80><DIV align=center><FONT size=2><%= rs.getString("xingming") %></FONT></DIV></TD>
<TD vAlign=center width=80><DIV align=center><FONT size=2><%= rs.getString("xingbie") %></FONT></DIV></TD>
<TD vAlign=center width=80><DIV align=center><FONT size=2><%= rs.getString("nianling") %></FONT></DIV></TD>
</TR>
<%
}
} catch (ClassNotFoundException e2) {
e2.printStackTrace();
}catch(SQLException e){
System.out.println("url:"+url);
e.printStackTrace();
}
%>
</TBODY>
</TABLE>
</body>
</html>
Action里通过dao访问数据库,得到结果集转换成ArrayList对象。把ArrayList对象存到request里或session里。在页面使用logic:iterator标签或是使用c:forEach标签。循环显示ArrayList里的每条对象。