基于Java+Swing+mysql游泳馆会员管理系统

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); } }