如何把它弄成带JAVABEAN的JSP ??(初学者)
hotsu 2003-08-29 08:06:48 初学者:帮忙把这两个页面改改带BEAN的JSP。
第一个JSP页面:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ include file="conn1.jsp" %>
<%
String username;
username=request.getParameter("keyword") ;
%>
<%
Statement stmt=conn.createStatement();
String sql="select * from txl where username like '%" + username + "%'";
ResultSet rs=stmt.executeQuery(sql);
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<table width="522" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="4" align="center"> <form name="form1" method="post" action="xshcl.jsp">
关键字搜索:
<input type="text" name="keyword" size="20">
<input type="submit" name="Submit" value="搜 索">
</form></td>
</tr>
<tr>
<td width="522" colspan="4" align="center"> </td>
</tr>
</table>
<p align="center"><font face="仿宋_GB2312">成员资料</font></p>
<form name="form2" method="post" action="">
<%
while(rs.next()){%>
<table width="522" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="522" colspan="4"> <font size="2"><img src="sysimages/j.gif" width="13" height="12" border="0">
<img border="0" src="sysimages/userlist.gif" width="16" height="16">姓名<font color="#000000">:</font><font size="2"><%=rs.getString("username")%></font></font></tr>
<tr>
<td width="11" rowspan="9" background="sysimages/line3.gif"><font size="2"> </font>
</td>
<td width="511" colspan="3"><font size="2"><img border="0" src="sysimages/-.gif"><img border="0" src="sysimages/born.gif" width="16" height="16">出生年月:<%=rs.getString("byear")%>
</font></td>
</tr>
<tr>
<td width="511" colspan="3"><font size="2"><img border="0" src="sysimages/-.gif"><img border="0" src="sysimages/email.gif" width="16" height="16">
<strong>QQ</strong>号码:<%=rs.getString("qq")%> </font></td>
</tr>
<tr>
<td colspan="3"><font size="2"><img border="0" src="sysimages/-.gif"><img border="0" src="sysimages/email.gif" width="16" height="16">电子邮件:<%=rs.getString("email")%>
</font></td>
</tr>
<tr>
<td width="511" colspan="3"><font size="2"><img border="0" src="sysimages/-.gif"><img border="0" src="sysimages/phone.gif" width="16" height="16">联系电话:<%=rs.getString("phone")%>
</font></td>
</tr>
<tr>
<td width="511" colspan="3"><font size="2"><img border="0" src="sysimages/-.gif"><img border="0" src="sysimages/mobile.gif" width="16" height="16">手机号码:<%=rs.getString("mobile")%>
</font></td>
</tr>
<tr>
<td width="511" colspan="3"><font size="2"><img border="0" src="sysimages/-.gif"><img border="0" src="sysimages/address.gif" width="14" height="15">联系地址:<%=rs.getString("address")%>
</font></td>
</tr>
<tr>
<td width="511" colspan="3"><font size="2"><img border="0" src="sysimages/-.gif"><img border="0" src="sysimages/12.gif" width="16" height="16">邮政编码:<%=rs.getString("zip")%>
</font></td>
</tr>
<tr>
<td width="511" colspan="3"><font size="2"><img border="0" src="sysimages/-.gif"><img border="0" src="sysimages/otherinfo.gif" width="15" height="16">其他信息:<%=rs.getString("otherinfo")%>
</font></td>
</tr>
<tr>
<td width="522" colspan="4"> </td>
</tr>
</table>
<%}
%>
</form>
<p> </p>
</body>
</html>
<%rs.close();
stmt.close();
conn.close();
%>
------------------------------------------------------------------
第二个JSP页面
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="conn1.jsp"%>
<% String username,qq,byear,email,phone,mobile,address,zip,otherinfo;
username=request.getParameter("username") ;
qq=request.getParameter("qq");
byear=request.getParameter("byear");
email=request.getParameter("email");
phone=request.getParameter("phone");
mobile=request.getParameter("mobile");
address=request.getParameter("address");
zip=request.getParameter("zip");
otherinfo=request.getParameter("otherinfo");
out.print(username);
Statement stmt=conn.createStatement();
String sql="insert into txl (username,qq,byear,email,phone,mobile,address,zip,otherinfo) values('" + username + "','" + qq + "','" + byear + "','" + email + "','" + phone + "','" + mobile + "','" + address + "','" + zip + "','" + otherinfo + "')";
stmt.executeUpdate(sql);
%>
<jsp:forward page="xsh.jsp"/>
<%
stmt.close();
conn.close();
%>