如何把它弄成带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();
%>

...全文
25 5 打赏 收藏 转发到动态 举报
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
aku0708 2003-08-29
  • 打赏
  • 举报
回复
up
caomiao123 2003-08-29
  • 打赏
  • 举报
回复
把你在jsp里的代码归纳好写成类,写好药用的函数
jsp里直接用useBean调用着各类就行了
跟在java里import了一个包差不多
joincsdn 2003-08-29
  • 打赏
  • 举报
回复
zj2977(大地) 说得已经构详细了,其实就是封装对数据库的操作,另外可以加一些set或者get方法,使bean更加好用,功能更多
zj2977 2003-08-29
  • 打赏
  • 举报
回复
其实就是数据库的bean,给你个例子
package manager;
import java.sql.* ;
import java.util.*;
public class DBConnect
{
private String sdbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
private String sdbUrl = "jdbc:odbc:storage";
private String sdbUsername = "sa";//用户名
private String sdbPassword = "admin";//口令
public Statement stmt;
public Connection conn = null;
ResultSet rs=null;
public DBConnect() throws ClassNotFoundException,SQLException{
try {
Class.forName(sdbDriver);//加载JDBC-ODBC驱动程序
conn=DriverManager.getConnection(sdbUrl,sdbUsername,sdbPassword);
//与本地ODBC数据源permission建立连接,sdbUsername,sdbPassword是用户名与口令
}
catch(Exception e){//捕捉错误
System.out.print("Exception occur. Message is:"+e.getMessage());
}
}

public Connection getConn()
{
//getConn()返回Connection对象
System.out.println("数据库连接成功");
return(conn);
}
public ResultSet executeQuery(String sql)
{//执行SQL语句
rs = null;
try {
stmt = conn.createStatement();//创建语句对象
rs = stmt.executeQuery(sql);//执行SQL语句
System.out.println("rs返回成功");
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
System.err.println("aq.executeQuerystrSQL: " + sql);
}
return rs;//返回结果集
}
public void executeUpdate(String sql) {//执行SQL语句
try {
stmt = conn.createStatement();//创建语句对象
stmt.executeUpdate(sql);//执行SQL语句
}
catch(SQLException ex) {
System.err.println("aq.executeUpdate: " + ex.getMessage());
System.err.println("aq.executeUpadatestrSQL: " + sql);
}
}
/**
* 关闭数据库连接
*/
public void destroy()
{
try
{
stmt.close();//关闭语句对象
conn.close();//关闭数据库连接
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
hotsu 2003-08-29
  • 打赏
  • 举报
回复
CONN1.jsp的代码如下:

<%@ page import="java.sql.*"%>

<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=111";
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
%>

81,090

社区成员

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧