连接数据库

import java.sql.*;
import java.util.ArrayList;
//连接数据库
//JDBC-ODBC连接方式
public class testJdbcodbc {
public static void main(String[] args) {
Connection conn = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// Class.forName("com.mysql.jdbc.Driver");
// Class.forName("org.gjt.mm.mysql.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
conn = DriverManager.getConnection("jdbc:odbc:ADOMysql");
// conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/student");
// Statement sql = conn.createStatement();
// sql.executeUpdate("insert into student values(004,'zhao','1988-04-01',15)");
// sql.executeUpdate("insert into student values(002,'wang','1988-02-01',11)");
// sql.executeUpdate("insert into student values(003,'li','1988-03-01',13)");
// sql.executeUpdate("delete from student where name='wang'");
// sql.executeUpdate("update student set name='zzz'where name='zhang'");
// ResultSet rs = sql.executeQuery("select * from student order by height");
// while (rs.next()) {
//
// int number = rs.getInt(1);
// String name = rs.getString(2);
// Date date = rs.getDate(3);
// int height = rs.getInt(4);
// System.out.println(number + "," + name + "," + date + ","
// + height);
// }
Statement sql = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet rs = sql.executeQuery("select * from student");
rs.last();
int lastNumber = rs.getRow();
ArrayList<Integer> list = new ArrayList<Integer>();
for(int i = 1;i <=lastNumber;i++)
list.add(i);
int sampleNumber = 3;
System.out.println("随机抽取"+sampleNumber+"条记录");
while (sampleNumber>0) {

int i =(int) (Math.random()*list.size());
int index = list.get(i);
rs.absolute(index);//光标移到这一行
int number = rs.getInt(1);
String name = rs.getString(2);
Date date = rs.getDate(3);
int height = rs.getInt(4);
System.out.println(number + "," + name + "," + date + ","
+ height);
sampleNumber--;
list.remove(i);//删除抽去过的元素
}


conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}