查询学校功能,连上数据库,就可以获取到学校的信息,下面是方法,其余的查询可以根据自己的需要进行修改,大体都差不多
public ArrayList<Gaokao> queryAllGaokao(){
ArrayList<Gaokao> gaokaolist=new ArrayList<Gaokao>();
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
String sql="select * from gaokao";
conn=JDBCtuils.getCon();
try {
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
while (rs!=null&&rs.next()) {
Gaokao gaokao=new Gaokao();
gaokao.setSchool_code(rs.getInt("school_code"));
gaokao.setSchool_id(rs.getString("school_id"));
gaokao.setSchool(rs.getString("school"));
gaokao.setSheng(rs.getString("sheng"));
gaokao.setCity(rs.getString("city"));
gaokao.setLeixing(rs.getString("leixing"));
gaokao.setPlans(rs.getString("plans"));
gaokao.setPro_code(rs.getString("pro_code"));
gaokao.setPro_id(rs.getString("pro_id"));
gaokao.setPro_name(rs.getString("pro_name"));
gaokao.setPro(rs.getString("pro"));
gaokao.setSubject(rs.getString("subject"));
gaokao.setXuezhi(rs.getString("xuezhi"));
gaokao.setPlan(rs.getString("plan"));
gaokao.setCost(rs.getString("cost"));
gaokao.setSides(rs.getInt("sides"));
gaokao.setChanggui(rs.getString("changgui"));
gaokaolist.add(gaokao);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
JDBCtuils.release(conn, ps, rs);
}
return gaokaolist;
}