您所在位置：主题：菜鸟请教如何用jsp调用bean并显示数据.谢谢.
monkcat
[专家分：0] 发布于 2007-09-29 11:24:00
package DB;
import java.sql.*;
public class db {
private Connection conn;
private Statement stmt;
private ResultSet rs;
private void preparedDriver() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
}
public Connection getConn() {
this.preparedDriver();
try {
conn = DriverManager.getConnection(
"jdbc:odbc:test","","");
}
catch (SQLException ex) {
ex.printStackTrace();
}
return conn;
}
public void closeAll() {
try {
if (rs != null) {
rs.close();
rs = null;
}
if (stmt != null) {
stmt.close();
stmt = null;
}
if (conn != null) {
conn.close();
conn = null;
}
}
catch (Exception ex) {
ex.printStackTrace();
}
}
public db() {
}
}
接着是用bean的内容:
package run;
public class test {
private String name=null;
private int age=0;
public test() {
}
public void setName(String name) {
this.name = name;
}
public void setAge(int age) {
this.age = age;
}
public String getName() {
return name;
}
public int getAge() {
return age;
}
}
然后是servlert调用数据库并查询相关值:
package DB;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import run.test;
import DB.db.*;
public class SeachSevlet extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";
//Initialize global variables
public void init() throws ServletException {
}
//Process the HTTP Get request
public void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
db sql=new db();
try {
conn = sql.getConn();
stmt = conn.createStatement();
rs=stmt.executeQuery("select * from table");
while(rs.next()){
test bean=new test();
bean.setName(rs.getString(1));
bean.setAge(rs.getInt(2));
}
} catch (SQLException ex) {
ex.printStackTrace();
}
sql.closeAll();
out.close();
}
//Process the HTTP Post request
public void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
doGet(request, response);
}
//Clean up resources
public void destroy() {
}
}
最后是jsp调用bean的内容显示相关数据:
<%@ page contentType="text/html; charset=GBK" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<html>
<head>
<title>
GetMsg
</title>
</head>
<body bgcolor="#ffffff">
<table width="782" border="1" align="center" bgcolor="#0099FF">
<tr>
<td><div align="center">姓 名</div>
<td><div align="center">年龄</div>
</tr>
<c:forEach var="list" items="${requestScope.test}">
<tr>
<td width="224"><div align="center"> ${list.name}</div></td>
<td width="139"><div align="center">${list.age}</div></td>
</tr></c:forEach>
</table>
<br>
<br>
</body>
</html>
import java.sql.*;
public class db {
private Connection conn;
private Statement stmt;
private ResultSet rs;
private void preparedDriver() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
}
public Connection getConn() {
this.preparedDriver();
try {
conn = DriverManager.getConnection(
"jdbc:odbc:test","","");
}
catch (SQLException ex) {
ex.printStackTrace();
}
return conn;
}
public void closeAll() {
try {
if (rs != null) {
rs.close();
rs = null;
}
if (stmt != null) {
stmt.close();
stmt = null;
}
if (conn != null) {
conn.close();
conn = null;
}
}
catch (Exception ex) {
ex.printStackTrace();
}
}
public db() {
}
}
接着是用bean的内容:
package run;
public class test {
private String name=null;
private int age=0;
public test() {
}
public void setName(String name) {
this.name = name;
}
public void setAge(int age) {
this.age = age;
}
public String getName() {
return name;
}
public int getAge() {
return age;
}
}
然后是servlert调用数据库并查询相关值:
package DB;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import run.test;
import DB.db.*;
public class SeachSevlet extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";
//Initialize global variables
public void init() throws ServletException {
}
//Process the HTTP Get request
public void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
db sql=new db();
try {
conn = sql.getConn();
stmt = conn.createStatement();
rs=stmt.executeQuery("select * from table");
while(rs.next()){
test bean=new test();
bean.setName(rs.getString(1));
bean.setAge(rs.getInt(2));
}
} catch (SQLException ex) {
ex.printStackTrace();
}
sql.closeAll();
out.close();
}
//Process the HTTP Post request
public void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
doGet(request, response);
}
//Clean up resources
public void destroy() {
}
}
最后是jsp调用bean的内容显示相关数据:
<%@ page contentType="text/html; charset=GBK" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<html>
<head>
<title>
GetMsg
</title>
</head>
<body bgcolor="#ffffff">
<table width="782" border="1" align="center" bgcolor="#0099FF">
<tr>
<td><div align="center">姓 名</div>
<td><div align="center">年龄</div>
</tr>
<c:forEach var="list" items="${requestScope.test}">
<tr>
<td width="224"><div align="center"> ${list.name}</div></td>
<td width="139"><div align="center">${list.age}</div></td>
</tr></c:forEach>
</table>
<br>
<br>
</body>
</html>