Java 桥连 Access
package com.wangguan;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Test3Access {
public static void main(String[] args) {
try {
//Class.forName("");
String url = "jdbc:odbc:myds";
Connection con = DriverManager.getConnection(url);
Statement sta = con.createStatement();
String sql = "select stuId, stuName from student";
ResultSet rs = sta.executeQuery(sql);
while (rs.next()) {
// int i = 1;
// int stuId = rs.getInt(i++);
// String stuName = rs.getString(i++);
// String address = rs.getString(i++);
// String stuTel = rs.getString(i++);
// int age = rs.getInt(i++);
// System.out.println(stuId+" "+stuName+" "+address+" "+stuTel+" "+age);
System.out.println(rs.getInt(1) + " " + rs.getString(2));
}
} catch (SQLException e) {
e.printStackTrace();
}
        
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Test3Access {
public static void main(String[] args) {
try {
//Class.forName("");
String url = "jdbc:odbc:myds";
Connection con = DriverManager.getConnection(url);
Statement sta = con.createStatement();
String sql = "select stuId, stuName from student";
ResultSet rs = sta.executeQuery(sql);
while (rs.next()) {
// int i = 1;
// int stuId = rs.getInt(i++);
// String stuName = rs.getString(i++);
// String address = rs.getString(i++);
// String stuTel = rs.getString(i++);
// int age = rs.getInt(i++);
// System.out.println(stuId+" "+stuName+" "+address+" "+stuTel+" "+age);
System.out.println(rs.getInt(1) + " " + rs.getString(2));
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
 
                    
                     
                    
                 
                    
                 
                
            
         浙公网安备 33010602011771号
浙公网安备 33010602011771号 
