ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Code Snippets  >>  Programming Code  >>  Java Code  >>  J2SE Code
 
 


 

 
 J2SE Code interview questions  J2SE Code Interview Questions
 J2EE Code interview questions  J2EE Code Interview Questions
 J2ME Code interview questions  J2ME Code Interview Questions
Question
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 Submitted By :: Hema
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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?
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
 
Is This Answer Correct ?    1 Yes 0 No
Kiran Kamble
 

 
 
 
Other J2SE Code Interview Questions
 
  Question Asked @ Answers
 
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?  1
how to store and retrive a set of values without using an array Maximus4
how to print a message to console without using main() function?(do not use even static blocks also.) Google6
How to create and run runnable jar file of a Java Project. HCL3
inner join,outerjoin,trigger,stored procedure explain with code snippets?  1
 
For more J2SE Code Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com