How can we get the details for printing the employee details at run time using

How can we get the details for printing the employee
details at run time using JDBC connectivity? can u provide
the coding for that? Its urgent?

Question Posted / hema

2 Answers
11623 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can we get the details for printing the employee details at run time using JDBC connectivity? ..

Answer / shanu zabeen

import java.sql.*;
import java.io.*;
public class Employeedetails
{
public static void main(String args[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:employeeds");
Statement st=con.createStatement();
ResuleSet rs=st.executeQuery("select * from emp");//this
executes the query and get all the details from the table
employeeds
System.out.println("EId Ename Salary\n");
while(rs.next())
{
System.out.println(+rs.getInt(1)+"
"+rs.getString(2)+" "+rs.getString(3));

}//here 1 2 3 mentioned are the indices which are unique and
instead of 1 2 3 u can also provide the name of that
particular column name
and getXXX(index) ,here xxx is the type of the column like
int or float or string
st.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}

}
}

Is This Answer Correct ?

6 Yes

0 No

How can we get the details for printing the employee details at run time using JDBC connectivity? ..

Answer / kiran kamble

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

Is This Answer Correct ?

6 Yes

2 No

Post New Answer