import java.sql.*;
import javax.swing.*;
public class databaseConnection
{
public static String url,sql;
public static Connection con=null;
public static Statement stmt;
public void dbconnection()
{
try
{
url= "jdbc:odbc:information"; //database Name
String username = "system"; //Database server name
String password = "a"; //database server password
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url,username,password);
stmt=con.createStatement();
// JOptionPane.showMessageDialog(null,"Database is Connected");
}
catch(ClassNotFoundException ex)
{
JOptionPane.showMessageDialog(null, ex.getMessage());
System.out.println("Error connecting : \n "+ex.getMessage());
//exit if driver is not loaded.
System.exit(0);
}
catch(SQLException ce)
{
JOptionPane.showMessageDialog(null, ce.getMessage());
System.out.println(ce);
}
}
public static void main(String[] a) {
databaseConnection db=new databaseConnection();
db.dbconnection() ;
}
}
No comments:
Post a Comment