Hi friend,
import java.sql.*;
import java.math.*;
import javax.swing.*;
import javax.swing.border.*;
import java.awt.*;
import java.awt.event.*;
public class AwtDatabase extends JFrame implements ActionListener {
private JButton btnok,btnexit,btnaddnew;
private JTextField jtext1,jtext2;
private JLabel lblname,lbladd,lblmsg;
private JPanel panel1,panel2,panel3,psouth;
public AwtDatabase(){
//initializing buttons
btnok = new JButton("OK");
btnok.addActionListener(this);
btnexit = new JButton("Exit");
btnexit.addActionListener(this);
btnaddnew = new JButton("AddNew");
btnaddnew.addActionListener(this);
//initializing textfields
jtext1 = new JTextField(10);
jtext2 = new JTextField(10);
//initializing labels
lblname = new JLabel("Student Name:");
lbladd = new JLabel("Student RollNO:");
lblmsg = new JLabel("",JLabel.CENTER);
//initializing panels
panel1 = new JPanel();
panel2 = new JPanel();
panel3 = new JPanel();
psouth = new JPanel();
panel1.setLayout(new FlowLayout());
panel1.add(btnok);
panel1.add(btnexit);
panel1.add(btnaddnew);
//adding lblmsg to panel panel3
panel3.add(lblmsg);
psouth.setLayout(new GridLayout(2,1));
psouth.add(panel3);
psouth.add(panel1);
//adding label and textfields to panel panel2
panel2.setLayout(new GridLayout(3,1));
//setting line and titled border for panel panel2
panel2.setBorder(BorderFactory.createLineBorder(Color.red));
panel2.setBorder(BorderFactory.createTitledBorder("Enter Your Information!"));
panel2.add(lblname);
panel2.add(jtext1);
panel2.add(lbladd);
panel2.add(jtext2);
//adding panel to container
this.getContentPane().add(panel2,"Center");
this.getContentPane().add(psouth,"South");
this.setSize(400,300);
this.setLocation(100,200);
this.show();
}
public static void main(String args[]){
AwtDatabase ad = new AwtDatabase();
}
//event handling
public void actionPerformed(ActionEvent e){
if(e.getSource()==btnok) {
PreparedStatement pstm;
ResultSet rs;
String sql;
if((jtext1.getText().equals("")&&(jtext2.getText().equals("")))) {
lblmsg.setText("Enter your Name & RollNo.");
lblmsg.setForeground(Color.magenta);
}
else{
try{
Connection con = null;
String url = "jdbc:
mysql://192.168.10.211:3306/";;;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";
//loading the driver
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
pstm=con.prepareStatement("insert into student_detail values(?,?)");
pstm.setString(1,jtext1.getText());
pstm.setString(2,jtext2.getText());
//execute method to execute the query
pstm.executeUpdate();
lblmsg.setText("Details have been added to database");
//closing the prepared statement and connection object
pstm.close();
con.close();
}
catch(SQLException sqe) {
System.out.println("SQl error");
}
catch(ClassNotFoundException cnf) {
System.out.println("Class not found error");
}}
}
if(e.getSource()==btnaddnew) {
jtext1.setText("");
jtext2.setText("");
}
if(e.getSource()==btnexit){
System.exit(1);
}
}
}