JDBC_ODBC查询

package jdbc;

import java.sql.*;

public class JDBC_ODBCTest2 {

/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
//1.注册驱动
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("注册驱动错误");
e.printStackTrace();

}
//2.建立连接

try {
Connection conn=DriverManager.getConnection("jdbc:odbc:course");

//3.处理sql语句
String sql="SELECT * from student";
Statement stmt = conn.createStatement();

ResultSet rs=stmt.executeQuery(sql);

while(rs.next())
{
int studentid=rs.getInt(1);
String name=rs.getString("name");
byte age=rs.getByte(3);
String gender=rs.getString("gender");
String birthday=rs.getString(5);
System.out.println(studentid+"\t"+name+"\t"+age+"\t"+gender+"\t"+birthday);
}



stmt.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println("建立连接错误");
e.printStackTrace();

}

}

}