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">&nbsp;</td>
      </tr>
      <tr>
        <td>姓名:</td>
        <td></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>可用余额:</td>
        <td></td>
        <td>&nbsp;</td>
      </tr>
    </table>
    </body>
</html>