how to insert data from textboxes into mysql database in java-netbeans -

i new programming , trying make small java swing application using netbeans ide , have designed form , created table used following code insert data database form getting many errors please me correct code:

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 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 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;     }  }