QuestionAsk Questions?
kameswarasunilkumar
insert data into mysql databse using swing
1 Answer(s) 6 months and 26 days ago
Posted in : Java Beginners
1 Answer(s) 6 months and 26 days ago
Posted in : Java Beginners
Blockquote
hi, here is my code, i want code for store data into mysql database when click on submit button from access data from this form, please provide code,
import java.awt.*; import java.awt.event.*; import javax.swing.*; import javax.swing.event.*; import java.util.*; import java.util.Calendar; import java.text.SimpleDateFormat; import javax.swing.BorderFactory; import javax.swing.border.Border; import javax.swing.border.TitledBorder; import javax.swing.text.*; import javax.swing.JOptionPane; import java.text.*; import java.util.Date; import javax.swing.JTextField; class start extends JFrame implements ActionListener { JButton bback,bexit,bsub; JLabel linfo,linfo1,linfo2,linfo3,linfo4,linfo5,linfo6,linfo7,linfo8,linfo9,linfo10,linfo11,linfo12,linfo13,linfo14,linfo15,linfo16,linfo17,linfo18,linfo19,linfo20,linfo21; JTextField t1,t2,t3,t4,t5,t6,t7,t8,t9; JFormattedTextField tft3; JList lst1; JComboBox box1,box2,box3,box4,box5,box6,box7,box8,box9,box10,box11,box12; start() { super("GREENVALLYINN"); setSize(1024,768); setVisible(true);
setLayout(null);
Container c=getContentPane();
c.setBackground(Color.green);
c.setLayout(null);
Calendar cal =Calendar.getInstance();
SimpleDateFormat sdf=new SimpleDateFormat("dd-MM-yyyy");
SimpleDateFormat sdft=new SimpleDateFormat("HH:mm:ss");
Date date=new Date();
String dt=sdf.format(date);
String ti=sdft.format(date);
linfo=new JLabel("WELCOME TO GREENVALLY IN",JLabel.CENTER);
linfo.setBounds(400,5,500,20);
linfo.setFont(new Font("Arial",Font.BOLD,20));
Border border = BorderFactory.createLineBorder(Color.red,3);
linfo.setBorder(border);
c.add(linfo);
linfo1=new JLabel("Date");
linfo1.setBounds(10,30,30,30);
c.add(linfo1);
t1=new JTextField(20);
t1.setBounds(35,35,70,20);
t1.setMaximumSize(t1.getPreferredSize());
t1.setText(dt);
c.add(t1);
linfo2=new JLabel("CHECK IN TIME",JLabel.CENTER);
linfo2.setBounds(512,30,100,30);
c.add(linfo2);
t2=new JTextField(20);
t2.setBounds(610,35,70,20);
t2.setMaximumSize(t1.getPreferredSize());
t2.setText(ti);
c.add(t2);
linfo3=new JLabel("RECEIPT NO",JLabel.RIGHT);
linfo3.setBounds(900,30,100,30);
c.add(linfo3);
t3=new JTextField(20);
t3.setBounds(1000,35,150,20);
t3.setMaximumSize(t1.getPreferredSize());
c.add(t3);
linfo4=new JLabel("NAME");
linfo4.setBounds(10,60,100,30);
c.add(linfo4);
t4=new JTextField(30);
t4.setBounds(45,65,200,20);
t4.setMaximumSize(t1.getPreferredSize());
t4.setFocusable(true);
c.add(t4);
linfo5=new JLabel("FROM");
linfo5.setBounds(512,60,100,30);
c.add(linfo5);
box1=new JComboBox();
box1.addItem("VISAKHAPATNAM");
box1.addItem("ANAKAPALLI");
box1.addItem("GAJUWAKA");
box1.addItem("S.KOTA");
box1.addItem("PADERU");
box1.addItem("CHODAVARAM");
box1.addItem("OTHER");
box1.setBounds(600,60,200,30);
c.add(box1);
linfo6=new JLabel("ADDRESS");
linfo6.setBounds(900,60,100,30);
c.add(linfo6);
t5=new JTextField(30);
t5.setBounds(965,65,200,20);
t5.setMaximumSize(t5.getPreferredSize());
c.add(t5);
linfo7=new JLabel("CONTACT NO");
linfo7.setBounds(10,100,100,30);
c.add(linfo7);
t6=new JTextField(10);
t6.setBounds(85,105,100,20);
t6.setMinimumSize(t6.getPreferredSize());
c.add(t6);
linfo8=new JLabel("NO OF PERSONS");
linfo8.setBounds(512,100,100,30);
c.add(linfo8);
box2=new JComboBox();
box2.addItem("0");
box2.addItem("1");
box2.addItem("2");
box2.addItem("3");
box2.addItem("4");
box2.addItem("5");
box2.addItem("6");
box2.addItem("7");
box2.addItem("8");
box2.addItem("9");
box2.setBounds(620,100,50,30);
c.add(box2);
linfo9=new JLabel("M");
linfo9.setBounds(750,150,100,30);
c.add(linfo9);
box3=new JComboBox();
box3.addItem("0");
box3.addItem("1");
box3.addItem("2");
box3.addItem("3");
box3.addItem("4");
box3.addItem("5");
box3.addItem("6");
box3.addItem("7");
box3.addItem("8");
box3.addItem("9");
box3.setBounds(780,150,50,30);
c.add(box3);
linfo10=new JLabel("F");
linfo10.setBounds(870,150,80,30);
c.add(linfo10);
box4=new JComboBox();
box4.addItem("0");
box4.addItem("1");
box4.addItem("2");
box4.addItem("3");
box4.addItem("4");
box4.addItem("5");
box4.addItem("6");
box4.addItem("7");
box4.addItem("8");
box4.addItem("9");
box4.setBounds(900,150,50,30);
c.add(box4);
linfo11=new JLabel("C");
linfo11.setBounds(970,150,80,30);
c.add(linfo11);
box5=new JComboBox();
box5.addItem("0");
box5.addItem("1");
box5.addItem("2");
box5.addItem("3");
box5.addItem("4");
box5.addItem("5");
box5.addItem("6");
box5.addItem("7");
box5.addItem("8");
box5.addItem("9");
box5.setBounds(1000,150,50,30);
c.add(box5);
linfo12=new JLabel("NO OF ROOMS");
linfo12.setBounds(2,150,100,30);
c.add(linfo12);
box6=new JComboBox();
box6.addItem("0");
box6.addItem("1");
box6.addItem("2");
box6.addItem("3");
box6.addItem("4");
box6.setBounds(85,150,50,30);
c.add(box6);
linfo13=new JLabel("AC/NONAC");
linfo13.setBounds(512,150,100,30);
c.add(linfo13);
box7=new JComboBox();
box7.addItem("AC");
box7.addItem("NONAC");
box7.setBounds(600,150,80,30);
c.add(box7);
linfo14=new JLabel("ROOM NUMBER ALLOTED");
linfo14.setBounds(10,200,150,30);
c.add(linfo14);
box12=new JComboBox();
box12.addItem("....");
box12.addItem("1");
box12.addItem("2");
box12.addItem("3");
box12.addItem("4");
box12.addItem("5");
box12.addItem("6");
box12.addItem("7");
box12.addItem("8");
box12.addItem("9");
box12.setBounds(150,200,50,30);
c.add(box12);
linfo15=new JLabel("PURPOSE");
linfo15.setBounds(512,200,150,30);
c.add(linfo15);
box8=new JComboBox();
box8.addItem("SITE SEEING");
box8.addItem("Official");
box8.addItem("personal");
box8.addItem("OTHER");
box8.setBounds(600,200,80,30);
c.add(box8);
linfo16=new JLabel("EXPECTED DAYS");
linfo16.setBounds(900,200,150,30);
c.add(linfo16);
box9=new JComboBox();
box9.addItem("1");
box9.addItem("2");
box9.addItem("3");
box9.addItem("4");
box9.addItem("5");
box9.addItem("6");
box9.addItem("7");
box9.addItem("8");
box9.addItem("9");
box9.setBounds(1000,200,50,30);
c.add(box9);
linfo17=new JLabel("VEHICAL TYPE");
linfo17.setBounds(512,240,150,30);
c.add(linfo17);
box10=new JComboBox();
box10.addItem("TWO WHEELER");
box10.addItem("AUTO");
box10.addItem("OWN FOURWHEELER");
box10.addItem("OTHER");
box10.setBounds(610,240,100,30);
c.add(box10);
linfo18=new JLabel("VEHICAL NO");
linfo18.setBounds(900,240,100,30);
c.add(linfo18);
t7=new JTextField(10);
t7.setBounds(1000,250,100,20);
t7.setMaximumSize(t7.getPreferredSize());
c.add(t7);
linfo19=new JLabel("OWNER/DRIVER NAME");
linfo19.setBounds(900,280,150,30);
c.add(linfo19);
t8=new JTextField(10);
t8.setBounds(1055,290,100,30);
t8.setMaximumSize(t8.getPreferredSize());
c.add(t8);
linfo20=new JLabel("EXPENDITURE DETAILS");
linfo20.setBounds(512,300,150,30);
c.add(linfo20);
box11=new JComboBox();
box11.addItem("ADVANCES");
box11.addItem("DOBI");
box11.addItem("CURRENT BILL");
box11.addItem("TELEPHONE BILL");
box11.addItem("ROOM FRESHNERS");
box11.addItem("POOJA");
box11.addItem("DIESEL");
box11.addItem("CABEL BILL");
box11.addItem("REPAIRS");
box11.addItem("OTHERS");
box11.setBounds(700,300,100,30);
c.add(box11);
linfo21=new JLabel("AMOUNT");
linfo21.setBounds(1000,350,150,30);
c.add(linfo21);
t9=new JTextField(10);
t9.setBounds(1000,370,100,30);
t9.setMaximumSize(t9.getPreferredSize());
c.add(t9);
bback=new JButton("BACK" ,new ImageIcon("IMAGESBUTTTONS/buttons_back.png"));
bback.setBounds(230,515,120,30);
add(bback);
bsub=new JButton("",new ImageIcon("IMAGESBUTTTONS/submit.jpg"));
bsub.setBounds(512,515,100,30);
add(bsub);
bexit=new JButton("" ,new ImageIcon("IMAGESBUTTTONS/btnCloseRed.gif"));
bexit.setBounds(730,515,80,40);
add(bexit);
t4.addActionListener(this);
t5.addActionListener(this);
bsub.addActionListener(new sub());
bback.addActionListener(new back());
bexit.addActionListener(new exit());
}
public void actionPerformed(ActionEvent ae)
{
}
class back implements ActionListener
{
public void actionPerformed(ActionEvent ae)
{
}
}
class sub implements ActionListener
{
public void actionPerformed(ActionEvent ae)
{
//new JDBCNew();
new GVPdataInsert();
setVisible(false);
}
}
class exit implements ActionListener
{
public void actionPerformed(ActionEvent ae)
{
System.exit(0);
}
}
}
**
**this is insert data class***
*
import java.sql.*; import java.util.*; import java.awt.*; import javax.swing.*;
public class GVPdataInsert {
public Connection con = null;
public PreparedStatement pstmt = null;
public ResultSet rs = null;
public GVPdataInsert() {
try{
JB j=new JB();
Connection con=DBUtil.getConn();
System.out.print("connection getting");
pstmt=con.prepareStatement("insert into gvpdata values(?,?,?,?,?,?,?,?,?,?,?,?,?)");
System.out.println("preapared Statement created");
pstmt.setString(1,j.date);
pstmt.setInt(2,j.receipt_no);
pstmt.setString(3,j.name);
pstmt.setString(4,j.from_address);
pstmt.setInt(5,j.contact_no);
pstmt.setInt(6,j.no_of_persons);
pstmt.setInt(7,j.males);
pstmt.setInt(8,j.females);
pstmt.setInt(9,j.child);
pstmt.setInt(10,j.no_of_rooms);
pstmt.setString(11,j.room_type);
pstmt.setInt(12,j.allotedroom_no);
pstmt.setDouble(13,j.amount);
System.out.println("set values");
pstmt.executeUpdate();
System.out.println("excuted");
con.commit();
}catch(Exception e){
e.printStackTrace();
}
}
public static void main(String[] args) {
System.out.println("Success");
}
}
//note: please send reply code for me...i have urgent requirement..
thnks & Regards, SUNIL
Blockquote
View Answers
November 24, 2012 at 10:24 AM
Here is a code that inserts form data to database using java swing.
import javax.swing.*;
import java.awt.*;
import java.io.*;
import java.awt.event.*;
import java.sql.*;
class Form extends JFrame
{
JButton ADD;
JPanel panel;
JLabel label1,label2,label3,label4,label5;
final JTextField text1,text2,text3,text4,text5;
Form(){
label1 = new JLabel();
label1.setText("UserID:");
text1 = new JTextField(20);
label2 = new JLabel();
label2.setText("First Name:");
text2 = new JTextField(20);
label3 = new JLabel();
label3.setText("Last Name:");
text3 = new JTextField(20);
label4 = new JLabel();
label4.setText("ADDRESS:");
text4 = new JTextField(20);
label5 = new JLabel();
label5.setText("Email:");
text5 = new JTextField(20);
ADD=new JButton("ADD");
panel=new JPanel(new GridLayout(6,2));
panel.add(label1);
panel.add(text1);
panel.add(label2);
panel.add(text2);
panel.add(label3);
panel.add(text3);
panel.add(label4);
panel.add(text4);
panel.add(label5);
panel.add(text5);
panel.add(ADD);
add(panel,BorderLayout.CENTER);
setTitle("FORM");
ADD.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae){
String value1=text1.getText();
String value2=text2.getText();
String value3=text3.getText();
String value4=text4.getText();
String value5=text5.getText();
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root" );
Statement st=conn.createStatement();
st.executeUpdate("insert into data(id,fname,lname,address,email) values('"+value1+"','"+value2+"','"+value3+"','"+value4+"','"+value5+"')");
JOptionPane.showMessageDialog(null,"Inserted Successfully!");
}
catch(Exception e){}
}
});
}
}
class FormDemo
{
public static void main(String arg[])
{
try
{
Form frame=new Form();
frame.setSize(300,300);
frame.setVisible(true);
}
catch(Exception e){
}
}
}
Related Pages:
