package com.tyj.dao.mysql;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.tyj.dao.OrderDao;
import com.tyj.domain.Order;

public abstract class OrderDaoImptyj implements OrderDao {
	
	@Override
	public List<Order> findAll() {
	
		String sql = "select orderid,userid,menuid,menusum,times,delivery from orders";

		List<Order> list = new ArrayList<Order>();
		// TODO Auto-generated method stub

		try (// 2.创建数据库链接
				Connection conn = DBHelper.getConnection();				// 3.创建语句对象
				PreparedStatement pstmt = conn.prepareStatement(sql);
				// 4.绑定参数
				// 5。执行查询
				ResultSet rs = pstmt.executeQuery();) {

			// 6.遍历结果集
			while (rs.next()) {
				Order order = new Order();
				order.setOrderid(rs.getLong("orderid"));
				order.setOrderdate(rs.getDate("times"));
				order.setUserid(rs.getString("userid"));

				list.add(order);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return list;
	}

	@Override
	public Order findById(String id) {
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public int create(Order order) {

		

		try (// 2.创建数据库链接
				Connection conn = DBHelper.getConnection();	
				// 3.创建语句对象
				PreparedStatement pstmt = conn.prepareStatement(
						"insert into orders (orderid,userid,menuid,menusum,times,delivery)"
						+ "values (?,?,?,?,?)")) {

			// 4.绑定参数
			pstmt.setLong(1, order.getOrderid());
			pstmt.setString(2, order.getUserid());
			// util date转换为sql date
			java.util.Date now = new java.util.Date();
			// java.sql.Date date = new java.sql.Date(now.getTime());
			// pstmt.setDate(3, date);
			// Timestamp比Date更精确
			java.sql.Timestamp date = new java.sql.Timestamp(now.getTime());
			pstmt.setTimestamp(3, date);
			pstmt.setInt(4, order.getMenusum());
			pstmt.setInt(5, order.getDelivery());

			// 5.执行查询
			int a = pstmt.executeUpdate();
			System.out.printf("成功插入%d数据。\n", a);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return 0;
	}

	@Override
	public int modify(Order order) {
		// TODO Auto-generated method stub
		return 0;
	}

	@Override
	public int remove(Order order) {
		// TODO Auto-generated method stub
		return 0;
	}
	

}