使用Hibernate
Query query = session.createQuery("select mtype,play_page from play_page");List<String> list = query.list();然后如何使用for循环来得到每个的mtype,play_page呢?
Query query = session.createQuery("select mtype,play_page from play_page");List<String> list = query.list();然后如何使用for循环来得到每个的mtype,play_page呢?
T_User
userId varchar(10) not null primary key,
username varchar(20) T_Userfriend
userId varchar(10) not null,
friendId varchar(10) not null,
id int(10) primary key auto increment (POJO名和表名相同)
Iterator iterator=session.createQuery(SELECT T_User.userId,T_User.username,T_Userfriend.friendId FROM
WHERE T_User.userId=T_Userfriend.userId).iterator(); while(iterator.hasNext()){
Object []results=(Object [])iterator.next();
String userId=String.valueOf(result[0]);
String username=String.valueOf(result[1]);
String friendId=String.valueOf(result[2]);
}
Object obj[]=(Object[])list.get(i);
System.out.println(obj[0]+"##"+obj[1]);
}
List<User> users = new ArrayList<User>();
for(User user : users) {
//这里就是遍历的每个用户
}
if(list!=null && list.size()>0){
for(String li : list){
String mtype = li.get(0);
System.out.println("mtype --- > " + mtype );
String play_page = li.get(1);
System.out.println("play_page --- > " + play_page);
}
}
这样就可以得到你想要的答案了啊
for(User user : users) {
//这里就是遍历的每个用户
}
list.add("2");
list.add("3");
list.add("4"); for (String word : list) {
System.out.println(word);
}
for(int i=0;i<list.size();i++){
Object obj[]=(Object[])list.get(i);
System.out.println(obj[0]+"##"+obj[1]);
}
2、在查询时把多个属性放到一个实体类中(这个实体类里有这两个属性,假设Mytabljfd 为实体类,有这两个属性)
Query query = session.createQuery("select new Mytable(mtype,play_page) from play_page");
for(Iterator iter = list.iterator();iter.hasNext();){
Mytable yytable= (Mytable) iter.next();
System.out.println(Mytable.getMtype()+" "+Mytable.getPlay_page());
}
for(int i=0;i <list.size();i++){
Object obj[]=(Object[])list.get(i);
System.out.println(obj[0]+"##"+obj[1]);
}
2、在查询时把多个属性放到一个实体类中(这个实体类里有这两个属性,假设Mytabljfd 为实体类,有这两个属性)
Query query = session.createQuery("select new Mytable(mtype,play_page) from play_page");
for(Iterator iter = list.iterator();iter.hasNext();){
Mytable mytable= (Mytable) iter.next();
System.out.println(mytable.getMtype()+" "+mytable.getPlay_page());
}
先敲入:for然后“Alt+/”IDE会告诉你有几种遍历方法的~!
你可以 List <play_page> list = query.list();
for(play_page pp:list)
{
pp.getMtype()
}
Object[] obj = (Object[])list.get(i);//得到每条记录
for(int j=0; j<obj.length;j++){
Sysout.out.println(ogj[j]);//输出每条记录的具体元数据
}
}
list<Object[]>
for(object[] obj:list){
obj[0]
obj[1]
}
String mytable= (String) iter.next();
System.out.println(mytable.getMtype()+" "+mytable.getPlay_page());
}
List <String> list = query.list();
for (String str : list) {
}
if(list!=null && list.size()>0){
for(String li : list){
String mtype = li.get(0);
System.out.println("mtype --- > " + mtype );
String play_page = li.get(1);
System.out.println("play_page --- > " + play_page);
}
}
看list 里面的方法啊