Saturday, April 7, 2012

MS Access Connection




import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import sun.jdbc.odbc.JdbcOdbcDriver;

public class Main {

public static void main(String[] args) {
try {
DriverManager.registerDriver(new JdbcOdbcDriver());
Connection connection = DriverManager.getConnection("jdbc:odbc:selcukogluODBC");
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery("Select * From Student");
while(rs.next()){
System.out.println(rs.getInt(1) +" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getInt(4));
}
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}

No comments:

Post a Comment