src/com/accp/myShopping/wjj/dao/order_processingdao.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.accp.myShopping.wjj.dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.accp.myShopping.util.DataBaseUtil;
import com.accp.myShopping.wjj.entity.order_processingBean;
public class order_processingdao {
	ResultSet rSet=null;
	DataBaseUtil db=new DataBaseUtil();
	List list=new ArrayList();
	
	public static void main(String[] args) {
		order_processingdao daOrder_processingdao=new order_processingdao();
		int count=daOrder_processingdao.updateorde(0,"hy2010012115028578");
		System.out.println(count);
	}
	
	/*
	  * 查询通用
	  * **/
     public List<order_processingBean> select(String sql,Object... parmars){
   	  
   	  try {
   		  rSet=db.getResultSet(sql,parmars);
   		  while (rSet.next()) {
   			    
				 String O_ID=rSet.getString(1);
				 
				 String U_Name=rSet.getString(2);
				 int T_payType=rSet.getInt(3);
				 int T_sentType=rSet.getInt(4);
				 Date O_startTime=rSet.getDate(5);
				 Date O_endTime=rSet.getDate(6);
				 double O_GoodsPrice=rSet.getDouble(7);
				 int O_state=rSet.getInt(8);
	
				 order_processingBean oder=new order_processingBean(O_ID,U_Name,T_payType,T_sentType,O_startTime
						 ,O_endTime,O_GoodsPrice,O_state);
				 list.add(oder);
			}
   		  
		} catch (SQLException e) {
			   System.out.println("SQL语句错误");
		}
		catch (Exception e) {
			System.out.println("未知错误");
		    e.printStackTrace();
		}finally{
			
			db.release(rSet);
		}
		return list;
   	  
     }
     
     /*
      * 查询所有