java中sql语句报错Column count doesn't match value count at row 1，求解出错原因

Question

package reader;

import java.awt.Choice;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.ListSelectionModel;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableRowSorter;

import System_set.dbhelp;
import System_set.information_management;
import System_set.remind;

public class reader_update_delete extends information_management{
public reader_update_delete(){
 
 id.setText("读者编号:");
    deparment.setText("年   龄");
    major.setText("有 效 证 件");
    dorm.setText("证件号 :");
    Class.setText("职         业");
   
    J.setVisible(false);
    b1.setVisible(false);
    b2.setVisible(false);
   
 final String[] columnname = { "读者编码", "姓名", "性别", "年龄", "职业", "证件",
   "证件号", "电话","最大借书量","会员证有效日期","办证日期","押金"};
 String sql = "select * from reader";
 PreparedStatement pstm = null;
 int count = 0;
 ResultSet rs = null;

 try {
  pstm = dbhelp.xianjie().prepareStatement(sql);
  rs = pstm.executeQuery();
  while (rs.next()) {
   count++;
  }
 } catch (SQLException e) {
  e.printStackTrace();
 }

 final Object[][] info = new Object[count][12];

 try {
  rs = pstm.executeQuery();
  count = 0;
  while (rs.next()) {
   info[count][0] = rs.getString("id");
   info[count][1] = rs.getString("name");
   info[count][2] = rs.getString("sex");
   info[count][3] = rs.getString("age");
   info[count][4] = rs.getString("profession");
   info[count][5] = rs.getString("prove");
   info[count][6] = rs.getString("prove_id");
   info[count][7] = rs.getString("telephone");
   info[count][8] = rs.getString("max_borrow");
   info[count][9] = rs.getString("effective_date");
   info[count][10] = rs.getString("product_date");
   info[count][11] = rs.getString("money");
   
   count++;
  }
  final DefaultTableModel model = new DefaultTableModel(info,
    columnname);
  newtable = new JTable(model);
  newtable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
  newtable.setRowSorter(new TableRowSorter<>(model));
  newtable.addMouseListener(new MouseAdapter() {
   public void mouseClicked(MouseEvent e) {
    int selectedRow = newtable.getSelectedRow();
    Object oa = model.getValueAt(selectedRow, 0);
    Object ob = model.getValueAt(selectedRow, 1);
    Object oc = model.getValueAt(selectedRow, 2);
    Object od = model.getValueAt(selectedRow, 3);
    Object oe = model.getValueAt(selectedRow, 4);
    Object of = model.getValueAt(selectedRow, 5);
    Object og = model.getValueAt(selectedRow, 6);
    Object oh = model.getValueAt(selectedRow, 7);
    id_text.setText(oa.toString());
    name_text.setText(ob.toString());
    System.out.println(oc.toString().length());
    String fandm = oc.toString();

    if (fandm.equals("m"))// 放着判断f/
     male.setSelected(true);
    else
     female.setSelected(true);

    deparment_text.setText(od.toString());
    major_text.setText(oe.toString());
    Class_text.setText(of.toString());
    dorm_text.setText(og.toString());
    tel_text.setText(oh.toString());
   }
  });
  rs.close();
  pstm.close();
  dbhelp.xianjie().close();

 } catch (SQLException e) {
  e.printStackTrace();
 }
 newJ = new JScrollPane(newtable);
 newJ.setBounds(0, 25, 730, 200);
 frame.add(newJ);
 
 b11 = new JButton("修改");
 b11.setBounds(240, 400, 80, 40);
 frame.add(b11);
 /*b11.setVisible(true);*/
 b11.addActionListener(new ActionListener() {
  public void actionPerformed(ActionEvent e) {
   try {
    int aa = newtable.getSelectedRow();
    if ((Integer) aa != null) {
     info[aa][0] = id_text.getText();
     info[aa][1] = name_text.getText();
     /* info[aa][2]=sex_text.getText(); */
     info[aa][3] = deparment_text.getText();
     info[aa][4] = major_text.getText();
     info[aa][5] = Class_text.getText();
     info[aa][6] = dorm_text.getText();
     info[aa][7] = tel_text.getText();
     DefaultTableModel newmodel = (DefaultTableModel) newtable
       .getModel();
     newmodel.setDataVector(info, columnname);
     newtable.updateUI();

     String sql = "update reader set name='"
       + name_text.getText() + "'," + " age='"
       + deparment_text.getText() + "',profession='"
       + major_text.getText() + "'," + "prove='"
       + dorm_text.getText() + "',prove_id='"
       + Class_text.getText() + "'," + "telephone='"
       + tel_text.getText() + "' where id='"
       + id_text.getText() + "'";

     Statement pstm = dbhelp.xianjie().createStatement();
     pstm.executeUpdate(sql);
     System.out.println(pstm.executeUpdate(sql));
     JOptionPane.showMessageDialog(null, "修改成功");
    }
   } catch (ArrayIndexOutOfBoundsException ex) {
    /*new remind("Select the user that needs to be modified",
      "close",
      "Select the user that needs to be modified");*/
   ex.printStackTrace();
   } catch (SQLException e1) {
    e1.printStackTrace();
   }
  }
 });
 b2 = new JButton("删除");
 b2.setBounds(430, 400, 80, 40);
 frame.add(b2);
 b2.addActionListener(new ActionListener() {
  public void actionPerformed(ActionEvent e) {
   int aa = newtable.getSelectedRow();
   try {
    if (id_text.getText().length() == 0
      || deparment_text.getText().length() == 0
      || name_text.getText().length() == 0
      || major_text.getText().length() == 0
      || dorm_text.getText().length() == 0
      || dorm_text.getText().length() == 0)
     new remind("Select the deleted user", "close",
       "Select the deleted user");
    String sql = "delete from reader where id='"
      + id_text.getText() + "'";

    Statement pstm = dbhelp.xianjie().createStatement();
    pstm.executeUpdate(sql);

   } catch (SQLException e1) {
    e1.printStackTrace();
   }
   if (id_text.getText().length() != 0
     && deparment_text.getText().length() != 0
     && name_text.getText().length() != 0
     && major_text.getText().length() != 0
     && dorm_text.getText().length() != 0
     && dorm_text.getText().length() != 0) {
    frame.dispose();
    new reader_update_delete();
   }
  }
 });
}
 public static void main(String[] args) {
     new reader_update_delete();
 }

}