package?com.soft.dwr;???
??
import?java.sql.Connection;???
import?java.sql.PreparedStatement;???
import?java.sql.ResultSet;???
import?java.sql.SQLException;???
import?java.util.HashMap;???
import?java.util.Map;???
??
public?class?AjaxDAO?{???
??
????private?final?String?COUNTRY?=?“select?*?from?country“;???
????private?final?String?PROVINCE?=?“select?*?from?province?where?countryid=?“;???
????private?final?String?CITY=“select?*?from?city?where?provinceid=?“;???
???????
???????
????public??Map?getProvince（int?id）?{???
????????Map?map?=?new?HashMap（）;???
????????Connection?con;???
????????try?{???
????????????con?=?DBConnection.getCon（）;???
????????????PreparedStatement?ps?=?con.prepareStatement（PROVINCE）;???
????????????ps.setInt（1?id）;???
????????????ResultSet?rs?=?ps.executeQuery（）;???
????????????while?（rs.next（））?{???
????????????????map.put（new?Integer（rs.getInt（1））.toString（）?rs.getString（2））;???
????????????}???
???????????????????if（rs!=null）{rs.close（）;}???
???????????????????if（ps!=null）{ps.close（）;}???
????????}?catch?（SQLException?e）?{???
????????????//?TODO?Auto-generated?catch?block???
????????????e.printStackTrace（）;???
????????}???
??
????????return?map;???
??
????}???
??
????public?Map?getCountry（）?{???
????????Map?map?=?new?HashMap（）;???
????????Connection?con;???
????????try?{???
????????????con?=?DBConnection.getCon（）;?????
????????????PreparedStatement?ps?=?con.prepareStatement（COUNTRY）;???
????????????ResultSet?rs?=?ps.executeQuery（）;???
????????????while?（rs.next（））?{???
????????????????map.put（new?Integer（rs.getInt（1））.toString（）?rs.getString（2））;???
????????????}???
????????}?catch?（SQLException?e）?{???
????????????//?TODO?Auto-generated?catch?block???
????????????e.printStackTrace（）;???
????????}???
??
????????return?map;???
??
????}???
??
????public??Map?getCity（int?id）?{???
????????Map?map?=?new?HashMap（）;???
????????Connection?con;???
????????try?{???
????????????con?=?DBConnection.getCon（）;?????
????????????PreparedStatement?ps?=?con.prepareStatement（CITY）;???
????????????ps.setInt（1?id）;???
????????????ResultSet?rs?=?ps.executeQuery（）;???
????????????while?（rs.next（））?{???
????????????????map.put（new?Integer（rs.getInt（1））.toString（）?rs.getString（2））;???
????????????}???
????????}?catch?（SQLException?e）?{???
????????????//?TODO?Auto-generated?catch?block???
????????????e.printStackTrace（）;???
????????}???
??
????????return?map;???
??
????}???
}??

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????495??2009-03-04?21:21??sanjiliandong\.classpath

?????文件????????312??2009-03-04?20:52??sanjiliandong\.mymetadata

?????文件???????1231??2009-03-04?21:12??sanjiliandong\.project

?????文件???????1178??2009-03-04?22:34??sanjiliandong\exe.sql

?????文件???????2596??2009-03-04?21:10??sanjiliandong\src\com\soft\dwr\AjaxDAO.java

?????文件????????707??2009-03-04?21:08??sanjiliandong\src\com\soft\dwr\DBConnection.java

?????文件???????2137??2009-03-04?22:43??sanjiliandong\WebRoot\index.jsp

?????文件?????????39??2009-03-04?20:52??sanjiliandong\WebRoot\meta-INF\MANIFEST.MF

?????文件???????2419??2009-03-04?21:21??sanjiliandong\WebRoot\WEB-INF\classes\com\soft\dwr\AjaxDAO.class

?????文件???????1195??2009-03-04?21:21??sanjiliandong\WebRoot\WEB-INF\classes\com\soft\dwr\DBConnection.class

?????文件????????360??2009-03-04?21:14??sanjiliandong\WebRoot\WEB-INF\dwr.xml

?????文件?????185929??2009-03-04?20:56??sanjiliandong\WebRoot\WEB-INF\lib\dwr.jar

?????文件????????641??2009-03-04?21:12??sanjiliandong\WebRoot\WEB-INF\web.xml

?????目錄??????????0??2009-03-04?21:21??sanjiliandong\WebRoot\WEB-INF\classes\com\soft\dwr

?????目錄??????????0??2009-03-04?21:21??sanjiliandong\WebRoot\WEB-INF\classes\com\soft

?????目錄??????????0??2009-03-04?21:08??sanjiliandong\src\com\soft\dwr

?????目錄??????????0??2009-03-04?21:21??sanjiliandong\WebRoot\WEB-INF\classes\com

?????目錄??????????0??2009-03-04?21:06??sanjiliandong\src\com\soft

?????目錄??????????0??2009-03-04?21:21??sanjiliandong\WebRoot\WEB-INF\classes

?????目錄??????????0??2009-03-04?20:56??sanjiliandong\WebRoot\WEB-INF\lib

?????目錄??????????0??2009-03-04?21:06??sanjiliandong\src\com

?????目錄??????????0??2009-03-04?20:52??sanjiliandong\WebRoot\meta-INF

?????目錄??????????0??2009-03-04?21:11??sanjiliandong\WebRoot\WEB-INF

?????目錄??????????0??2009-03-04?20:52??sanjiliandong\.myeclipse

?????目錄??????????0??2009-03-04?21:06??sanjiliandong\src

?????目錄??????????0??2009-03-04?21:10??sanjiliandong\WebRoot

?????目錄??????????0??2009-03-04?20:55??sanjiliandong

-----------?---------??----------?-----??----

???????????????199239????????????????????27



............此處省略0個(gè)文件信息