
sir i want a program of all the layout of java which have two or three button and a database connectivity

Hi Friend,
Try the following code:
import java.awt.*;
import java.sql.*;
import javax.swing.*;
import java.awt.event.*;
class LayoutExample extends JFrame{
JPanel panel,panel1,panel2;
JLabel lab1,lab2;
JTextField text1,text2;
JButton b1,b2,b3;
LayoutExample(){
panel=new JPanel();
panel1=new JPanel(new GridLayout(2,2));
panel2=new JPanel(new FlowLayout());
lab1=new JLabel("Name");
lab2=new JLabel("Address");
text1=new JTextField(20);
text2=new JTextField(20);
b1=new JButton("Add");
b2=new JButton("View");
b3=new JButton("Delete");
panel1.add(lab1);
panel1.add(text1);
panel1.add(lab2);
panel1.add(text2);
panel2.add(b1);
panel2.add(b2);
panel2.add(b3);
panel.add(panel1,BorderLayout.NORTH);
panel.add(panel2,BorderLayout.SOUTH);
add(panel);
setVisible(true);
setSize(500,150);
b1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
String v1=text1.getText();
String v2=text2.getText();
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
Statement st=con.createStatement();
int i=st.executeUpdate("insert into data(name,address) values('"+v1+"','"+v2+"')");
JOptionPane.showMessageDialog(null,"Data is inserted successfully");
}
catch(Exception ex){
}
}
});
b2.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
String v1=text1.getText();
String v2=text2.getText();
JFrame f=new JFrame();
JLabel l1=new JLabel("Your Name is : "+v1);
JLabel l2=new JLabel("Your Address is : "+v2);
l1.setBounds(20,20,200,20);
l2.setBounds(20,50,200,20);
f.setLayout(null);
f.add(l1);
f.add(l2);
f.setVisible(true);
f.setSize(300,200);
}
});
b3.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
String v1=text1.getText();
String v2=text2.getText();
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
Statement st=con.createStatement();
int i=st.executeUpdate("delete from data where name='"+v1+"' and address='"+v2+"'");
JOptionPane.showMessageDialog(null,"Data is deleted successfully");
}
catch(Exception ex){
}
}
});
}
public static void main(String[] args)
{
new LayoutExample();
}
}
Thanks
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.