src/com/service/indexList.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.service;

import java.io.IOException;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import java.util.Random;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.dao.DB;
import com.orm.Tqiuzu;
import com.orm.Tyonghu;
import com.orm.Tfangyuan;
public class indexList
{
		
	public static List fangyuanNew()
	{
		List fangyuanList=new ArrayList();
		String sql="select *  from fangyuan where fyzhuangtai='审核通过' and fyflag='已上架' order by fyID desc limit 0,4 ";
		Object[] params={}; 
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			while(rs.next())
			{
				Tfangyuan fangyuan=new Tfangyuan();
				fangyuan.setfyID(rs.getInt("fyID"));
				fangyuan.setfyname(rs.getString("fyname"));
				fangyuan.setfyquyu(rs.getString("fyquyu"));
				fangyuan.setfyhuxing(rs.getString("fyhuxing"));
				fangyuan.setfymianji(rs.getString("fymianji"));
				fangyuan.setfylouceng(rs.getString("fylouceng"));
				fangyuan.setfyzonglouceng(rs.getString("fyzonglouceng"));
				fangyuan.setfyzujin(rs.getString("fyzujin"));
				fangyuan.setfyfukuan(rs.getString("fyfukuan"));
				fangyuan.setfyxiaoqu(rs.getString("fyxiaoqu"));
				fangyuan.setfydizhi(rs.getString("fydizhi"));
				fangyuan.setfyxiangqing(rs.getString("fyxiangqing"));
				fangyuan.setfytupian(rs.getString("fytupian"));
				fangyuan.setfypeizhi(rs.getString("fypeizhi"));
				fangyuan.setfyfaburiqi(rs.getString("fyfaburiqi"));
				fangyuanList.add(fangyuan);

		    }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		System.out.println(fangyuanList.size());
		return fangyuanList;