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);
}
}
}

And use for MS-Access database



Step for using this example.

* go to ms-access and make a table and give it a file name student.mdb
* go to Control Panel
* click on Administrative Tools, click on ODBC(win98)
* click on ODBC
* Then , you will see a ODbc dialog box.click on UserDSn
* click on add button
* Select microsoft Access Driver(*.mdb) driver and click on finish
* give a data Source name (table name)
* Then click on Select
* Browse on the database name you have created and click it:student.mdb is a database file where all data
will be stored

* Click on OK

--------------------------------------

Read for more information.

http://www.roseindia.net/java/example/java/awt/

Thanks.

Amardeep.