如何将数据行从我的学生表复制到另一个表（学生记录）？

Question

我有一个使用java的登录系统，我的系统还有最后一个问题。

当我仅在JTextField中键入并登录学生的学生ID号时，它将在文本字段中显示他或她的名字和姓氏。这是我的学生登录系统。

我的问题是，当我登录他或她的学号时，我想复制学生的数据，如学号、名字、中间名、姓氏，并插入我的PMA学生记录表。

Class.forName("com.mysql.jdbc.Driver");
                Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/studentdatabase","root","");

                String student_id = txtStudent_ID.getText();
                String sql = "INSERT INTO 'studentrecord' (stud_id, first_name, middle_name, last_name) "
                        + "SELECT firstname, middlename, lastname FROM 'student' WHERE student_id = '" + student_id + "' ";

                if (student_id.length() > 0) {
                    Statement st = conn.prepareStatement(sql);
                    ResultSet rs = st.executeQuery(sql);
                    if (student_id.length() > 0) {
            if (rs.next()) {
                    String firstname = rs.getString(3);
                    String lastname = rs.getString(5);

                    txtFirstName.setText(firstname);
                    txtLastName.setText(lastname);

                    JOptionPane.showMessageDialog(null, "Logged in", "Success",
                                JOptionPane.INFORMATION_MESSAGE);
            } else {
                    JOptionPane.showMessageDialog(null, "Sorry!, No data found for this ID", "Student ID",
                                JOptionPane.ERROR_MESSAGE);

                    JOptionPane.showMessageDialog(null, "Enter a Valid ID", "Student ID Information",
                                JOptionPane.INFORMATION_MESSAGE);

                        txtStudent_ID.setText("");

            }
                }
                }
        } catch (Exception ex) {

                JOptionPane.showMessageDialog(null, "SQL Syntax should be reviewed", "Database",
                        JOptionPane.ERROR_MESSAGE);


        }

它会有一个错误，它说“SQL语法应该被审查”需要帮助。

Answer 1

尝试如下转义”

"INSERT INTO \'studentrecord\' (stud_id, first_name, middle_name, last_name) "
            + "SELECT firstname, middlename, lastname FROM \'student\' WHERE student_id = \'"+ student_id + "\' ";

Answer 2

我不懂java，下面是一个有效的MySQL查询示例：

INSERT INTO studentrecord 
(first_name, middle_name, last_name)
SELECT firstname, middlename, lastname 
  FROM student WHERE student_id = 'student_id' 

或者

INSERT INTO studentrecord 
(stud_id,first_name, middle_name, last_name)
SELECT stud_id,firstname, middlename, lastname 
  FROM student WHERE student_id = 'student_id' 

（事实上stud_id和student_id是不同的，只有你知道如何解决！）