Home  >  Article  >  Database  >  mysql-下面的Java代码有问题吗

mysql-下面的Java代码有问题吗

WBOY
WBOYOriginal
2016-06-06 09:34:541211browse

mysqljava数据库

public class Regist extends JFrame implements ActionListener {

<code>/** *  */private static final long serialVersionUID = 1L;private JPanel contentPane;private JTextField text_confirm;private JTextField text_usr;private JTextField text_pwd;private JButton btn_save,btn_cancel;private JLabel user,passwd,confirm;private Connection conn;private Statement statement;/** * Launch the application. */public static void main(String[] args) {    EventQueue.invokeLater(new Runnable() {        public void run() {            try {                Regist frame = new Regist();                frame.setVisible(true);            } catch (Exception e) {                e.printStackTrace();            }        }    });}/** * Create the frame. */public Regist() {    super("注册新用户");    this.setDefaultCloseOperation(EXIT_ON_CLOSE);    this.setVisible(true);    setBounds(100, 100, 450, 300);    contentPane = new JPanel();    contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));    setContentPane(contentPane);    contentPane.setLayout(null);    user = new JLabel("用  户  名");    user.setBounds(57, 36, 54, 15);    contentPane.add(user);    passwd = new JLabel("密       码");    passwd.setBounds(57, 76, 54, 15);    contentPane.add(passwd);    confirm = new JLabel("确认密码");    confirm.setBounds(57, 121, 54, 15);    contentPane.add(confirm);    text_usr = new JTextField();    text_usr.setBounds(141, 33, 155, 21);    contentPane.add(text_usr);    text_usr.setColumns(10);    text_pwd = new JTextField();    text_pwd.setBounds(141, 73, 155, 21);    contentPane.add(text_pwd);    text_pwd.setColumns(10);    text_confirm = new JTextField();    text_confirm.setBounds(141, 118, 155, 21);    contentPane.add(text_confirm);    text_confirm.setColumns(10);    btn_save = new JButton("确定");    btn_save.setBounds(79, 171, 93, 23);    contentPane.add(btn_save);    this.btn_save.addActionListener(this);    btn_cancel = new JButton("取消");    btn_cancel.setBounds(256, 171, 93, 23);    contentPane.add(btn_cancel);    this.btn_cancel.addActionListener(this);}public Connection getConnection() throws SQLException {    try {        Class.forName("com.mysql.jdbc.Driver");    } catch (ClassNotFoundException e) {        e.printStackTrace();    }    Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/sign","root","514519");    return conn;}@Overridepublic void actionPerformed(ActionEvent e) {    if(e.getSource()==btn_save){        if(text_usr.getText().isEmpty()&&text_pwd.getText().isEmpty())            JOptionPane.showMessageDialog(this, "请填写用户名和密码");        String sql="insert into signs values ('"+text_usr.getText()+","+text_pwd.getText()+"')";        try {               conn=getConnection();        } catch (SQLException e1) {            e1.printStackTrace();        }        try {            statement=conn.createStatement();        } catch (SQLException e1) {            e1.printStackTrace();        }        try {            statement.executeUpdate(sql);        } catch (SQLException e1) {            e1.printStackTrace();        }        try {            statement.close();        } catch (SQLException e2) {            e2.printStackTrace();        }        try {            conn.close();        } catch (SQLException e1) {            e1.printStackTrace();        }    }       if(e.getSource()==btn_cancel){    }}</code>

}
运行的时候说Column count doesn't match value count at row 1
我数据库中的user 和password都是varchar类型
还有就是这行代码中的引号问题 String sql="insert into signs values ('"+text_usr.getText()+","+text_pwd.getText()+"')"; 新手有点迷糊 求帮助

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn