Click here to Skip to main content
15,885,546 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Java
import java.sql.*;

public class db 
{
    Connection con;
    Statement st;
    ResultSet rs;
    public db()
    {
        
        conection();
    }
    public void conection(){
        
        try{
            String driver="sun.jdbc.odbc.JdbcOdbcDriver";
            Class.forName(driver);
            
            String db="jdbc:odbc:db1";
            con=DriverManager.getConnection(db);
            st=con.createStatement();
            String sql="select * from Table1";
            rs=st.executeQuery(sql);
            while(rs.next())
            {
                String fname =rs.getString("Fname");
                String lname=rs.getString("Lname");
                String age=rs.getString("Age");
                System.out.println(fname+"/t"+lname+"/t"+age);
                
            }
            
            
            
        }
        catch(Exception ex)
        {
            System.out.print("Connection feiled");
        }
        
    }
        public static void main(String[] args)
        {
            new db();
        }
        
}
Posted
Updated 20-Jan-15 21:38pm
v2
Comments
Mohibur Rashid 21-Jan-15 0:15am    
And what is happening?
[no name] 21-Jan-15 1:13am    
So what's the problem??
Pandu Rang 5-Feb-15 8:31am    
Where u facing problem?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900