<%--
Document
: index
Created on : 2010-3-6, 22:25:14
Author
: linyan
--%>
<%@page contentType="text/html" pageEncoding="gbk"%>
<%@page language="java" import="java.util.*"%>
<%@page import="java.sql.*"%>
<%@page import="myjsp.Select"%>
<jsp:useBean id="xxx" scope="session" class="myjsp.Conn"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.
<html>
<head>
<title>bb1.html</title>
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="this is my page">
<meta http-equiv="content-type" content="text/html; charset=gbk">
<!--<link rel="stylesheet" type="text/css" href="./styles.css">-->
</head>
<body>
<%
Select conn1=new Select();
String id=request.getParameter("id");
String lie=request.getParameter("lie");
String tableid=request.getParameter("tableid");
String strSql1="select * from "+id+" where "+lie+"="+tableid+"";
ResultSet rs1=conn1.doQuery(strSql1);
%>
<%
Select conn=new Select();
String strid=request.getParameter("id");
String strSql="select * from "+strid+"";
ResultSet rs=conn.doQuery(strSql);
%>
<%
String[] AllData=conn.DB2(rs);
ResultSetMetaData rsmd = rs.getMetaData();
int aa=rsmd.getColumnCount();%>
<%
String request_page_s=request.getParameter("page");
int request_page;
//当前页
int pageSize=10;
try{
if(request_page_s.length()==0)
request_page=1;
else
request_page=Integer.parseInt(request_page_s);
}
catch(Exception e)
{
request_page=1;
}
Vector vector=xxx.getResult(pageSize,request_page,"select * from "+id+"");
%>
<center>
<form id="form1" name="form1" method="post" action="update2.jsp?tableid=<%=tableid%>&lie=<%=lie%>&id=<%=id%>">//传递参数
<tr>
<%for(int hh=0;hh<aa;hh++){%>
<%while(rs1.next()){%>
<%for(int q=0;q<aa;q++){%>
<p><%=AllData[hh] %><input type="text" name="<%=AllData[hh++] %>" value="<%=rs1.getString(q+1)%>"/></p>
<%}%>
<%}%>
<%}%>
</tr>
qq<input type="text" name="tian" value=""/>//测试固定值用
<input type="submit" name="Submit" value="确定" />
</form>
</center>
</body>
</html>
这个是我要修改的界面。