list遍历
来源:互联网 发布:特效字幕制作软件 编辑:程序博客网 时间:2024/05/29 16:46
public List<Y_Student> studentInformation(Connection conn,Y_user user) throws SQLException{
List<Y_Student> list_Stu = new ArrayList<Y_Student>();
String sql = "select user_name,class_name,result_mark,user_password FROM"
+ "(select user_name, user_password,class_id,result_mark from y_user a "
+ "right join y_result b on a.user_id=b.user_id where user_name = ? and user_password = ?)c "
+ "LEFT JOIN y_class d on c.class_id=d.class_id ";
PreparedStatement ps = null;
ResultSet rs = null;
String userName = user.getUserName();
int userPassword = user.getUser_Password();
conn = JDBCutility.getConnection();
ps = conn.prepareStatement(sql);
ps.setString(1, user.getUserName());
ps.setInt(2, user.getUser_Password());
rs=ps.executeQuery();
while(rs.next()){
Y_Student y_Stu = new Y_Student();//每次均需要新建一个对象 list里面的元素为对象
y_Stu.setStu_Name(rs.getString("user_Name"));
y_Stu.setStu_Course(rs.getString("class_name"));
y_Stu.setStu_score(rs.getString("result_mark"));
list_Stu.add(y_Stu);
}
JDBCutility.close(rs, ps, conn);
return list_Stu;
List<Y_Student> list_Stu = new ArrayList<Y_Student>();
String sql = "select user_name,class_name,result_mark,user_password FROM"
+ "(select user_name, user_password,class_id,result_mark from y_user a "
+ "right join y_result b on a.user_id=b.user_id where user_name = ? and user_password = ?)c "
+ "LEFT JOIN y_class d on c.class_id=d.class_id ";
PreparedStatement ps = null;
ResultSet rs = null;
String userName = user.getUserName();
int userPassword = user.getUser_Password();
conn = JDBCutility.getConnection();
ps = conn.prepareStatement(sql);
ps.setString(1, user.getUserName());
ps.setInt(2, user.getUser_Password());
rs=ps.executeQuery();
while(rs.next()){
Y_Student y_Stu = new Y_Student();//每次均需要新建一个对象 list里面的元素为对象
y_Stu.setStu_Name(rs.getString("user_Name"));
y_Stu.setStu_Course(rs.getString("class_name"));
y_Stu.setStu_score(rs.getString("result_mark"));
list_Stu.add(y_Stu);
}
JDBCutility.close(rs, ps, conn);
return list_Stu;
}
这样list遍历才能输出每一个对象
List<Y_Student> list = UserOperate.studentInformation(conn, user);
for (Y_Student y_Stu : list) {
String html = "<tr><td>"+y_Stu.getStu_Name()+"</td><td>"+y_Stu.getStu_Course()+"</td><td>"+String.valueOf(y_Stu.getStu_score())+"</td></tr>";
sbf.append(html);
//System.out.println(y_Stu.getStu_Name()+"|"+y_Stu.getStu_Course()+"|"+String.valueOf(y_Stu.getStu_score()));
}
0 0
- List遍历
- list遍历
- list遍历
- List遍历
- freemark-----------list(list,map遍历)
- JAVA LIST 遍历[转]
- List的数据遍历
- List的遍历
- JAVA LIST 遍历
- 页面遍历数组list
- Java list 遍历
- 遍历list数组
- List的遍历
- 遍历list数组
- java list遍历
- 遍历List集合
- STL MAP LIST 遍历
- JAVA LIST 遍历[转]
- HADOOP-RPC机制
- EasyUI小图标设置
- hdu 3613 扩展kmp求回文串
- Spring AOP 动态多数据源
- SSH框架入门(一)——Struts2基础及查错步骤
- list遍历
- [Genymotion] Unable to start the virtual device
- Java中级开发工程师知识点归纳
- luogg_java重新学习_第二章:基本语法01(概念)
- TabLayout
- [数据集]新浪微博数据集MicroblogPCU
- 【解题报告】CodeVS 4600 程序自动分析
- 《诗经》的注释
- 准备食物(trie) 题解+代码