//顯示學生資訊
public ArrayList<Student> showstu() {
Connection conn = DBhelp.getConnection();
//注意物體類先定義為空不然會重復輸出一條查詢資訊
Student models = null;
PreparedStatement execute = null;
ResultSet res = null;
ArrayList<Student> list = new ArrayList<Student>();
if (conn != null) {
String sql = "select students.*,classes.cname from students left join classes on students.cid = classes.cid;";
try {
execute = conn.prepareStatement(sql);
res = execute.executeQuery();
} catch (SQLException e) {
e.printStackTrace();
}
try {
while (res.next()) {
models=new Student();
models.setStuid(res.getString("stuid"));
models.setStuname(res.getString("stuname"));
models.setAge(res.getString("age"));
models.setCid(res.getString("cid"));
models.setCname(res.getString("cname"));
list.add(models);
}
} catch (Exception e) {
// TODO: handle exception
}
} else {
}
return list;
}
uj5u.com熱心網友回復：
你的問題是什么轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/43860.html
標籤：其他
上一篇：layui流加載圖示第一次不加載