selldao.java~6~

这是一个用Struts做出来的网上商城的源代码

package com.dao;
import com.tool.JDBConnection;
import com.tool.FinalConstants;
import java.sql.*;
import java.util.*;
import com.domain.SmallTypeForm;

//会员购货
public class SellDao {
  private Connection connection = null; //定义连接的对象
  private PreparedStatement ps = null; //定义预准备的对象
  private JDBConnection jdbc = null; //定义数据库连接对象
  public SellDao() {
    jdbc = new JDBConnection();
    connection = jdbc.connection; //利用构造方法取得数据库连接
  }

 //以会员的编号和订货为条件删除信息
public boolean deleteSell(Integer memberId,int sign){
  try {
    ps = connection.prepareStatement(FinalConstants.sell_delete);
     ps.setInt(1,memberId.intValue());
     ps.setInt(2,sign);
     ps.executeUpdate();
     ps.close();
     return true;
  }
  catch (SQLException ex) {
   return false;
  }
}

}