orderdao.java

这是一个网上基于JAVA的订餐系统

package s2jsp.lg.Dao;

import java.util.List;
import java.util.ArrayList;
import java.sql.Date;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.*;

import s2jsp.lg.entity.*;

public class OrderDao {

	// 返回全部订单
	public List allOrderFormShow(int userid) {
		List list = new ArrayList();
		Connection con = null;
		PreparedStatement pStatement = null;
		ResultSet rSet = null;
		try {
			con = new BaseDao().getConn();
			String sql = "select * from orderform where userid="+userid+" order by eattime";
			pStatement = con.prepareStatement(sql);
			rSet = pStatement.executeQuery();
			while (rSet.next()) {
				Orderform orderform = new Orderform();
				orderform.setId(rSet.getInt("id"));
				orderform.setUserid(rSet.getInt("userid"));
				orderform.setEattime(rSet.getDate("eattime"));
				orderform.setEatperson(rSet.getInt("eatperson"));
				orderform.setIsaction(rSet.getInt("isaction"));
				orderform.setActioncontent(rSet.getString("actioncontent"));
				list.add(orderform);
			}

		} catch (Exception e) {
			e.getStackTrace();

		} finally {
			new BaseDao().closeAll(rSet, pStatement, con);
		}

		return list;
	}

	// 返回未处理订单
	public List isNotActionOrderFormShow() {
		List list = new ArrayList();
		Connection con = null;
		PreparedStatement pStatement = null;
		ResultSet rSet = null;
		try {
			con = new BaseDao().getConn();
			String sql = "select * from orderform where isaction=0 order by eattime";
			pStatement = con.prepareStatement(sql);
			rSet = pStatement.executeQuery();
			while (rSet.next()) {	
				Orderform orderform = new Orderform();
				orderform.setId(rSet.getInt("id"));
				orderform.setUserid(rSet.getInt("userid"));
				orderform.setEattime(rSet.getDate("eattime"));
				orderform.setEatperson(rSet.getInt("eatperson"));
				orderform.setIsaction(rSet.getInt("isaction"));
				orderform.setActioncontent(rSet.getString("actioncontent"));
				list.add(orderform);
			}

		} catch (Exception e) {
			e.getStackTrace();

		} finally {
			new BaseDao().closeAll(rSet, pStatement, con);
		}

		return list;

	}

	// 录入新订单
	public int insertOrderForm(int userid, int eatperson,String eattime) {
		Connection con = null;
		PreparedStatement pStatement = null;
		int a = 0;
		try {
			con = new BaseDao().getConn();
			String sql = "insert into orderform (userid,eattime,eatperson) values(?,?,?)";
			pStatement = con.prepareStatement(sql);
			pStatement.setInt(1, userid);
			pStatement.setString(2, eattime);
			pStatement.setInt(3, eatperson);
			a = pStatement.executeUpdate();
		} catch (SQLException e) {
			e.getStackTrace();

		} finally {
			new BaseDao().closeAll(null, pStatement, con);
		}

		return a;

	}
	
	//删除订单
	public int deleteOrderForm(int id) {
		Connection con = null;
		PreparedStatement pStatement = null;
		int a = 0;
		try {
			con = new BaseDao().getConn();
			String sql = "delete orderform where id=?";
			pStatement = con.prepareStatement(sql);
			pStatement.setInt(1, id);
			a = pStatement.executeUpdate();
		} catch (SQLException e) {
			e.getStackTrace();

		} finally {
			new BaseDao().closeAll(null, pStatement, con);
		}

		return a;

	}
	
	//处理订单
	public int updateOrderForm(String actioncontent,int id) {
		Connection con = null;
		PreparedStatement pStatement = null;
		int a = 0;
		try {
			con = new BaseDao().getConn();
			String sql = "update orderform set isaction=1,actioncontent=? where id=?";
			pStatement = con.prepareStatement(sql);
			pStatement.setString(1, actioncontent);
			pStatement.setInt(2, id);
			a = pStatement.executeUpdate();
		} catch (SQLException e) {
			e.getStackTrace();

		} finally {
			new BaseDao().closeAll(null, pStatement, con);
		}

		return a;

	}
	

}