Not able to Inserting integer data

[Ahesanali Khanusiya]

I want insert integer data in database but i am not able to do this... i am attaching my whole application

 
package com.niit.student;

import java.awt.*;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;

public class StudentApplication implements ActionListener {
    //create all lable,textfield and declare variable

    ArrayList studentList;
    StudentDao student;
    JLabel jlbfname, jlblname, jlbmname, jlbaddress, jlbmobile, jlbgender, jlbage,
            jlb10year, jlb10per, jlb12year, jlb12per, jlbgradyear, jlbgradper;
    JTextField jtxtaddress, jtxtfname, jtxtlname, jtxtmname, jtxtmobile, jtxtage,
            jtxt10year, jtxt10per, jtxt12year, jtxt12per, jtxtgradyear, jtxtgradper, jtxtgender;
    JButton jbtsave, jbtclose;
    JComboBox jcbgender;
    JFrame jframe;
    String fname, lname, mname, gender, address, tenyear, twlyear, gradyear;
    int mobile, age, tenper, twlper, gradper;
    Container cpan;

    public static void main(String arg[]) {
        new StudentApplication();
    }

    public StudentApplication() {
        //initalise all variable
        fname = "";
        lname = "";
        mname = "";
        gender = "";
        address = "";
        tenyear = "";
        //tenper = 0;
        twlyear = "";
        //twlper = 0;
        gradyear = "";
        // gradper = 0;
        // mobile = 0;
        // age = 0;
        creatGUI();
        studentList = new ArrayList();
        try {
            student = new StudentDao();
        } catch (Exception ex) {
            System.out.println("Exception in Student Dao" + ex);
        }
    }

    public void creatGUI() {
        jframe = new JFrame("Student Personal Detail");
        cpan = jframe.getContentPane();
        cpan.setLayout(new GridBagLayout());
        arrangeComponent();
        jframe.setSize(600, 600);
        jframe.setResizable(false);
        jframe.setVisible(true);
        jframe.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    }

    //Arrange Component In container and add action listener in Jbutton
    public void arrangeComponent() {
        jlbfname = new JLabel("First Name");
        jlbmname = new JLabel("Middle Name");
        jlblname = new JLabel("Last Name");
        jlbaddress = new JLabel("Address");
        jlbmobile = new JLabel("Mobile No");
        jlbgender = new JLabel("Gender");
        jlbage = new JLabel("Age");
        jlb10year = new JLabel("Passing Year Of 10th");
        jlb10per = new JLabel("Percentage In 10th");
        jlb12year = new JLabel("Passing Year Of 12th");
        jlb12per = new JLabel("Percentage In 12th");
        jlbgradyear = new JLabel("Passing Graduation Year");
        jlbgradper = new JLabel("Aggrigate In Graduation");

        jtxtfname = new JTextField(20);
        jtxtmname = new JTextField(20);
        jtxtlname = new JTextField(20);
        jtxtaddress = new JTextField(20);
        jtxtmobile = new JTextField(20);
        jtxtgender = new JTextField(10);
        jtxtage = new JTextField(20);
        jtxt10year = new JTextField(20);
        jtxt10per = new JTextField(20);
        jtxt12year = new JTextField(20);
        jtxt12per = new JTextField(20);
        jtxtgradyear = new JTextField(20);
        jtxtgradper = new JTextField(20);

        jbtsave = new JButton("Save Student");
        jbtclose = new JButton("Close");

      i have added all component in Jframe

    }

    public void actionPerformed(ActionEvent e) {
        if (e.getSource() == jbtsave) {
            saveStudent();

        } else if (e.getSource() == jbtclose) {
            System.exit(0);
        }
    }

    //insert student record into database
    public void saveStudent() {
        fname = jtxtfname.getText();
        mname = jtxtmname.getText();
        lname = jtxtlname.getText();
        address = jtxtaddress.getText();
        gender = jtxtgender.getText();
        tenyear = jtxt10year.getText();
        twlyear = jtxt12year.getText();
        gradyear = jtxtgradyear.getText();
        try {
            mobile = Integer.parseInt("" + jtxtmobile.getText());
            age = Integer.parseInt("" + jtxtage.getText());
            tenper = Integer.parseInt("" + jtxt10per.getText());
            twlper = Integer.parseInt("" + jtxt12per.getText());
            gradper = Integer.parseInt("" + jtxtgradper.getText());
        } catch (Exception e) {
            System.out.println("Exception in main method" + e);
        }
        if (fname.equals("")) {
            JOptionPane.showMessageDialog(null, "Enter Student Name");
        } else {
            StudentBean studentbn = new StudentBean(
                      fname, mname, lname, address, gender, mobile, age, tenyear, tenper, twlyear, twlper, gradyear, gradper);
            try {
                student.saveStudent(studentbn);
            } catch (Exception ex) {
                System.out.println("Exception caught in save student method in main" + ex);
            }
            JOptionPane.showMessageDialog(null, "Student Saved");
        }
    }
}

   

another database connectivity file is

   
package com.niit.student;

import java.util.ArrayList;
import java.sql.*;

public class StudentDao {

    private ArrayList student;
    private Connection con;

    public StudentDao() throws Exception {
        student = new ArrayList();
        getConnection();
    }

    public Connection getConnection() throws Exception {

        Class.forName("com.mysql.jdbc.Driver");
        con = DriverManager.getConnection("jdbc:mysql:///student", "root", "root");
        return con;
    }

    public void saveStudent(StudentBean student) throws Exception {
        String query = "insert into studentdetails(fname,mname,lname,address,mobile,age,gender,tenyear,tenper,twlyear,twlper,gradyear,gradper) values ('" + 
                student.getFname() + "','" +
                student.getMname() + "','" + student.getLname() + "','" + student.getAddress() + "','" + student.getMobile() + "','" +
                student.getAge() + "','" + student.getGender() + "','" + student.getTenyear() + "','" + student.getTenper() + "','" +
                student.getTwlyear() + "','" + student.getTwlper() + "','" + student.getGradyear() + "','" + student.getGradper() + "')";
        Statement s = con.createStatement();
        s.executeUpdate(query);
    }
}

 

[Darryl Burke]

And what makes that a Swing / AWT / SWT / JFace question?

[Tom Reilly]

A few suggestions:
1. In the code, print the query string and try running that from mysql. If you don't realize the error from doing that:
2. Post the query string
3. Post the error you are getting
4. Post the database table format
5. A guess: strings need to be wrapped in quotes. Numbers do not

[Rob Spoor]

I'll move this to our JDBC forum since the problem is more likely database related.

[Ahesanali Khanusiya]

query string is:

  String query = "insert into studentdetails(fname,mname,lname,address,mobile,age,gender,tenyear,tenper,twlyear,twlper,gradyear,gradper) values ('" +   
                 student.getFname() + "','" +  
                 student.getMname() + "','" + student.getLname() + "','" + student.getAddress() + "','" + student.getMobile() + "','" +  
                 student.getAge() + "','" + student.getGender() + "','" + student.getTenyear() + "','" + student.getTenper() + "','" +  
                 student.getTwlyear() + "','" + student.getTwlper() + "','" + student.getGradyear() + "','" + student.getGradper() + "')";     

table format is:

  CREATE TABLE `studentdetails` (
  `studentDetailsId` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fname` varchar(25) NOT NULL,
  `mname` varchar(25) NOT NULL,
  `lname` varchar(25) NOT NULL,
  `address` varchar(45) NOT NULL,
  `mobile` int(10) unsigned NOT NULL,
  `age` int(10) unsigned NOT NULL,
  `gender` varchar(15) NOT NULL,
  `tenyear` varchar(15) NOT NULL,
  `tenper` int(10) unsigned NOT NULL,
  `twlyear` varchar(15) NOT NULL,
  `twlper` int(10) unsigned NOT NULL,
  `gradyear` varchar(15) NOT NULL,
  `gradper` int(10) unsigned NOT NULL,
  PRIMARY KEY (`studentDetailsId`)
)  

Exception is: java.lang.NumberFormatException: For input string: "123456789"

[Tom Reilly]

I meant adding System.out.println(query) and post the results of that statement. What were the results of my first suggestion? Also, please post the full error that points at the offending line of code.

[Rob Spoor]

Why are those quotes part of the number you're parsing? You're not parsing 123456789 into an int but "123456789". The parsing can't handle those quotes.

[Ahesanali Khanusiya]

I am not passing that values but I am insert that value in my swing component of text field by user its not static variable.

[Gurunath Kale]

1. Convert the age and all integer type text value into 'int'
for example...

 
      String data = textfield.getText();
	    int age = 0;
	    if(data != null){
	    	try{
	      age= Integer.parseInt(data);
	    	}catch(NumberFormatException e){ e.printStackTrace();}
	    }

2. In query remove ''' Quotes around the int type datatype