Answer
# 1 |
Here is d coding for JDBC Connectivity to retrieve employee
details
I hv provided comments also so u can understand it better
--------------------*-----------------------------
/**
*
* @author KIRAN
*/
import java.sql.*;
import java.io.*;
public class JDBCConnection
{
public static void main(String args[])
{
Connection conn;
Statement stmt;
ResultSet rs;
try
{
//loads JDBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception e)
{
e.printStackTrace();
}
try
{
//set connection string
conn=DriverManager.getConnection("jdbc:odbc:employeedsn");//here
loads dsn named empdsn
//creates statement
stmt=conn.createStatement();
//to get records from database using
resultset
rs=stmt.executeQuery("select * from emp");//for dis 1st
create emp named table
System.out.println("EId
Ename DOB Dept
Salary\n");
while(rs.next())//moves cursor to the next record until
it reaches d last record
{
System.out.println(+rs.getInt(1)+"
"+rs.getString(2)+" "+rs.getString(3)+"
"+rs.getString(4)+" "+rs.getInt(5));
}
stmt.close();
conn.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
Note:
-create emp table 1st wid attributes eid,ename,dob,dept,n
salary
-to add dsn(data source name)go to control
panel->Administrative Tools->Data Sources (ODBC) then one
small window will get opend..
-click on System DSN tab->Add->n select "Microsoft Access
Drive(*.mdb)"->finish->type Data Source Name(as i hv typed
in program "employeedsn" if u dnt want to change that dsn
which is written in d line
conn=DriverManager.getConnection("jdbc:odbc:employeedsn")
-you can give ne name tht u want instead of employeedsn...u
only need to provide d same name in Data Source Name
-next is no need to provide nethng for description
-then click on->select(to select database in *.mdb form)
---to select database table select drive on which u hv
saved ur database table n select that table by going to d
folder where u hv stored it by going to an appropriate directory
----if u select correct directory,table name will b
displyed in left hand side list box which then u need to
select n click on "OK" n again click on "OK"
----Your DSN will be displyed in System Data Sources List
---click on Ok n once you done this run the program
|
| Kiran Kamble |