java - 如何将文本框中的数据插入到Java-netbeans中的mysql数据库中

我是编程新手，我正在尝试使用netbeans IDE制作一个小型的Java swing应用程序，我设计了表单并创建了一个表。我使用以下代码将表单中的数据插入数据库，但我遇到了许多错误，请帮助我更正此代码：

import java.sql.*;
public class db
{
  static final String JDBC_DRIVER="com.mysql.jdbc.Driver";
  static final String DB_URL = "jdbc:mysql://localhost:3306/userdb";
  static final String USER="root";
  static final String PASS="toor";

  Connection conn = null;
  Statement stmt = null;
  static final String d_unit=jTextField2.getText();
  static final String d_name=jTextField3.getText();
  static final String d_dob=jDateChooser2.getText();
  //static final String d_gender="gender";
  static final String d_age=jTextField4.getText();
  static final String d_doorno=jTextField5.getText();
  static final String d_street=jTextField6.getText();
  static final String d_vc=jTextField7.getText();
  static final String d_district=jTextField8.getText();
  static final String d_pin=jTextField9.getText();
  static final String d_phone=jTextField10.getText();
  static final String d_mail=jTextField11.getText();
  static final String d_occupations=jTextField12.getText();
  try
  {
     Class.forName("com.mysql.jdbc.Driver");
     conn=DriverManager.getConnection(DB_URL,USER,PASS);
     stmt = conn.createStatement();
     stmt.executeUpdate("insert into donors (unit,name,dob,age,doorno,street,vc,district,pin,phone,mail,occupation) values('"+d_unit+"','"+d_name+"','"+d_dob+"','"+d_age+"','"+d_doorno+"','"+d_street+"','"+d_vc+"','"+d_district+"','"+d_pin+"','"+d_phone+"','"+d_mail+"','"+d_occupations+"')");
     JOptionPane.showMessageDialog(null,"Inserted Successfully!");
     }
    catch(Exception e)
    {     }

   }

最佳答案

private void btnSaveActionPerformed(java.awt.event.ActionEvent evt) {
    String itemCode = txtItemCode.getText();
    String itemName = txtItemName.getText();
    String unitPrice = txtUnitPrice.getText();
    String qty = txtQty.getText();
    String query = "insert into items values ('"+itemCode+"','"+itemName+"','"+unitPrice+"','"+qty+"')";
    System.out.println(query);


    try {
        Connection c = DBClass.getConnection();
        Statement stmt = c.createStatement();
        stmt.executeUpdate(query);
        JOptionPane.showMessageDialog(this, "Saved");
    } catch (Exception e) {
        e.printStackTrace();
    }

//DBClass类

import java.sql.Connection;
import java.sql.DriverManager;

/**
 *
 * @author Nadun
 */
public class DBClass {

    static private Connection  connection;

    public static Connection getConnection() throws Exception{
        if(connection == null){
            //JDBC
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/stock", "root", "123");
        }
        return connection;
    }

}