基于Javaweb的在线花店卖花系统（源码+数据库+jar包）.zip资源
package com.items.dao.impl; 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.items.bean.Orders; import com.items.bean.vo.OrdersVo; import com.items.dao.OrdersDao; import com.items.util.JdbcUtil; public class OrdersDaoImpl implements OrdersDao{public List<Orders> selectOrdersBuy(int flag, int userId) {List<Orders> orders = new ArrayList<Orders>();Connection conn = null;PreparedStatement ps = null;ResultSet rs = null;try {conn = JdbcUtil.getConnection();conn.setAutoCommit(false);ps = conn.prepareStatement("select * from orders where flag=? and userId=?");ps.setInt(1, flag);ps.setInt(2, userId);rs = ps.executeQuery();while(rs.next()){Orders orders1 = new Orders();orders1.setOrderId(rs.getInt("orderId"));orders1.setShopId(rs.getInt("shopId"));orders1.setPriceAll(rs.getDouble("priceAll"));orders1.setContent(rs.getString("content"));orders1.setComment(rs.getString("comment"));orders.add(orders1);}conn.commit();} catch (SQLException e) {System.out.println(e);try {conn.rollback();} catch (SQLException e1) {e1.printStackTrace();}}finally{JdbcUtil.close(rs, ps, conn);}return orders;}public List<OrdersVo> selectOrdersBuyVo(int orderId) {List<OrdersVo> ordersVo = new ArrayList<OrdersVo>();Connection conn = null;PreparedStatement ps = null;ResultSet rs = null;try {conn = JdbcUtil.getConnection();conn.setAutoCommit(false);ps = conn.prepareStatement("select s.shopId,s.shopname,o.content,o.priceAll,o.comment,o.orderId,o.userappraise,o.shopappraise,o.userapptime from shop s join orders o on o.shopId=s.shopId where orderId= ?");ps.setInt(1, orderId);rs = ps.executeQuery();while (rs.next()) {OrdersVo orders1 = new OrdersVo();orders1.setOrderId(rs.getInt("orderId"));orders1.setShopId(rs.getInt("shopId"));orders1.setShopName(rs.getString("shopName"));orders1.setPriceAll(rs.getDouble("priceAll"));orders1.setContent(rs.getString("content"));orders1.setComment(rs.getString("comment"));orders1.setUserappraise(rs.getString("userappraise"));orders1.setShopappraise(rs.getString("shopappraise"));orders1.setUserapptime(rs.getString("userapptime"));ordersVo.add(orders1);}conn.commit();} catch (SQLException e) {try {conn.rollback();} catch (SQLException e1) {e1.printStackTrace();}} finally {JdbcUtil.close(rs, ps, conn);}return ordersVo;}public boolean selectOrdersBuyDel(int orderId,int userId) {boolean b = false;Connection conn = null;PreparedStatement ps = null;ResultSet rs = null;try {conn = JdbcUtil.getConnection();conn.setAutoCommit(false);System.out.println(orderId);ps = conn.prepareStatement("delete from orders where orderId = ? and userId=? ");ps.setInt(1, orderId);ps.setInt(2, userId);ps.executeUpdate();rs = ps.getGeneratedKeys();if(rs.next()) {b = true;}conn.commit();} catch (SQLException e) {try {conn.rollback();} catch (SQLException e1) {e1.printStackTrace();}} finally {JdbcUtil.close(rs, ps, conn);}return b;}public List<Orders> selectOrdersSell(int flag, int shopId) {List<Orders> orders = new ArrayList<Orders>();Connection conn = null;PreparedStatement ps = null;ResultSet rs = null;try {conn = JdbcUtil.getConnection();conn.setAutoCommit(false);ps = conn.prepareStatement("select * from orders where flag=? and shopId=?");ps.setInt(1, flag);ps.setInt(2, shopId);rs = ps.executeQuery();while(rs.next()){Orders orders1 = new Orders();orders1.setOrderId(rs.getInt("orderId"));orders1.setShopId(rs.getInt("shopId"));orders1.setPriceAll(rs.getDouble("priceAll"));orders1.setContent(rs.getString("content"));orders1.setComment(rs.getString("comment"));orders.add(orders1);}conn.commit();} catch (SQLException e) {System.out.println(e);try {conn.rollback();} catch (SQLException e1) {e1.printStackTrace();}}finally{JdbcUtil.close(rs, ps, conn);}return orders;}public List<OrdersVo> selectOrdersSellVo(int orderId) {List<OrdersVo> ordersVo = new ArrayList<OrdersVo>();Connection conn = null;PreparedStatement ps = null;ResultSet rs = null;try {conn = JdbcUtil.getConnection();conn.setAutoCommit(false);ps = conn.prepareStatement("select u.userId,u.username,o.content,o.priceAll,o.comment,o.orderId ,o.userappraise,o.shopappraise from user u join orders o on o.userId=u.userId where orderId=?");ps.setInt(1, orderId);rs = ps.executeQuery();while (rs.next()) {OrdersVo orders1 = new OrdersVo();orders1.setOrderId(rs.getInt("orderId"));orders1.setUserId(rs.getInt("userId"));orders1.setUserName(rs.getString("userName"));orders1.setPriceAll(rs.getDouble("priceAll"));orders1.setContent(rs.getString("content"));orders1.setComment(rs.getString("comment"));orders1.setUserappraise(rs.getString("userappraise"));orders1.setShopappraise(rs.getString("shopappraise"));ordersVo.add(orders1);}conn.commit();} catch (SQLException e) {try {conn.rollback();} catch (SQLException e1) {e1.printStackTrace();}} finally {JdbcUtil.close(rs, ps, conn);}return ordersVo; }public boolean selectOrdersSellDel(int orderId, int shopId) {boolean b = false;Connection conn = null;PreparedStatement ps = null;ResultSet rs = null;try {conn = JdbcUtil.getConnection();conn.setAutoCommit(false);ps = conn.prepareStatement("delete from orders where orderId = ? and shopId=? ");ps.setInt(1, orderId);ps.setInt(2, shopId);ps.executeUpdate();rs = ps.getGeneratedKeys();if(rs.next()) {b = true;}conn.commit();} catch (SQLException e) {try {conn.rollback();} catch (SQLException e1) {e1.printStackTrace();}} finally {JdbcUtil.close(rs, ps, conn);}return b;}public boolean sureOrders(int orderId) {boolean b = false;Connection conn = null;PreparedStatement ps = null;ResultSet rs = null;try {conn = JdbcUtil.getConnection();conn.setAutoCommit(false);ps = conn.prepareStatement("update orders set orders.flag=1 where orderId=?");ps.setInt(1, orderId);ps.executeUpdate();rs = ps.getGeneratedKeys();if(rs.next()) {b = true;}conn.commit();} catch (SQLException e) {try {conn.rollback();} catch (SQLException e1) {e1.printStackTrace();}} finally {JdbcUtil.close(rs, ps, conn);}return b;}public List<Orders> selectOrdersAlLi(int orderId,String userappraise,String userapptime) {List<Orders> orders = new ArrayList<Orders>();Connection conn = null;PreparedStatement ps = null;ResultSet rs = null;try {conn = JdbcUtil.getConnection();conn.setAutoCommit(false);ps = conn.prepareStatement("update orders set orders.userappraise=? , userapptime=? where orderId=? ");ps.setString(1, userappraise);ps.setString(2, userapptime);ps.setInt(3, orderId);ps.executeUpdate();rs = ps.getGeneratedKeys();conn.commit();} catch (SQLException e) {
相关知识
计算机毕业设计之 [含实训报告+源码等]javaweb花店管理系统[包运行成功]
Java项目源码javaweb花店销售管理系统
计算机毕业设计基于JavaWeb的在线鲜花销售网站
基于SpringBoot+vue的在线花店后台管理系统完整源码+数据库+说明（毕设）.zip
基于决策树算法的空气质量预测系统
避雨大棚温室资源
土壤肥力分析系统（VB）资源
基于JavaWeb实现网上花店商城系统
【免费】基于yolov5的番茄病虫害识别资源
体育竞技预测模型yuce.py资源
网址: 基于Javaweb的在线花店卖花系统（源码+数据库+jar包）.zip资源 https://m.huajiangbk.com/newsview552371.html
| 上一篇: ASP.NET 在线花店系统的设 |
下一篇: 花草播种发芽慢，用路由器催芽法， |
