You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
103 lines
2.4 KiB
103 lines
2.4 KiB
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;
|
|
}
|
|
|
|
|
|
}
|