Java and MS access

[Manyamanas]

Hi,

I have used Java with Oracle but I have never used it with MS access. Can anyone help me in connecting Java with MS access?

[Ashif Shadab]

You can get help by this example:-
import java.sql.*;
import java.math.*;
import javax.swing.*;
import javax.swing.border.*;
import java.awt.*;
import java.awt.event.*;

/* author: aseem shrestha */
/* database connectivity with MS-Access is done by creating
DataSourceName(dsn) in this example*/
/* Steps to use this example:
* go to ms-access and make a table called "student_base" and give it a
file name student_base.mdb
* 1. Go to Control Panel
2. Click on Administrative Tools(windows 2000/xp), Click on
ODBC(win98)
3. click on ODBC
4. Then , you will see a ODBC dialog box. Click on UserDSn
5. Click on Add Button
6. Select Microsoft Access Driver(*.mdb) driver and click on finish
7. Give a Data Source Name : student_base
8. Then Click on Select
9. Browse on the database name you have created and click
it:student_base.mdb is a database file where all data
will be stored
10. Click on OK.
Once the DSN is created, you can do this example*/



public class AddNewStudent extends JFrame implements ActionListener {

private JButton btnok,btnexit,btnaddnew; //buttons
private JTextField tf1,tf2;//textfields
private JLabel lblname,lbladd,lblmsg; //labels

private JPanel p1,p2,p3,psouth; //panels


public AddNewStudent() //constructor
{
//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
tf1 = new JTextField(12);
tf2 = new JTextField(12);
//initializing labels

lblname = new JLabel("Name:");
lbladd = new JLabel("Address:");
lblmsg = new JLabel("",JLabel.CENTER);

//initializing panels
p1 = new JPanel();
p2 = new JPanel();
p3 = new JPanel();
psouth = new JPanel();

//adding buttons and label to panel p1
//setting flowlayout
p1.setLayout(new FlowLayout());

p1.add(btnok);
p1.add(btnexit);
p1.add(btnaddnew);
//adding lblmsg to panel p3
p3.add(lblmsg);

//adding both the panels to new panel,psouth
//settin layout 2:1
psouth.setLayout(new GridLayout(2,1));
psouth.add(p3);
psouth.add(p1);


//adding label and textfields to panel p2
p2.setLayout(new GridLayout(3,1));
//setting line and titled border for panel p2
p2.setBorder(BorderFactory.createLineBorder(Color.red));
p2.setBorder(BorderFactory.createTitledBorder("Enter Your
Details"));
p2.add(lblname);
p2.add(tf1);
p2.add(lbladd);
p2.add(tf2);

//adding panel to container
this.getContentPane().add(p2,"Center");
this.getContentPane().add(psouth,"South");

this.setSize(300,300);
this.setLocation(100,200);
this.show();


}
public static void main(String args[])
{
AddNewStudent ad = new AddNewStudent();
}

//event handling
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==btnok)
{
PreparedStatement pstm;
ResultSet rs;
String sql;
//if no entries has been made and hit ok button throw an error
//you can do this step using try clause as well
if((tf1.getText().equals("")&&(tf2.getText().equals(""))))
{
lblmsg.setText("Enter your details ");
lblmsg.setForeground(Color.magenta);
}


else
{

try
{
//loading the driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

//connection object created using DriverManager class
//student_base is the name of the database
Connection connect =
DriverManager.getConnection("jdbcdbc:student_base");

//creating prepared statement object pstm so that query can be
sent to database
pstm=connect.prepareStatement("insert into student_base
values(?,?)");
pstm.setString(1,tf1.getText());
pstm.setString(2,tf2.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();
connect.close();
}
catch(SQLException sqe)
{
System.out.println("SQl error");
}
catch(ClassNotFoundException cnf)
{
System.out.println("Class not found error");
}
}
}
//upon clickin button addnew , your textfield will be empty to
enter
next record
if(e.getSource()==btnaddnew)
{
tf1.setText("");
tf2.setText("");
}

if(e.getSource()==btnexit)
{
System.exit(1);
}
}
}