Jtextbox entering values into db(concerns with datatype)

[Yuta Lolap]

I have a textbox JTextbox custmobo = new Jtextbox(10); in which i am entering a mobile no.

I have column with similar in my customer table of number type(custmobnonumber(10));


using a prepared statement to fire insert query while registering a user. So code goes as follows. But it doesnt seem to work properly

package com.classes;

import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.swing.*;




@SuppressWarnings("serial")
public class RegisterNewUser extends JFrame implements ActionListener
{

	JPanel registernewuserpanel;
	 JLabel custidlbl, custFnamelbl,custLnamelbl,custMobnolbl,custAddlbl,custItemPurlbl,custDOPlbl;
	 

	 
	 JTextField custidtxt,custFnametxt,custLnametxt,custMobnotxt, custItemPurtxt, custDOPtxt,custAddtxt;
	 JButton addcustomerbtn;
	  JScrollPane sp;
		JTextArea add ;

	 JPanel p ;
	 
  RegisterNewUser()
	{	setLayout(new FlowLayout());
		  registernewuserpanel = new JPanel();
		  
		  add(registernewuserpanel);
		  
		  custidlbl = new JLabel("Customer Id:");
		 registernewuserpanel.add(custidlbl);
		 
		custidtxt= new JTextField(10);
		registernewuserpanel.add(custidtxt);

		custFnamelbl = new JLabel("First Name:");
		registernewuserpanel.add(custFnamelbl);

		custFnametxt = new JTextField(15);
		registernewuserpanel.add(custFnametxt);

		
		custLnamelbl = new JLabel("Last name:");
		registernewuserpanel.add(custLnamelbl);
		
		custLnametxt = new JTextField(15);
		registernewuserpanel.add(custLnametxt);
		
		custMobnolbl = new JLabel("Mobile No:");
		registernewuserpanel.add(custMobnolbl);
		
		custMobnotxt = new JTextField(15);
		registernewuserpanel.add(custMobnotxt);
		
		
		custAddlbl = new JLabel("Address:");
		registernewuserpanel.add(custAddlbl);
		
		
		custAddtxt = new JTextField(30);
		registernewuserpanel.add(custAddtxt);

	
		
		addcustomerbtn=new JButton("Add");
		registernewuserpanel.add(addcustomerbtn);
		addcustomerbtn.addActionListener(this);
		
		
		add =  new JTextArea();
		registernewuserpanel.add(add);
		sp=new JScrollPane(add,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
		
		


	}
	
	

	@Override
	public void actionPerformed(ActionEvent arg0) {
		String custid = custidtxt.getText();
		String custfname = custFnametxt.getText();
		String custlname = custLnametxt.getText();
		 String custmobno = custMobnotxt.getText();
		
		 
		
		
		String custadd= custAddtxt.getText();

		

		// TODO Auto-generated method stub
		try {
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection conn = DriverManager.getConnection("jdbc:odbc:XE",
				"system", "tiger");
		System.out.println("Connection Successfull");
		System.out.println(conn); 
		PreparedStatement ptmt = null;
		String q = "insert into customer(custid, custfname,custlname,custmobno,custadd) values (?,?,?,?,?)";
		ptmt = conn.prepareStatement(q);
		ptmt.setString(1,custid );
		ptmt.setString(2, custfname);

		ptmt.setString(3, custlname);
		
		ptmt.setString(4, custmobno);
		
		ptmt.setString(5, custadd);
	
		ptmt.executeQuery();
		
		
		JOptionPane.showMessageDialog(this,
				"NEw user added successfully");
		
		
		

		System.out.println("New user registered successfully.");
		
	} catch (ClassNotFoundException e1) {
		// TODO Auto-generated catch block
		e1.printStackTrace();
	} catch (SQLException e1) {
		// TODO Auto-generated catch block
		e1.printStackTrace();
		JOptionPane.showMessageDialog(this,
				"NEw user added not added! Please try again");
	}
		
	}

public static void main(String[] args) {

	
	
}
}

Ps: make an obj and call the frame because i am calling it from another one.

[Kemal Sokolovic]

Yuta Lolap wrote:I have column with similar in my customer table of number type(custmobnonumber(10));

What exactly is the type of that column in database? And what do you mean by "But it doesnt seem to work properly"?
I would also check the layout of components in your frame, this is probably not the way you want your frame to look like since some of them are not visible.

[Yuta Lolap]

Hello Kemal Sokolovic,


I got the button problem fixed. Had issues with the size of the datatype that i had used in the database table. Sizes mentioned in database and textfield were not matching. Thanks for replying anyways.

Also, i know the layout is worse. I havent worked with layouts. I want to desgin a simple registration form. But it is difficult to place them with Grid view. Can you please help me out to make it more presentable?

Thanks,
Yuta Lolap.

[Kemal Sokolovic]

I prefer GridBagLayout because of flexibility it offers. It might look difficult to catch up with at first, but as almost everything else it is a matter of excercise and experience. You should check this tutorial, work through examples provided and try to layout components in your frame accordingly. I would suggest you draw a grid on a paper and place components inside it. Once you are satisfied with a sketch, try to implement it. And of course, if you come to an issue feel free to ask.

[Yuta Lolap]

Hello Kemal Sokolovic ,

Thank you so much for your guidance and help! I am really grateful. I will definately look into the tutorial. Will surely contact you if i come across anything.

Thanks,
Yuta Lolap.