tradedb.java

JSP制作的一个在线书店 拥有简单的功能 请看看吧 初学者

package ConnBean;

import java.sql.*;
import ConnBean.ConnBean;
import common.tradeBean;

public class TradeDB {
    ConnBean con = new ConnBean();
    Statement stmt = null;
    public TradeDB() {
        this.stmt = con.getStmt() ;
    }

    public boolean InsertDB(tradeBean objTdb) {
        try {
            String strSqlI ="insert into Trade values ('" + objTdb.getTradeNO() +
                            "','" + objTdb.getMemberUid() + "','" +
                            objTdb.getTradeDate() + "','" +
                            objTdb.getCountMoney() + ")";
            System.out.println(strSqlI);
            int value = this.stmt.executeUpdate(strSqlI);
            if (value ==1) {
                return true;
            } else {
                return false;
            }
        } catch (Exception ex) {
            ex.printStackTrace();
            return false;
        }
    }
}