package reader;import java.awt.*;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.PreparedStatement;import java.sql.SQLException;import java.sql.Statement;import javax.swing.*;import System_set.dbhelp;public class reader extends JFrame { public JLabel name, age, provename, borrowmax, telephone, provedate, sex, job, proveid, effectivedate, pledge, readerid; public JTextField name_text, age_text, borrowmax_text, telephone_text, provedate_text, job_text, proveid_text, effectivedate_text, pledge_text, readerid_text; public Choice prove; public JRadioButton male, female; public JButton button1, button2; ButtonGroup fm; JFrame f; public reader() { f = new JFrame(); f.setSize(640, 310); f.setVisible(true); f.setResizable(false); f.setLayout(null); // 背景图片设置 ImageIcon background = new ImageIcon("images/addreader.png"); JLabel image = new JLabel(background); image.setBounds(0, 0, background.getIconWidth(), background.getIconHeight()); f.add(image); // name name = new JLabel("姓 名:"); name.setBounds(15, 60, 100, 20); f.add(name); name_text = new JTextField(15); name_text.setText("张琪"); name_text.setBounds(160, 60, 150, 20); f.add(name_text); // age age = new JLabel("年 龄:"); age.setBounds(15, 90, 100, 20); f.add(age); age_text = new JTextField(15); age_text.setText("20"); age_text.setBounds(160, 90, 150, 20); f.add(age_text); // 有效证件 provename = new JLabel("有 效 证 件:"); provename.setBounds(15, 120, 100, 20); f.add(provename); prove = new Choice(); prove.add("工作证"); prove.add("学生证"); prove.add("身份证"); prove.add("教师证"); prove.setBounds(160, 120, 150, 20); f.add(prove); // 最大借书量 borrowmax = new JLabel("最 大 借 书 量:"); borrowmax.setBounds(15, 150, 100, 20); f.add(borrowmax); borrowmax_text = new JTextField(15); borrowmax_text.setText("8"); borrowmax_text.setBounds(160, 150, 150, 20); f.add(borrowmax_text); // 电话 telephone = new JLabel("电 话:"); telephone.setBounds(15, 180, 100, 20); f.add(telephone); telephone_text = new JTextField(15); telephone_text.setText("13564595124"); telephone_text.setBounds(160, 180, 150, 20); f.add(telephone_text); // 办证日期 provedate = new JLabel("办 证 日 期:"); provedate.setBounds(15, 210, 100, 20); f.add(provedate); provedate_text = new JTextField(15); provedate_text.setText("2012-10-21"); provedate_text.setBounds(160, 210, 150, 20); f.add(provedate_text); // sex sex = new JLabel("性 别:"); sex.setBounds(320, 60, 100, 20); f.add(sex); fm = new ButtonGroup(); male = new JRadioButton("男", true); female = new JRadioButton("女"); male.setBounds(480, 60, 50, 20); female.setBounds(540, 60, 50, 20); fm.add(male); fm.add(female); f.add(male); f.add(female); // job job = new JLabel("职 业:"); job.setBounds(320, 90, 100, 20); f.add(job); job_text = new JTextField(15); job_text.setText("学生"); job_text.setBounds(465, 90, 150, 20); f.add(job_text); // 证件号码 proveid = new JLabel("证 件 号 码:"); proveid.setBounds(320, 120, 100, 20); f.add(proveid); proveid_text = new JTextField(15); proveid_text.setText("1234567894561"); proveid_text.setBounds(465, 120, 150, 20); f.add(proveid_text); // 会员证有效日期 effectivedate = new JLabel("会员证有效日期:"); effectivedate.setBounds(320, 150, 110, 20); f.add(effectivedate); effectivedate_text = new JTextField(15); effectivedate_text.setText("2013-10-21"); effectivedate_text.setBounds(465, 150, 150, 20); f.add(effectivedate_text); // 押金 pledge = new JLabel("押 金:"); pledge.setBounds(320, 180, 100, 20); f.add(pledge); pledge_text = new JTextField(15); pledge_text.setText("20"); pledge_text.setBounds(465, 180, 150, 20); f.add(pledge_text); // 读者编码 readerid = new JLabel("读 者 编 码:"); readerid.setBounds(320, 210, 100, 20); f.add(readerid); readerid_text = new JTextField(15); readerid_text.setText("123456779625"); readerid_text.setBounds(465, 210, 150, 20); f.add(readerid_text); // 按钮 button1 = new JButton("保存"); button1.setBounds(250, 240, 60, 20); f.add(button1); button1.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { DefaultButtonModel model = (DefaultButtonModel) male.getModel(); String sexselect = null; if (model.getGroup().isSelected(model)) sexselect = male.getText(); else sexselect = female.getText(); System.out.print(sexselect); String sql = "insert into reader values " + "('" + readerid_text.getText() + "','" + name_text.getText() + "','" + sexselect + "','" + age_text.getText() + "','" + job_text.getText() + "','" + prove.getSelectedItem() + "''" + proveid_text.getText() + "','" + telephone_text.getText() + "','" + borrowmax_text.getText() + "','" + effectivedate_text.getText() + "','" + provedate_text.getText() + "','" + pledge_text.getText() + "')"; try { Statement pstm = dbhelp.xianjie().createStatement(); pstm.executeUpdate(sql); } catch (SQLException e1) { e1.printStackTrace(); } } }); button2 = new JButton("取消"); button2.setBounds(320, 240, 60, 20); f.add(button2); button1.setText("保存"); f.setTitle("读者相关信息添加"); System.out.print( pledge_text.getText().getClass()); } public static void main(String[] args) { new reader(); }}
目前暂无任何回答
- 0 回答
- 0 关注
- 140 浏览
添加回答
举报
0/150
提交
取消