package swimming;
import java.awt.BorderLayout;
import java.awt.EventQueue;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.border.EmptyBorder;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import java.awt.Font;
import javax.swing.SwingConstants;
import javax.swing.JButton;
import javax.swing.JTextField;
import java.awt.event.ActionListener;
import java.security.Timestamp;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.awt.event.ActionEvent;
import java.util.*;
public class UserHomePage extends JFrame {
protected static final String List = null;
private JPanel contentPane;
private JTextField textField;
private JTextField textField_1;
/**
* Launch the application.
*/
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
UserHomePage frame = new UserHomePage();
frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
});
}
public static String getType(Object test) {
return test.getClass().getName().toString();
}
/**
* Create the frame.
*/
public UserHomePage() {
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setBounds(100, 100, 450, 320);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
contentPane.setLayout(null);
JLabel lblNewLabel = new JLabel("欢迎使用游泳馆管理系统");
lblNewLabel.setHorizontalAlignment(SwingConstants.CENTER);
lblNewLabel.setFont(new Font("宋体", Font.PLAIN, 30));
lblNewLabel.setBounds(0, 10, 426, 49);
contentPane.add(lblNewLabel);
JLabel lblNewLabel_1 = new JLabel("姓名:");
lblNewLabel_1.setFont(new Font("宋体", Font.PLAIN, 20));
lblNewLabel_1.setBounds(104, 81, 66, 26);
contentPane.add(lblNewLabel_1);
textField = new JTextField();
textField.setBounds(180, 86, 110, 21);
contentPane.add(textField);
textField.setColumns(10);
JLabel lblNewLabel_1_1 = new JLabel("卡号:");
lblNewLabel_1_1.setFont(new Font("宋体", Font.PLAIN, 20));
lblNewLabel_1_1.setBounds(104, 133, 66, 26);
contentPane.add(lblNewLabel_1_1);
textField_1 = new JTextField();
textField_1.setColumns(10);
textField_1.setBounds(179, 138, 110, 21);
contentPane.add(textField_1);
JLabel lblNewLabel_2 = new JLabel("30元/次");
lblNewLabel_2.setFont(new Font("微软雅黑", Font.PLAIN, 16));
lblNewLabel_2.setBounds(165, 181, 75, 27);
contentPane.add(lblNewLabel_2);
JButton btnNewButton = new JButton("使用会员卡");
btnNewButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
try {
PreparedStatement ps=null;
Conn conn1 = new Conn();
conn1.getConn();
String vipname = textField.getText();
String cardnumber = textField_1.getText();
String sql ="select * from cards where vip_name=? and card_num=?";
ps=conn1.getConn().prepareStatement(sql);
ps.setString(1,vipname);
ps.setString(2,cardnumber);
ResultSet rs = ps.executeQuery();
while(rs.next()){
if(!rs.getString("card_status").equals("正常")) {
JOptionPane.showMessageDialog(null, "无法使用会员卡");
}
else {
String cardamount = rs.getString("card_amount");
String vipsale = rs.getString("vip_sale");
float vipsale_=Float.parseFloat(vipsale);
float amount_ = vipsale_ * 30;
String amount1 =Float.toString(amount_);
float cardamount_=Float.parseFloat(cardamount);
float balance_ = cardamount_ - amount_;
String balance1=Float.toString(balance_);
Date date = new java.util.Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String sysdate = sdf.format(date);
//System.out.printf(sysdate);
//list.add(new Consume(cardnumber,vipname,cardamount,amount1,balance1,null));
String sql1 ="insert into consume(card_num,vip_name,deposit_amount,amount,balance,consume_time) values (?,?,?,?,?,?)";
//String sql1 ="insert into consume(card_num,vip_name,deposit_amount,amount,balance) values ('"+cardnumber+"','"+vipname+"','"+cardamount+"','"+amount1+"','"+balance)";
ps=conn1.getConn().prepareStatement(sql1);
ps.setString(1,cardnumber);
ps.setString(2, vipname);
ps.setString(3, cardamount);
ps.setString(4, amount1);
ps.setString(5, balance1);
ps.setString(6, sysdate);
int n=ps.executeUpdate();
if(n>0) {
JOptionPane.showMessageDialog(null, "消费成功");
}
}
}
ps.close();
conn1.getConn().close();
}catch(Exception e1) {
e1.printStackTrace();
}
}
});
btnNewButton.setFont(new Font("宋体", Font.PLAIN, 18));
btnNewButton.setBounds(77, 216, 137, 37);
contentPane.add(btnNewButton);
JButton btnNewButton_1 = new JButton("消费记录");
btnNewButton_1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
try {
PreparedStatement ps=null;
Conn conn1 = new Conn();
conn1.getConn();
String sql = "select * from consume where card_num=?";
ps=conn1.getConn().prepareStatement(sql);
ps.setString(1, textField_1.getText());
ResultSet rs = ps.executeQuery();
int count = 0;
while(rs.next()){
count++;
}
if(count==0) {
JOptionPane.showMessageDialog(null, "没有此会员");
}
else {
rs = ps.executeQuery();
Object[][] info = new Object[count][6];
count = 0;
while(rs.next()){
info[count][0] = rs.getString("card_num");
info[count][1] = rs.getString("vip_name");
info[count][2] = rs.getString("deposit_amount");
info[count][3] = rs.getString("amount");
info[count][4] = rs.getString("balance");
info[count][5] = rs.getString("consume_time");
count++;
}
String[] title = {"卡号", "姓名", "存款金额", "消费金额", "结存余额", "消费时间"};
JTable table1 = new JTable(info,title);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setBounds(100, 100, 595, 453);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
JScrollPane scrollPane = new JScrollPane();
scrollPane.setBounds(15, 57, 552, 356);
table1.setFont(new Font("宋体", Font.PLAIN, 10));
scrollPane.setViewportView(table1);
contentPane.add(scrollPane);
}}catch(Exception e1) {
e1.printStackTrace();
}
}
});
btnNewButton_1.setFont(new Font("宋体", Font.PLAIN, 18));
btnNewButton_1.setBounds(249, 216, 137, 37);
contentPane.add(btnNewButton_1);
}
public void init()
{
UserHomePage frame = new UserHomePage();
frame.setVisible(true);
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
基于Java+Swing+mysql游泳馆会员管理系统(高分课程设计)已获导师指导并通过的95分的高分期末大作业项目,可作为课程设计和期末大作业,下载即用无需修改,项目完整确保可以运行。 该系统功能完善、界面美观、操作简单、功能齐全、管理便捷,具有很高的实际应用价值。 一、系统介绍 该系统实现了管理员系统登陆、售卡、存款管理、退卡、消费管理、会员资料查询、会员资料修改、会员禁用、系统管理。 会员:使用会员卡、查看消费记录。 详见:https://blog.csdn.net/Timi2019/article/details/128371809
资源推荐
资源详情
资源评论
收起资源包目录
基于Java+Swing+mysql游泳馆会员管理系统(高分课程设计).rar (63个子文件)
基于Java+Swing+mysql游泳馆会员管理系统(高分课程设计)
swimming-pool-master
lib
mysql-connector-java-8.0.21.jar 2.29MB
.classpath 377B
.settings
org.eclipse.jdt.core.prefs 598B
org.eclipse.core.resources.prefs 57B
src
swimming
Conn.java 944B
Message.java 224B
SystemHomePage.java 4KB
Revise.java 5KB
DisableCard.java 4KB
UserHomePage.java 7KB
SystemManagement.java 3KB
Dao.java 1KB
ConsumeHistory.java 5KB
ReturnCard.java 3KB
SetAmount.java 3KB
ExportCSV.java 1KB
CSVUtil.java 4KB
SellCards.java 6KB
Login.java 4KB
Select.java 4KB
bin
swimming
DisableCard.class 2KB
SystemManagement$1.class 2KB
SystemHomePage.class 3KB
Conn.class 1KB
Revise$1.class 2KB
SystemHomePage$2.class 756B
DisableCard$1.class 734B
ConsumeHistory.class 3KB
SystemHomePage$6.class 767B
Select.class 2KB
UserHomePage$3.class 3KB
DisableCard$3.class 2KB
ConsumeHistory$1.class 3KB
SetAmount$1.class 3KB
SellCards.class 4KB
ExportCSV.class 2KB
Dao.class 2KB
SystemManagement.class 2KB
Select$1.class 3KB
ReturnCard.class 2KB
UserHomePage$2.class 3KB
Message.class 558B
Login.class 4KB
Login$2.class 846B
SellCards$1.class 3KB
UserHomePage$1.class 739B
ConsumeHistory$2.class 3KB
CSVUtil.class 5KB
DisableCard$2.class 2KB
Login$1.class 2KB
SystemHomePage$5.class 765B
SystemHomePage$3.class 758B
ReturnCard$1.class 2KB
SystemHomePage$8.class 777B
SystemHomePage$7.class 773B
SystemHomePage$1.class 763B
Login$3.class 2KB
UserHomePage.class 3KB
SystemHomePage$4.class 763B
SetAmount.class 2KB
Revise.class 4KB
.project 396B
db
swimming.sql 5KB
共 63 条
- 1
资源评论
小码叔
- 粉丝: 4504
- 资源: 1221
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 基于快速傅里叶变换算法的蜂鸣器音频分析技术
- 高分项目,PID-电机类-开源工业伺服电机PID控制,源码+原理图+操作手册
- 高分项目,PID-电机类-超级牛的STM32 BLDC直流电机控制器设计,附原理图和源码
- 高分项目,PID-电机类- 基于红外遥控的多功能智能电风扇控制器源码
- 高分项目,PID-电机类- 基于NRF24L01的PID电机转速控制器,源码+无线PID电机转速控制器+接收机
- 基于Matlab读取sif格式文件,并且画图
- Python基于Django图书管理系统(源码+数据库脚本+截图)高分期末大作业
- Screenshot_20240619_075859.jpg
- 8051Proteus仿真c源码1602液晶显示的DS1302实时时钟
- 8051Proteus仿真c源码1602LCD显示仿手机键盘按键字符
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功