使用Eclipse将数据添加到MySQL数据库中

Question

我尝试制作一个简单的编程，以允许为我的作业添加，更新，删除和查看学生的数据。我已经坚持添加零件。为了将数据插入数据库的正确语法 /代码是什么？

我正在使用Eclipse IDE软件和XAMPP进行此编程。

import java.awt.*;
import javax.swing.*; 
import java.awt.event.*;
import java.sql.*;
import java.sql.Connection;
import java.sql.PreparedStatement;

public class PracticalExercise2 extends JFrame implements ActionListener{

    Connection      con;
    Statement       stmt;
    JLabel          lblname, lblmatricnumber, lblproject,lbltajuk;
    JTextField      txtname, txtmatricnumber , txtproject;
    JButton         btntest,btnadd,btnupdate,btndelete,btnview;
    String          user,pass;
    ResultSet       rs;
    JTabbedPane     myTab;
    JPanel          pnladd,pnlupdate,pnldelete,pnlview;
    
    public PracticalExercise2() {
        setLayout(null);
        setSize(400,400);
        setTitle("Registration Form using JTabbedPane");
        setVisible(true);
        setLocationRelativeTo(null);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        
        //GUI SETTING FOR FORM
        lbltajuk = new JLabel("Registration Form");
        lbltajuk.setBounds(10, 20, 350, 50);
        lbltajuk.setFont(new Font("Arial",Font.BOLD,32));
        lbltajuk.setForeground(Color.BLUE);
        add(lbltajuk);
        
        //JTabbedPane is also a panel
        myTab = new JTabbedPane();
        myTab.setBounds(20,70,350,200);
        add(myTab);
        
        pnladd      = new JPanel();
        pnlupdate   = new JPanel();
        pnldelete   = new JPanel();
        pnlview     = new JPanel();
        
        //Create and add Tab
        myTab.addTab("Add Data", pnladd);
        myTab.addTab("Update Data", pnlupdate);
        myTab.addTab("Delete Data", pnldelete);
        myTab.addTab("View Data", pnlview);
        
        btntest = new JButton("Test Connection");
        btntest.setBounds(120, 300, 150, 30);
        add(btntest);
        
        btntest.addActionListener(this);
        
        add();
    }
    
    
    public static void main(String[] args) {
        
        new PracticalExercise2();
    }

    void add()
    {
        pnladd.setLayout(null);
        
        lblname = new JLabel("Nama :");
        lblname.setBounds(20,20,100,30);
        pnladd.add(lblname);
        
        lblmatricnumber = new JLabel("No Matrik :");
        lblmatricnumber.setBounds(20,60,100,30);
        pnladd.add(lblmatricnumber);
        
        lblproject = new JLabel("Projek :");
        lblproject.setBounds(20,100,100,30);
        pnladd.add(lblproject);
        
        txtname = new JTextField();
        txtname.setBounds(110,20,200,30);
        pnladd.add(txtname);
        
        txtmatricnumber = new JTextField();
        txtmatricnumber.setBounds(110,60,200,30);
        pnladd.add(txtmatricnumber);
        
        txtproject = new JTextField();
        txtproject.setBounds(110,100,200,30);
        pnladd.add(txtproject);
        
        btnadd = new JButton("Add Data");
        btnadd.setBounds(120, 140, 100, 30);
        pnladd.add(btnadd);
            
        btnadd.addActionListener(this);
    }
    
    public void actionPerformed(ActionEvent e) {
        
        if (e.getSource() == btntest)
        {
            // 1. load driver
            
            try
            {
                Class.forName("com.mysql.jdbc.Driver");
    
            }
            catch (ClassNotFoundException x)
            {
                JOptionPane.showMessageDialog(null, "mySQL Driver cannot connect.");
            }
            
            // 2. create/open connection
            try {
                
                //testing the connection to database.
                con = DriverManager.getConnection("jdbc:mysql://localhost:3306/practicaltask2", "root", "");    
                
                JOptionPane.showMessageDialog(null, "No connection error.");
                
                
            } catch (SQLException y) {
                
                JOptionPane.showMessageDialog(null, "Connection error.");
            }
                
        }
        
        if(e.getSource() == btnadd)
        {
            String name , matric , project;
            name    = txtname.getText();
            matric  = txtmatricnumber.getText();
            project = txtproject.getText();
            
            try {
                PreparedStatement stmnt = con.prepareStatement("insert into pelajar(NULL,nama,nomatrik,projek)values(NULL,?,?,?)", Statement.RETURN_GENERATED_KEYS);
                ((PreparedStatement) stmt).setString(2,name);
                ((PreparedStatement) stmt).setString(3,matric);
                ((PreparedStatement) stmt).setString(4,project);
                
                
                JOptionPane.showMessageDialog(null, "Record Added Successfuly");
                
                txtname.setText("");
                txtmatricnumber.setText("");
                txtproject.setText("");
                
            
            }
            catch (Exception a)
            {
                JOptionPane.showMessageDialog(null, "Failed to add data");
            }
        }

    }
}