Elegant

import java.sql.*;
import oracle.jdbc.dbaccess.*; // connect to oracle db to load oracle driver

// Connect to ANY Database USING DSN
// ————————————
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:testDSN";
String userid = "";
String password = "";

Class.forName( driver );
Connection connection = DriverManager.getConnection( url, userid, password );

// Connect to the MS Access Database WITHOUT using DSN
// ——————————————————-
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Database.mdb";
String userid = "";
String password = "";

Class.forName( driver );
Connection connection = DriverManager.getConnection( url, userid, password );

// Connect to the ORACLE Databa WITHOUT using DSN
// —————————————————
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:oci8:@utilpack";
String userid = "username";
String password = "*********";

Class.forName( driver );
Connection connection = DriverManager.getConnection( url, userid, password );

// Connect to the SQL Server Database WITHOUT using DSN
// ——————————————————–
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:DRIVER=SQL Server;Server=IVRS;Database=ISS_SERVICES;";
String userid = "username";
String password = "********";

Class.forName( driver );
Connection connection = DriverManager.getConnection( url, userid, password );

import java.sql.*;

public void actionPerformed(ActionEvent ae)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null, e.getMessage(), "Error", JOptionPane.WARNING_MESSAGE);
}

if(ae.getSource()==btnSelect)
{
try
{
String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Employee/Employee.mdb";
String userid = "";
String password = "";
Connection cn = DriverManager.getConnection( url, userid, password );
Statement st = cn.createStatement();
String sql = "Select * from Employee_sus where empslno = "+ Integer.parseInt(txtslno.getText());
ResultSet rs = st.executeQuery(sql);
int slno = Integer.parseInt(txtslno.getText());
rs.next();
txtslno.setText(String.valueOf(slno));
txtname.setText(rs.getString("empname"));
txtjob.setText(rs.getString("empjob"));
rs.close();
cn.close();
}
catch(Exception af)
{
JOptionPane.showMessageDialog(null, af.getMessage(), "Find Error", JOptionPane.WARNING_MESSAGE);
}
}

if(ae.getSource()==btnInsert)
{
try
{
String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Employee/Employee.mdb";
String userid = "";
String password = "";
Connection cn = DriverManager.getConnection( url, userid, password );
String sql = "insert into employee_sus values(?,?,?)";
PreparedStatement ps = cn.prepareStatement(sql);
ps.setInt(1,Integer.parseInt(txtslno.getText()));
ps.setString(2,txtname.getText());
ps.setString(3,txtjob.getText());
ps.executeUpdate();
ps.close();
cn.close();
textTrap(false);
btnsave.setEnabled(false);
btndelete.setEnabled(false);
}
catch(Exception e2)
{
JOptionPane.showMessageDialog(null, e2.getMessage(), "Save Error", JOptionPane.WARNING_MESSAGE);
}     }     }