torderdao.java

jsp网页

			stmt.setInt(8, order.getStatus());

			result = stmt.executeUpdate();
			conn.commit();
		} catch (Exception e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
		} finally {
			try {
				stmt.close();
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}

		return result;
	}
	
	public List getHistoryOrder() {
		return getStatusOrder(Global.ORDER_STATUS_OUT);
	}
	
	public List getCurrentOrder() {
		List list = new ArrayList();

		String sqlStr = "select * from t_order where status!=" + Global.ORDER_STATUS_OUT + " order by id";
		Connection conn = DbUtil.getConnection();
		PreparedStatement stmt = null;
		ResultSet rs = null;
		try {
			stmt = conn.prepareStatement(sqlStr);
			conn.setAutoCommit(false);
			rs = stmt.executeQuery();
			conn.commit();

			/* 遍历将rs中的结果插入list中返回 */
			if (rs != null) {
				TOrder order = null;
				while (rs.next()) {
					order = new TOrder();
					order.setId(rs.getInt("id"));
					order.setCategory(rs.getInt("category"));
					order.setInput_time(rs.getDate("input_time"));
					order.setInput_user(rs.getInt("input_user"));
					order.setLast_time(rs.getDate("last_time"));
					order.setName(rs.getString("name"));
					order.setNumber(rs.getInt("number"));
					order.setRemark(rs.getString("remark"));
					order.setStatus(rs.getInt("status"));
					list.add(order);
				}
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				rs.close();
				stmt.close();
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return list;
	}
	
	public void setStatus(int id,int status) {
		String sqlStr = "update t_order set status=" + status + " where id=" + id;
		Connection conn = DbUtil.getConnection();
		PreparedStatement stmt = null;
		
		try {
			stmt = conn.prepareStatement(sqlStr);
			conn.setAutoCommit(false);
			stmt.executeUpdate();
			conn.commit();
		 
	    } catch (SQLException e) {
		// TODO Auto-generated catch block
	    	e.printStackTrace();
	    } finally {
		try {
			stmt.close();
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	}
	
	public List searchByIDForCurrent(int id){
		List list = new ArrayList();

		String sqlStr = "select * from t_order where id =" + id + " and status!=" + Global.ORDER_STATUS_OUT;
		Connection conn = DbUtil.getConnection();
		PreparedStatement stmt = null;
		ResultSet rs = null;
		try {
			stmt = conn.prepareStatement(sqlStr);
			conn.setAutoCommit(false);
			rs = stmt.executeQuery();
			conn.commit();

			/* 遍历将rs中的结果插入list中返回 */
			if (rs != null) {
				TOrder order = null;
				while (rs.next()) {
					order = new TOrder();
					order.setId(rs.getInt("id"));
					order.setCategory(rs.getInt("category"));
					order.setInput_time(rs.getDate("input_time"));
					order.setInput_user(rs.getInt("input_user"));
					order.setLast_time(rs.getDate("last_time"));
					order.setName(rs.getString("name"));
					order.setNumber(rs.getInt("number"));
					order.setRemark(rs.getString("remark"));
					order.setStatus(rs.getInt("status"));
					list.add(order);
				}
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				rs.close();
				stmt.close();
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return list;
	}
	
	public List searchByIDForHistory(int id){
		List list = new ArrayList();

		String sqlStr = "select * from t_order where id =" + id + " and status=" + Global.ORDER_STATUS_OUT;
		Connection conn = DbUtil.getConnection();
		PreparedStatement stmt = null;
		ResultSet rs = null;
		try {
			stmt = conn.prepareStatement(sqlStr);
			conn.setAutoCommit(false);
			rs = stmt.executeQuery();
			conn.commit();

			/* 遍历将rs中的结果插入list中返回 */
			if (rs != null) {
				TOrder order = null;
				while (rs.next()) {
					order = new TOrder();
					order.setId(rs.getInt("id"));
					order.setCategory(rs.getInt("category"));
					order.setInput_time(rs.getDate("input_time"));
					order.setInput_user(rs.getInt("input_user"));
					order.setLast_time(rs.getDate("last_time"));
					order.setName(rs.getString("name"));
					order.setNumber(rs.getInt("number"));
					order.setRemark(rs.getString("remark"));
					order.setStatus(rs.getInt("status"));
					list.add(order);
				}
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				rs.close();
				stmt.close();
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return list;
	}
	
	public List searchByNameForCurrent(String name){
		List list = new ArrayList();

		String sqlStr = "select * from t_order where name like '%" + name + "%' and status!=" + Global.ORDER_STATUS_OUT ;
		Connection conn = DbUtil.getConnection();
		PreparedStatement stmt = null;
		ResultSet rs = null;
		try {
			stmt = conn.prepareStatement(sqlStr);
			conn.setAutoCommit(false);
			rs = stmt.executeQuery();
			conn.commit();

			/* 遍历将rs中的结果插入list中返回 */
			if (rs != null) {
				TOrder order = null;
				while (rs.next()) {
					order = new TOrder();
					order.setId(rs.getInt("id"));
					order.setCategory(rs.getInt("category"));
					order.setInput_time(rs.getDate("input_time"));
					order.setInput_user(rs.getInt("input_user"));
					order.setLast_time(rs.getDate("last_time"));
					order.setName(rs.getString("name"));
					order.setNumber(rs.getInt("number"));
					order.setRemark(rs.getString("remark"));
					order.setStatus(rs.getInt("status"));
					list.add(order);
				}
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				rs.close();
				stmt.close();
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return list;
	}
	
	public List searchByNameForHistory(String name){
		List list = new ArrayList();

		String sqlStr = "select * from t_order where name like '%" + name + "%' and status=" + Global.ORDER_STATUS_OUT ;
		Connection conn = DbUtil.getConnection();
		PreparedStatement stmt = null;
		ResultSet rs = null;
		try {
			stmt = conn.prepareStatement(sqlStr);
			conn.setAutoCommit(false);
			rs = stmt.executeQuery();
			conn.commit();

			/* 遍历将rs中的结果插入list中返回 */
			if (rs != null) {
				TOrder order = null;
				while (rs.next()) {
					order = new TOrder();
					order.setId(rs.getInt("id"));
					order.setCategory(rs.getInt("category"));
					order.setInput_time(rs.getDate("input_time"));
					order.setInput_user(rs.getInt("input_user"));
					order.setLast_time(rs.getDate("last_time"));
					order.setName(rs.getString("name"));
					order.setNumber(rs.getInt("number"));
					order.setRemark(rs.getString("remark"));
					order.setStatus(rs.getInt("status"));
					list.add(order);
				}
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				rs.close();
				stmt.close();
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return list;
	}
	
	public static void main(String args[]) {
		String str = "纵纹";

		TOrder order = new TOrder();
		order.setCategory(1);
		order.setInput_time(new Date());
		order.setInput_user(1);
		order.setLast_time(new Date());
		try {
			order.setName(new String(str.getBytes("gbk"), "utf-8"));
		} catch (UnsupportedEncodingException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		order.setNumber(2);
		order.setRemark("read");
		order.setStatus(2);
		new TOrderDAO().insert(order);
		System.out.println("success");
	}
}