ordersearchdb.java

来自「JSP制作的一个在线书店 拥有简单的功能 请看看吧 初学者」· Java 代码 · 共 39 行

package ConnBean;

import bookadmin.*;
import common.*;
import java.sql.*;
import java.util.*;

public class orderSearchDB {
    ConnBean objConn = new ConnBean();
    Statement stmt = null;
    ResultSet rs = null;

    public orderSearchDB() {
        this.stmt = objConn.getStmt();
    }

    public Vector GetSelecte(String strsql) {
        orderSearch objOrderSearch = null;
        Vector v = new Vector();
        try{
            rs = this.stmt.executeQuery(strsql);
            while (rs.next()) {
                objOrderSearch = new orderSearch();
                objOrderSearch.setTradeNo(rs.getString(1) );
                objOrderSearch.setTradeDate(rs.getString(2) );
                objOrderSearch.setMemberuid(rs.getString(3) );
                objOrderSearch.setCountMoney(rs.getFloat(4) );
                objOrderSearch.setTradeCount(rs.getInt(5) );
                objOrderSearch.setBookNo(rs.getString(6) );
                v.add(objOrderSearch);
            }
            return v;
        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }
    }
}