package com.lee.model;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import com.lee.net.DbConn;
import com.lee.view.OrderVo;
import com.lee.view.SellView;
public class OrderModel {
public void insertOrder(OrderVo ov){
PreparedStatement ps=null;
String sql="insert into orders(order_discount,order_table," +
"order_count,order_cost,order_start,order_end) values(?,?,?,?,?,?)";
try {
ps=DbConn.getConn().prepareStatement(sql);
ps.setDouble(1,ov.getDiscount());
ps.setInt(2,ov.getTable());
ps.setInt(3, ov.getCount());
ps.setDouble(4, ov.getCost());
ps.setTimestamp(5,new Timestamp(ov.getStart().getTime()));
ps.setTimestamp(6,new Timestamp(ov.getEnd().getTime()));
ps.execute();
} catch (SQLException e) {
e.printStackTrace();
}
finally{
closeTool(ps);
}
}
public void deleteOrder(int id){
PreparedStatement ps=null;
String sql="delete from orders where order_id=?";
try {
ps=DbConn.getConn().prepareStatement(sql);
ps.setInt(1, id);
ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally{
closeTool(ps);
}
}
/*
* 不允许改账单的时间
*/
public void updateOrder(OrderVo ov){
PreparedStatement ps=null;
String sql="update orders set order_discount=?,order_table=?,order_count=?,order_cost=?," +
"order_end=? where order_id=?";
try {
ps=DbConn.getConn().prepareStatement(sql);
ps.setDouble(1, ov.getDiscount());
ps.setInt(2, ov.getTable());
ps.setInt(3, ov.getCount());
ps.setDouble(4, ov.getCost());
ps.setTimestamp(5,new Timestamp(ov.getEnd().getTime()));
ps.setInt(6, ov.getId());
ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally{
closeTool(ps);
}
}
public List<OrderVo> selectOrders(){
List<OrderVo> li=new ArrayList<OrderVo>();
PreparedStatement ps=null;
String sql="select order_id ,order_discount,order_table,order_count," +
"order_cost,order_start,order_end from orders";
ResultSet rs=null;
try {
ps=DbConn.getConn().prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next()){
OrderVo ov=new OrderVo();
ov.setId(rs.getInt(1));
ov.setDiscount(rs.getDouble(2));
ov.setTable(rs.getInt(3));
ov.setCount(rs.getInt(4));
ov.setCost(rs.getDouble(5));
ov.setStart(rs.getTimestamp(6));
ov.setEnd(rs.getTimestamp(7));
li.add(ov);
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
rs.close();
closeTool(ps);
} catch (SQLException e) {
e.printStackTrace();
}
}
return li;
}
public OrderVo selectOneOrder(int id){
OrderVo ov=new OrderVo();
PreparedStatement ps=null;
String sql="select order_discount,order_table,order_count," +
"order_cost,order_start,order_end from orders where order_id=?";
ResultSet rs=null;
try {
ps=DbConn.getConn().prepareStatement(sql);
ps.setInt(1, id);
rs=ps.executeQuery();
while(rs.next()){
ov.setId(id);
ov.setDiscount(rs.getDouble(1));
ov.setTable(rs.getInt(2));
ov.setCount(rs.getInt(3));
ov.setCost(rs.getDouble(4));
ov.setStart(rs.getTimestamp(5));
ov.setEnd(rs.getTimestamp(6));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
closeTool(ps);
}
return ov;
}
public OrderVo selectOrderByTid(int tid){
OrderVo ov=new OrderVo();
PreparedStatement ps=null;
String sql="select order_id,order_discount,order_table,order_count," +
"order_cost,order_start,order_end from orders where order_table=?";
ResultSet rs=null;
try {
ps=DbConn.getConn().prepareStatement(sql);
ps.setInt(1, tid);
rs=ps.executeQuery();
while(rs.next()){
ov.setId(rs.getInt(1));
ov.setDiscount(rs.getDouble(2));
ov.setTable(rs.getInt(3));
ov.setCount(rs.getInt(4));
ov.setCost(rs.getDouble(5));
ov.setStart(rs.getTimestamp(6));
ov.setEnd(rs.getTimestamp(7));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
closeTool(ps);
}
return ov;
}
public SellView selectByTime(String dateStart,String dateEnd){
SellView sv=new SellView();
String sql="select count(order_id),sum(order_count),sum(order_cost) " +
"from orders where order_start between '"+dateStart+ "' and '"+dateEnd+"'";
Statement sm=null;
ResultSet rs=null;
try {
sm=DbConn.getConn().createStatement();
rs=sm.executeQuery(sql);
while(rs.next()){
sv.setIdCount(rs.getInt(1));
sv.setPeopleSum(rs.getInt(2));
sv.setCostSum(rs.getDouble(3));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
rs.close();
sm.close();
DbConn.closeConn();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return sv;
}
//不了解什么原因不好使
public SellView FallselectByTime(String dateStart,String dateEnd){
SellView sv=new SellView();
String sql="select count(order_id),sum(order_count),sum(order_cost) " +
"from orders where order_start between ? and ?";
PreparedStatement ps=null;
ResultSet rs=null;
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
long ds=0;
long de=0;
try {
ds=sdf.parse(dateStart).getTime();
de=sdf.parse(dateEnd).getTime();
} catch (ParseException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
try {
ps=DbConn.getConn().prepareStatement(sql);
// ps.setTimestamp(1, new Timestamp(ds));
// ps.setTimestamp(2, new Timestamp(de));
ps.setDate(1, new java.sql.Date(ds));
ps.setDate(2, new java.sql.Date(de));
rs=ps.executeQuery();
while(rs.next()){
sv.setIdCount(rs.getInt(1));
sv.setPeopleSum(rs.getInt(2));
sv.setCostSum(rs.getDouble(3));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
rs.close();
closeTool(ps);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return sv;
}
public void closeTool(PreparedStatement ps){
try {
ps.close();
DbConn.closeConn();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
String dates="2016-3-10";
String datee="2016-5-1";
SellView sv=new SellView();
sv=new OrderModel().selectByTime(dates, datee);
System.out.println(sv.getCostSum()+","+sv.getIdCount()+","+sv.getPeopleSum());
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
基于Java的饭店管理系统(亮点是用余弦相似度算法写了个推荐菜的功能,含数据库文件).zip
共95个文件
java:16个
class:16个
png:14个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
5星 · 超过95%的资源 2 下载量 179 浏览量
2023-04-10
15:59:22
上传
评论
收藏 1.42MB ZIP 举报
温馨提示
基于Java的饭店管理系统(亮点是用余弦相似度算法写了个推荐菜的功能,含数据库文件).zip 基于Java 含数据库文件
资源推荐
资源详情
资源评论
收起资源包目录
基于Java的饭店管理系统(亮点是用余弦相似度算法写了个推荐菜的功能,含数据库文件).zip (95个子文件)
GraduationProject-master
.classpath 618B
.settings
org.eclipse.wst.jsdt.ui.superType.name 6B
org.eclipse.jdt.core.prefs 357B
org.eclipse.core.resources.prefs 65B
.jsdtscope 488B
com.genuitec.eclipse.core.prefs 71B
org.eclipse.wst.common.component 459B
org.eclipse.wst.common.project.facet.core.xml 245B
org.eclipse.wst.jsdt.ui.superType.container 49B
.mymetadata 296B
src
com
lee
ctrl
TableCtrl.java 4KB
WorkerCtrl.java 4KB
OrderCtrl.java 2KB
CustomerCtrl.java 4KB
net
DbConn.java 712B
view
TableVo.java 537B
WorkerVo.java 1KB
SellView.java 488B
ProductVo.java 653B
OrderVo.java 969B
CustomerVo.java 794B
model
OrderModel.java 7KB
CustomerModel.java 6KB
TableModel.java 4KB
WorkerModel.java 5KB
ProductModel.java 3KB
restaurant.sql 6KB
WebRoot
orderlist.jsp 6KB
insertshow.jsp 7KB
WEB-INF
classes
com
lee
ctrl
CustomerCtrl.class 4KB
TableCtrl.class 4KB
OrderCtrl.class 2KB
WorkerCtrl.class 4KB
net
DbConn.class 1KB
view
TableVo.class 1KB
WorkerVo.class 2KB
OrderVo.class 2KB
ProductVo.class 1KB
SellView.class 888B
CustomerVo.class 1KB
model
OrderModel.class 9KB
TableModel.class 5KB
WorkerModel.class 6KB
CustomerModel.class 7KB
ProductModel.class 5KB
lib
mysql-connector-java-3.2.0-alpha-bin.jar 394KB
web.xml 2KB
index.jsp 23KB
assets
js
amazeui.js 452KB
amazeui.ie8polyfill.js 111KB
app.js 372B
handlebars.min.js 71KB
amazeui.min.js 204KB
amazeui.ie8polyfill.min.js 35KB
amazeui.widgets.helper.min.js 33KB
amazeui.widgets.helper.js 34KB
jquery.min.js 84KB
i
startup-640x1096.png 9KB
examples
landingPage.png 2KB
blogPage.png 3KB
admin-firefox.png 4KB
admin-chrome.png 4KB
loginPage.png 2KB
admin-opera.png 4KB
sidebarPage.png 2KB
adminPage.png 3KB
admin-safari.png 4KB
admin-ie.png 4KB
landing.png 4KB
favicon.png 1024B
css
admin.css 5KB
amazeui.flat.min.css 242KB
amazeui.min.css 241KB
amazeui.flat.css 322KB
amazeui.css 321KB
app.css 23B
fonts
FontAwesome.otf 107KB
fontawesome-webfont.eot 69KB
fontawesome-webfont.woff 82KB
fontawesome-webfont.woff2 65KB
fontawesome-webfont.svg 357KB
fontawesome-webfont.ttf 139KB
settle.jsp 6KB
customerseat.jsp 6KB
selllist.jsp 6KB
workerlist.jsp 7KB
updatecustomer.jsp 7KB
customerlist.jsp 7KB
insertcustomer.jsp 7KB
META-INF
MANIFEST.MF 36B
oneworker.jsp 7KB
tbform.jsp 6KB
login.jsp 2KB
.project 2KB
共 95 条
- 1
资源评论
- Zhoujinglihexin2024-02-05怎么能有这么好的资源!只能用感激涕零来形容TAT...
- m0_750279462023-05-31资源很好用,有较大的参考价值,资源不错,支持一下。
我慢慢地也过来了
- 粉丝: 6457
- 资源: 3993
下载权益
C知道特权
VIP文章
课程特权
开通VIP
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- unity控制对象移动.rar
- TortoiseSVN-1.14.3.29387-x64-svn-1.14.2
- jdk-8u411-macosx-aarch64.dmg
- docker安装.rar
- 美赛数学建模算法-使用Matlab实现常微分方程OridinaryDifferentialEquation-国赛-题解.zip
- FileUploadTestController.java
- 基于MATLAB的数字水印系统源码+GUI操作界面+全部数据资料+使用文档(高分课程设计).zip
- 美赛数学建模算法-使用Matlab实现非线性规划NonLinearProgramming-国赛-题解.zip
- linux安装java8环境资源包
- pcb问题和3D猴制作外壳.7z
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功