Wednesday 11 November 2015

JAVA WITH MS ACCESS -Simple way learn front -end and back-end connection


import java.lang.*;
import java.sql.*;
import java.util.*;
import java.io.*;
class jdbcconnection1
{
public static void main(String args[])throws IOException
{
try
{
Connection con;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:ds1");
Statement s=con.createStatement();
ResultSet rs=s.executeQuery("select *from tele1");
while(rs.next())
{
System.out.println("Rollno:"+rs.getString(1));
System.out.println("mark:"+rs.getString(2));
}
con.close();
s.close();
}
catch(Exception e){}
}
}

No comments:

Post a Comment