package db;
import java.sql.*;
public class Test {
public static void main(String[] args) {
Connection cn;
PreparedStatement psm=null;
ResultSet rs; //ResultSet接口用来暂存数据库查询出的结果集
DBCon dbcon=new DBCon();
cn=dbcon.getConnection(); //获取数据库对象
Classes classes=new Classes();
String sql="select * from classes";
try {
psm=cn.prepareStatement(sql);
rs=psm.executeQuery();
if(rs.next()) { //判断是否查询到结果
rs.absolute(0);
while(rs.next()) {
String classNum=rs.getString(2);
String className=rs.getString(3);
String classSex=rs.getString(4);
String classTime=rs.getString(5);
String classAcademy=rs.getString(6);
String classSpecialized=rs.getString(7);
String classClassa=rs.getString(8);
classes.setNum(classNum);
classes.setName(className);
classes.setSex(classSex);
classes.setTime(classTime);
classes.setAcademy(classAcademy);
classes.setSpecialized(classSpecialized);
classes.setClassa(classClassa);
System.out.println(classes.getNum()+","+classes.getName()+","+classes.getSex()+","+classes.getTime()+","+classes.getAcademy()+","+classes.getSpecialized()+","+classes.getClassa());
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}