为了账号安全,请及时绑定邮箱和手机立即绑定

紧急Column count doesn't match value count at row 1

紧急Column count doesn't match value count at row 1

2015071819 2017-06-07 14:32:14
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
提交
取消
意见反馈 帮助中心 APP下载
官方微信