package?com.phoneshop.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;

import?com.phoneshop.entity.PhoneInfo;
import?com.phoneshop.tool.JdbcTool;

public?class?PhoneInfoDao?{
	public?List?query（String?brand）{
		List?infos=new?ArrayList（）;
		Connection?conn=JdbcTool.getConn（）;
		String?sql=“select?*?from?phoneinfo?where?p_brand=?“;
		try?{
			PreparedStatement?ps=conn.prepareStatement（sql）;
			ps.setString（1?brand）;
			ResultSet?rs=ps.executeQuery（）;
			PhoneInfo?info=null;
			while?（rs.next（））?{
				String?name=rs.getString（2）;
				int?price=rs.getInt（4）;
				String?url=rs.getString（5）;
				String?screenSize=rs.getString（6）;
				String?thick=rs.getString（7）;
				String?timeToMarket=rs.getString（8）;
				String?pixel=rs.getString（9）;
				String?cpu=rs.getString（10）;
				String?netSize=rs.getString（11）;
				String?system=rs.getString（12）;
				String?describe=rs.getString（13）;
				info=new?PhoneInfo（name?brand?price?url?screenSize?thick?timeToMarket?pixel?cpu?netSize?system?describe）;
				infos.add（info）;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}finally{
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		return?infos;
	}
	public?List?queryByPrice（String?priceLevel）{
		List?infos=new?ArrayList（）;
		String[]?prices=priceLevel.split（“/“）;
		int?minPrice=Integer.parseInt（prices[0]）;
		int?maxPrice=Integer.parseInt（prices[1]）;
		Connection?conn=JdbcTool.getConn（）;
		String?sql=“select?*?from?phoneinfo?where?p_price?between???and???order?by?p_price“;
		try?{
			PreparedStatement?ps=conn.prepareStatement（sql）;
			ps.setInt（1?minPrice）;
			ps.setInt（2?maxPrice）;
			ResultSet?rs=ps.executeQuery（）;
			PhoneInfo?info=null;
			while（rs.next（））?{
				String?name=rs.getString（2）;
				String?brand=rs.getString（3）;
				int?price=rs.getInt（4）;
				String?url=rs.getString（5）;
				String?screenSize=rs.getString（6）;
				String?thick=rs.getString（7）;
				String?timeToMarket=rs.getString（8）;
				String?pixel=rs.getString（9）;
				String?cpu=rs.getString（10）;
				String?netSize=rs.getString（11）;
				String?system=rs.getString（12）;
				String?describe=rs.getString（13）;
				info=new?PhoneInfo（name?brand?price?url?screenSize?thick?timeToMarket?pixel?cpu?netSize?system?describe）;
				infos.add（info）;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}finally{
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		return?infos;
		
	}
	public?List?queryByScreenSize（String?screenSize）?{
		List?infos=new?ArrayList（）;
		String[]?size=screenSize.split（“/“）;
		String?minSize=size[0];
		String?maxSize=size[1];
		Con

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-06-02?23:12??手機商城\
?????目錄???????????0??2015-06-02?23:12??手機商城\images\
?????文件???????23450??2015-05-12?14:01??手機商城\images\huawei4.png
?????文件???????23820??2015-05-12?14:02??手機商城\images\huawei6Plus.png
?????文件???????23279??2015-05-12?14:02??手機商城\images\huaweiMate7.png
?????文件???????32600??2015-05-12?14:03??手機商城\images\huaweiX2.png
?????文件???????25363??2015-05-12?14:03??手機商城\images\huaweiX4.png
?????文件???????32000??2015-05-12?14:04??手機商城\images\iPhone4s.png
?????文件???????26334??2015-05-12?14:04??手機商城\images\iPhone5c.png
?????文件???????29359??2015-05-12?14:05??手機商城\images\iPhone5s.png
?????文件???????33203??2015-05-12?14:05??手機商城\images\iPhone6.png
?????文件???????35493??2015-05-12?14:05??手機商城\images\iPhone6Plus.png
?????文件???????24762??2015-05-12?14:06??手機商城\images\meiMX.png
?????文件???????24062??2015-05-12?14:06??手機商城\images\meiMX2.png
?????文件???????19540??2015-05-12?14:07??手機商城\images\meiMX3.png
?????文件???????23530??2015-05-12?14:07??手機商城\images\meiMX4.png
?????文件???????25604??2015-05-12?14:08??手機商城\images\meiMX4Pro.png
?????文件???????20824??2015-05-12?14:08??手機商城\images\miNote.png
?????文件???????20165??2015-05-12?14:09??手機商城\images\miRed2.png
?????文件???????27147??2015-05-12?14:09??手機商城\images\miRed2A.png
?????文件???????26097??2015-05-12?14:09??手機商城\images\miRedM4.png
?????文件???????21221??2015-05-12?14:10??手機商城\images\miRedNote.png
?????文件???????28595??2015-05-12?14:11??手機商城\images\samGalaxyA7.png
?????文件???????30336??2015-05-12?14:11??手機商城\images\samGalaxyS4.png
?????文件???????31465??2015-05-12?14:12??手機商城\images\samGalaxyS5.png
?????文件???????23720??2015-05-12?14:13??手機商城\images\samGalaxyS6.png
?????文件???????23243??2015-05-12?14:13??手機商城\images\samGalaxyS6Edge.png
?????目錄???????????0??2015-06-02?23:12??手機商城\shop\
?????目錄???????????0??2015-06-02?23:12??手機商城\shop\phoneshop\
?????文件????????1438??2015-05-17?18:21??手機商城\shop\phoneshop\.classpath
?????文件????????1408??2015-05-17?18:21??手機商城\shop\phoneshop\.project
............此處省略1407個文件信息