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(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)