java - 使用java1001插入数据库

Question

每次尝试保存或执行查询时，我总是收到此错误。我无法解决这个问题，也许一些建议会有所帮助。

java.sql.SQLException: can not issue data manipulation statements with executeQuery()

这是我插入数据库的代码。

Connection conn=null; ResultSet rs = null,rs1=null; PreparedStatement
pst = null,pst1=null;

DefaultTableModel model= (DefaultTableModel)tbl_stud.getModel();



    try{
       String sql="INSERT INTO students (id_num,fname,mname,lname,course,gender,year,username,password) VALUES(?,?,?,?,?,?,?,?,?);"; 
        model.setNumRows(0);
        pst=conn.prepareStatement(sql);   
         String id=txt_idnum.getText();
        pst.setString(1,id);
        String f=txt_fname.getText();
        pst.setString(2, f);
        String m=txt_mname.getText();
        pst.setString(3, m);
        String l=txt_lname.getText();
        pst.setString(4, l);
        String crs=cmb_course.getSelectedItem().toString();
        pst.setString(5, crs);
         String gen=cmb_gender.getSelectedItem().toString();
        pst.setString(6, gen);
         String year = cmb_year.getSelectedItem().toString();
        pst.setString(7, year);
        String uname=txt_username.getText();
        pst.setString(8, uname);
        String pass=txt_password.getText();
        pst.setString(9, pass);

        pst.executeQuery(sql);


    JOptionPane.showMessageDialog(null, "Saved!","",JOptionPane.INFORMATION_MESSAGE);


    }
    catch(Exception e){
         JOptionPane.showMessageDialog(null, e,"",JOptionPane.ERROR_MESSAGE);
    }

Answer 1

您需要使用 pst.executeUpdate 而不是 pst.executeQuery