cardinfobean.java
package com.card;
import java.security.Principal;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Enumeration;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import org.omg.CORBA.Request;
public class CardinfoBean {
Connection con;
public CardinfoBean(){
this.con=(new DB()).getConnection();}
/** Creates a new instance of CardinfoBean */
public void getCardinfo(String cardname)throws Exception{
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery("select * from cardinfo where cardname='"+cardname+"'");
while(rs.next()){
}
rs.close();
stmt.close();
con.close();
}
}
cardinfo.jsp
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@ taglib uri="/WEB-INF/Struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/Struts-html.tld" prefix="html" %>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<jsp:useBean id="CardinfoBean" scope="request" class="com.card.CardinfoBean">
<jsp:setProperty name="CardingfoBean" property="*"/>
</jsp:useBean>
<html >
<head >
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body >
<table width="280" border="0">
<tr>
<td width="155">卡号:</td>
<td width="50"></td>
<td width="61"> </td>
</tr>
<tr>
<td>姓名:</td>
<td></td>
<td> </td>
</tr>
<tr>
<td>可用余额:</td>
<td></td>
<td> </td>
</tr>
</table>
</body>
</html>
package com.card;
import java.security.Principal;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Enumeration;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import org.omg.CORBA.Request;
public class CardinfoBean {
Connection con;
public CardinfoBean(){
this.con=(new DB()).getConnection();}
/** Creates a new instance of CardinfoBean */
public void getCardinfo(String cardname)throws Exception{
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery("select * from cardinfo where cardname='"+cardname+"'");
while(rs.next()){
}
rs.close();
stmt.close();
con.close();
}
}
cardinfo.jsp
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@ taglib uri="/WEB-INF/Struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/Struts-html.tld" prefix="html" %>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<jsp:useBean id="CardinfoBean" scope="request" class="com.card.CardinfoBean">
<jsp:setProperty name="CardingfoBean" property="*"/>
</jsp:useBean>
<html >
<head >
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body >
<table width="280" border="0">
<tr>
<td width="155">卡号:</td>
<td width="50"></td>
<td width="61"> </td>
</tr>
<tr>
<td>姓名:</td>
<td></td>
<td> </td>
</tr>
<tr>
<td>可用余额:</td>
<td></td>
<td> </td>
</tr>
</table>
</body>
</html>
cardinfo.jsp中的数据怎么显示出来?