package com.zhong.DAO;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;
public class FlowerDao implements BaseDao{
private Object[][] obj;
private Object[] object;
public Object[][] showall(String tablename){
int val = 0;
Connection conn = null;
PreparedStatement ps = null;
Statement s = null;
ResultSet rs = null;
ResultSet rs0 = null;
String sql = "select fname,fprice,fsold,fnum from " + tablename;
String sql0 = "select count(*) from " + tablename;
try {
int count = 0;
conn = new ConnectionFactory().getConnection();
ps = conn.prepareStatement(sql);
s = conn.createStatement();
rs0 = s.executeQuery(sql0);
while(rs0.next()){
val = (int) rs0.getObject(1);
}
obj = new Object[val][4];
rs = ps.executeQuery();
while(rs.next()){
obj[count][0] = rs.getObject(1);
obj[count][1] = rs.getObject(2);
obj[count][2] = rs.getObject(3);
obj[count][3] = rs.getObject(4);
count++;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
JOptionPane.showInternalMessageDialog(null, "杩炴帴鏁版嵁搴撳け璐�,璇峰皾璇曢噸鏂拌繛鎺�");
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
JOptionPane.showInternalMessageDialog(null, "娌℃湁鍏抽棴鏁版嵁搴撹鍏抽棴鏁版嵁搴�");
}
}
return obj;
}
public Object[][] image(){
int val = 0;
Connection conn = null;
PreparedStatement ps = null;
Statement s = null;
ResultSet rs = null;
ResultSet rs0 = null;
String sql = "select fname,fprice,fnum,fimg from Flower";
String sql0 = "select count(*) from Flower";
try {
int count = 0;
conn = new ConnectionFactory().getConnection();
ps = conn.prepareStatement(sql);
s = conn.createStatement();
rs0 = s.executeQuery(sql0);
while(rs0.next()){
val = Integer.parseInt(rs0.getObject(1).toString());
}
obj = new Object[val][4];
rs = ps.executeQuery();
while(rs.next()){
obj[count][0] = rs.getObject(1);
obj[count][1] = rs.getObject(2);
obj[count][2] = rs.getObject(3);
obj[count][3] = rs.getObject(4);
count++;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
JOptionPane.showInternalMessageDialog(null, "杩炴帴鏁版嵁搴撳け璐�,璇峰皾璇曢噸鏂拌繛鎺�");
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
JOptionPane.showInternalMessageDialog(null, "娌℃湁鍏抽棴鏁版嵁搴撹鍏抽棴鏁版嵁搴�");
}
}
return obj;
}
public Object[][] RankbySold(String name){
int val = 0;
Connection conn = null;
PreparedStatement ps = null;
Statement s = null;
ResultSet rs = null;
ResultSet rs0 = null;
String sql = "select fname,fcome,fprice,fsold from Flower order by "+name+" desc";
String sql0 = "select count(*) from Flower";
try {
int count = 0;
conn = new ConnectionFactory().getConnection();
ps = conn.prepareStatement(sql);
s = conn.createStatement();
rs0 = s.executeQuery(sql0);
while(rs0.next()){
val = (int) rs0.getObject(1);
}
obj = new Object[val][5];
rs = ps.executeQuery();
while(rs.next()){
obj[count][0] = rs.getObject(1);
obj[count][1] = rs.getObject(2);
obj[count][2] = rs.getObject(3);
obj[count][3] = rs.getObject(4);
obj[count][4] = (Float.parseFloat(obj[count][2].toString())-Float.parseFloat(obj[count][1].toString()))*Integer.parseInt(obj[count][3].toString());
count++;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
JOptionPane.showInternalMessageDialog(null, "杩炴帴鏁版嵁搴撳け璐�,璇峰皾璇曢噸鏂拌繛鎺�");
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
JOptionPane.showInternalMessageDialog(null, "娌℃湁鍏抽棴鏁版嵁搴撹鍏抽棴鏁版嵁搴�");
}
}
return obj;
}
public Object[][] showall(){
int val = 0;
Connection conn = null;
PreparedStatement ps = null;
Statement s = null;
ResultSet rs = null;
ResultSet rs0 = null;
String sql = "select fname,fcome,fprice,fsold from Flower";
String sql0 = "select count(*) from Flower";
try {
int count = 0;
conn = new ConnectionFactory().getConnection();
ps = conn.prepareStatement(sql);
s = conn.createStatement();
rs0 = s.executeQuery(sql0);
while(rs0.next()){
val = (int) rs0.getObject(1);
}
obj = new Object[val][5];
rs = ps.executeQuery();
while(rs.next()){
obj[count][0] = rs.getObject(1);
obj[count][1] = rs.getObject(2);
obj[count][2] = rs.getObject(3);
obj[count][3] = rs.getObject(4);
obj[count][4] = (Float.parseFloat(obj[count][2].toString())-Float.parseFloat(obj[count][1].toString()))*Integer.parseInt(obj[count][3].toString());
count++;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
JOptionPane.showInternalMessageDialog(null, "杩炴帴鏁版嵁搴撳け璐�,璇峰皾璇曢噸鏂拌繛鎺�");
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
JOptionPane.showInternalMessageDialog(null, "娌℃湁鍏抽棴鏁版嵁搴撹鍏抽棴鏁版嵁搴�");
}
}
return obj;
}
public Object[][] FinaceShow(){
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
String sql = "select top 6 fname,fsold,fprice,fcome from Flower order by fsold*(fprice-fcome) desc";
try {
int count = 0;
conn = new ConnectionFactory().getConnection();
ps = conn.prepareStatement(sql);
obj = new Object[6][2];
rs = ps.executeQuery();
while(rs.next()){
obj[count][0] = rs.getObject(1);
obj[count][1] = (Integer.parseInt((rs.getObject(2).toString()))*((Float.parseFloat(rs.getObject(3).toString())-(Float.parseFloat(rs.getObject(4).toString())))));
count++;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
JOptionPane.showInternalMessageDialog(null, "杩炴帴鏁版嵁搴撳け璐�,璇峰皾璇曢噸鏂拌繛鎺�");
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
JOptionPane.showInternalMessageDialog(null, "娌℃湁鍏抽棴鏁版嵁搴撹鍏抽棴鏁版嵁搴�");
}
}
return obj;
}
public Object[] FindShow(String name){
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
String sql = "select fname,fcome,fnum,fprice,fsold,fimg from Flower where fname like '%"+name+"%'";
try {
conn = new ConnectionFactory().getConnection();
ps = conn.prepareStatement(sql);
object = new Object[6];
rs = ps.executeQuery();
while(rs.next()){
object[0] = rs.getObject(1);
object[1] = rs.getObject(2);
object[2] = rs.getObject(3);
object[3] = rs.getObject(4);
object[4] = rs.getObject(5);
object[5] = rs.getObject(6);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
JOptionPane.showInternalMessageDialog(null, "杩炴帴鏁版嵁搴撳け璐�,璇峰皾璇曢噸鏂拌繛鎺�");
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
JOptionPane.showInternalMessageDialog(null, "娌℃湁鍏抽棴鏁版嵁搴撹鍏抽棴鏁版嵁搴�");
}
}
return object;
}
@Override
public Boolean delete(String tablename,int id) {
// TODO Auto-generated method stub
int count;
Connection conn = null;
Prepared
花店管理系统 （149个子文件） 
FlowerDao.class 9KB GeneralPanel.class 7KB MainFinancePanel.class 6KB OrderDao.class 5KB AddOrderPanel.class 5KB MemberAddPanel.class 5KB AddFlowerPanel.class 5KB MainOrderPanel.class 4KB FlowEditPanel.class 4KB MemberDao.class 4KB FindPanel.class 4KB MainMemberPanel.class 4KB OrderPanel.class 3KB LoginPanel.class 3KB BarChart.class 3KB AddOrderPanel$2.class 3KB ExcelExporter.class 3KB ReceivePicture.class 2KB AddFlowerPanel$2.class 2KB MainEditPanel.class 2KB SelectDir.class 2KB MainflowerPanel.class 2KB AddFlowerPanel$1.class 2KB FlowEditPanel$1.class 2KB GeneralPanel$9.class 2KB FlowerEditModel.class 2KB MyRender.class 2KB GeneralPanel$8.class 2KB SendPicture.class 2KB MainOrderPanel$3.class 1KB MainOrderPanel$5.class 1KB Member.class 1KB FileOpen.class 1KB MemberAddPanel$3.class 1KB LoginPanel$1.class 1KB Order.class 1KB Flower.class 1KB TableModel.class 1KB MainFinancePanel$5.class 1KB ConnectionFactory.class 1KB MainEditPanel$1.class 1KB GeneralPanel$3.class 1KB GeneralPanel$5.class 1KB GeneralPanel$4.class 1KB GeneralPanel$1.class 1KB GeneralPanel$2.class 1KB ReceivePicture$1.class 1KB MP3Player.class 1016B MainFinancePanel$4.class 1002B MainFinancePanel$3.class 1002B MainFinancePanel$1.class 999B MainFinancePanel$2.class 999B MainOrderPanel$1.class 927B MainshowPanel.class 926B MainPanel.class 885B MainOrderPanel$2.class 835B MainOrderPanel$4.class 760B GeneralPanel$6.class 757B GeneralPanel$7.class 754B MainMemberPanel$2.class 746B MemberAddPanel$1.class 741B MemberAddPanel$2.class 741B LoginPanel$2.class 740B AddOrderPanel$1.class 735B PicTransparent.class 732B OrderPanel$1.class 724B MainMemberPanel$1.class 717B FindPanel$1.class 708B MemberRender.class 663B MemberEditModel.class 663B Manager.class 442B BaseDao.class 286B .classpath 607B
jfreechart-1.0.13.jar 1.36MB jxl.jar 709KB sqljdbc4.jar 571KB jcommon-1.0.16.jar 302KB jl1.0.1.jar 103KB FlowerDao.java 9KB GeneralPanel.java 7KB MainFinancePanel.java 6KB AddOrderPanel.java 5KB OrderDao.java 5KB MemberAddPanel.java 5KB AddFlowerPanel.java 4KB LoginPanel.java 4KB FindPanel.java 4KB FlowEditPanel.java 4KB MainOrderPanel.java 3KB BarChart.java 3KB MemberDao.java 3KB OrderPanel.java 3KB MainMemberPanel.java 2KB ExcelExporter.java 2KB ReceivePicture.java 2KB MainEditPanel.java 2KB FlowerEditModel.java 2KB SelectDir.java 1KB MyRender.java 1KB FileOpen.java 1KB共 149 条
- 1
- 2
资源评论
孑流丶2019-09-04可惜了，不是我想要的
zhuo��怀2019-09-04代码可以再详细一点吗
覃同学2020-06-14我下载完没有找到数据库，请问里边有数据库吗
Sivan0072017-12-14后台配置讲一讲
passer_zzy
- 粉丝: 40
- 资源: 5
最新资源
- 博途S7-1200主站与S7-200从站实现RS485通讯程序 S7-200可以当作一个仪表
- C#、C++分别开发的OPC DA CLIENT软件. 1、枚举服务器名称； 2、连接服务器以后枚举出TAG； 3、根据TAG名称自动读取服务器数据； 4、图片内有OPC SERVER和CLIENT实
- python-workspace.zip.005
- 龙门上下料样本程序，四轴 用台达AS228T和台达触摸屏编写 注意软件是用台达新款软件ISPSOFT ，借鉴价值高，程序有注释
- 一款window下的串口监视抓包工具
- 欧姆龙CP1H与3台力士乐VFC-x610变频器通讯程序 功能：原创程序，可直接用于现场程序 欧姆龙CP1H的CIF11通讯板，实现对3台力士乐VFC-x610变频器 设定频率，控制正反转，读取实际
- dp111113333
- CV-密集人群图像数据集（5800张图片）.rar
- 福特汽车主观评价规范，性能开发参考，英文原版直译，评价条目、规则描述非常细致 包含平顺舒适性，转向，操稳，NVH，制动，加速感，驾驶性等等性能，并详细描述了评价的准备工作 评价条目细分至第四级，共
- 三菱FX3S两轴标准程序，XZ两轴，包含轴点动，回零，相对与绝对定位，只要弄明白这个程序，就可以非常了解整个项目的程序如何去编写，从哪里开始下手，可提供程序问题解答，程序流程清晰明了，注释完整
- MATLAB代码：考虑P2G与碳捕集机组的多能微网低碳经济调度 关键词：碳交易 阶梯碳交易 碳捕集 多能微网 低碳调度 仿真平台：MATLAB+yalmip+cplex 主要内容：代码主要做的是一个
- 本程序采用matlab编写，主要是实现电流注入型牛拉法 除此之外，本人还编写了很多种关于潮流计算的程序，主要有牛拉法，前推回代法，以还有相和三相潮流计算程序
- 智能门锁架构图，供大家参考
- 三菱FX3U六轴标准程序，程序包含本体3轴控制，扩展3个1PG定位模块,一共六轴 程序有轴点动控制，回零控制，相对定位，绝对定位 另有气缸数个，一个大是DD马达控制的转盘，整个是转盘多工位流水作业
- 批量登录到远程Linux服务器检查服务器时间差的shell
- MATLAB电动车七自由度整车模型 MATLAB Simulink电动车转弯制动abs模型asr转弯制动防抱死abs模型+模糊控制算法+七自由度整车模型+纵向运动+侧向运动+横摆运动+四轮魔术公式+四
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
