作者longlyheart (longlyheart)
看板java
标题[JSP ] 请问如何将搜寻与javaBean共同使用??
时间Mon Apr 2 18:56:46 2007
小弟我写了一个搜寻网页，想要请问：
如何将写在网页里面的资料库移出来变成一个Bean??
以下是我的程式码：
<%@ page contentType = "text/html; charset=utf-8" %>
<%@ page language = "java" %>
<%@ page import = "java.sql.*" %>
<html>
<head>
<title>show</title>
</head>
<body>
<%
//宣告变数
int count = 0;
String error = null;
//设定资料库参数
String driver="com.mysql.jdbc.Driver";
String userName="帐号";
String password="密码";
String url="jdbc:mysql://localhost:3306/资料库名称";
//接收资料
String dbname = request.getParameter("dbname");
//SQL指令
String comSQL = "SELECT * FROM articledb WHERE articlename like'%"+dbname+"%';";
try{
Class.forName(driver);
Connection conn = DriverManager.getConnection(url,userName,password);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(comSQL);
while(rs.next()){
int sn = rs.getInt("articlesn");
String pi = rs.getString("picture");
String na = rs.getString("articlename");
String slink = "buytwo.jsp?iid="+sn;
count++;
out.println("<a href = " + slink + "><img src = " + pi + "></a><br>");
out.println("<a href = " + slink + ">" + na + "</a><br>");
}
rs.close();
stmt.close();
conn.close();
}
catch(SQLException se){
error = se.toString();
}
catch(Exception e){
error = e.toString();
}
if(count==0){
out.println("非常抱歉，我们没有您所需要的商品。");
}
%>
</body>
大约就是以上try里面的东西，希望可以改成由Bean汇入
但是Bean不支援System.out.println这种东西....
所以写了几个Bean都没办法达到同样的效果，请各位大大指导>"<
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 59.120.96.194