資源簡介
Ajax實現(xiàn)二級/三級聯(lián)動下拉框---servlet版
代碼片段和文件信息
package?yk.dao;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.util.ArrayList;
import?java.util.List;
import?yk.entity.City;
import?yk.util.JdbcUtil;
public?class?CityDao?{
//根據(jù)外鍵查詢數(shù)據(jù)
public?List?findByFKId（int?id）{
Connection?connection?=?null;
PreparedStatement?stmt?=?null;
ResultSet?rs?=?null;
try?{
connection?=?JdbcUtil.getConnection（）;
String?sql?=?“select?*?from?city?where?province_id?=???“;
stmt?=?connection.prepareStatement（sql）;
stmt.setInt（1?id）;
rs?=?stmt.executeQuery（）;
List?list?=?new?ArrayList（）;
while?（rs.next（））?{
City?city?=?new?City（）;
city.setId（rs.getInt（“id“））;
city.setName（rs.getString（“name“））;
city.setProvince_id（rs.getInt（“province_id“））;
list.add（city）;
}
return?list;
}?catch?（Exception?e）?{
e.printStackTrace（）;
throw?new?RuntimeException（）;
}?finally{
try?{
connection.close（）;
stmt.close（）;
rs.close（）;
}?catch?（Exception?e2）?{
throw?new?RuntimeException（e2）;
}
}
}
public?City?findById（int?id）{
Connection?connection?=?null;
PreparedStatement?stmt?=?null;
ResultSet?rs?=?null;
try?{
connection?=?JdbcUtil.getConnection（）;
String?sql?=?“select?*?from?city?where?id?=???“;
stmt?=?connection.prepareStatement（sql）;
stmt.setInt（1?id）;
rs?=?stmt.executeQuery（）;
City?city?=?new?City（）;
while?（rs.next（））?{
city.setId（rs.getInt（“id“））;
city.setName（rs.getString（“name“））;
city.setProvince_id（rs.getInt（“province_id“））;
}
return?city;
}?catch?（Exception?e）?{
e.printStackTrace（）;
throw?new?RuntimeException（）;
}?finally{
try?{
connection.close（）;
stmt.close（）;
rs.close（）;
}?catch?（Exception?e2）?{
throw?new?RuntimeException（e2）;
}
}
}
public?City?findByName（String?name）{
Connection?connection?=?null;
PreparedStatement?stmt?=?null;
ResultSet?rs?=?null;
try?{
connection?=?JdbcUtil.getConnection（）;
String?sql?=?“select?*?from?city?where?name?=???“;
stmt?=?connection.prepareStatement（sql）;
stmt.setString（1?name）;
rs?=?stmt.executeQuery（）;
City?city?=?new?City（）;
while?（rs.next（））?{
city.setId（rs.getInt（“id“））;
city.setName（rs.getString（“name“））;
city.setProvince_id（rs.getInt（“province_id“））;
}
return?city;
}?catch?（Exception?e）?{
e.printStackTrace（）;
throw?new?RuntimeException（）;
}?finally{
try?{
connection.close（）;
stmt.close（）;
rs.close（）;
}?catch?（Exception?e2）?{
throw?new?RuntimeException（e2）;
}
}
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????4078??2017-07-26?19:47??ajax.sql
?????文件????????1312??2017-07-26?17:19??ajaxExample.sql
?????目錄???????????0??2017-07-26?19:27??ajaxExample_login_sanjiliandong_servletVersion\
?????文件????????1093??2017-07-25?19:34??ajaxExample_login_sanjiliandong_servletVersion\.classpath
?????文件????????1096??2017-07-25?19:34??ajaxExample_login_sanjiliandong_servletVersion\.project
?????目錄???????????0??2017-07-26?19:27??ajaxExample_login_sanjiliandong_servletVersion\.settings\
?????文件?????????564??2017-07-25?19:34??ajaxExample_login_sanjiliandong_servletVersion\.settings\.jsdtscope
?????文件?????????364??2017-07-25?19:34??ajaxExample_login_sanjiliandong_servletVersion\.settings\org.eclipse.jdt.core.prefs
?????文件?????????597??2017-07-25?19:34??ajaxExample_login_sanjiliandong_servletVersion\.settings\org.eclipse.wst.common.component
?????文件?????????414??2017-07-25?19:34??ajaxExample_login_sanjiliandong_servletVersion\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2017-07-25?19:34??ajaxExample_login_sanjiliandong_servletVersion\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-07-25?19:34??ajaxExample_login_sanjiliandong_servletVersion\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-07-26?19:27??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\
?????文件????????2503??2017-07-26?11:34??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\ErJiLianDongOne.jsp
?????文件????????3058??2017-07-26?14:02??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\ErJiLianDongTwo.jsp
?????目錄???????????0??2017-07-26?19:27??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\me
?????文件??????????39??2017-07-25?19:34??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\me
?????文件????????5786??2017-07-26?18:36??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\Province_city_county.jsp
?????目錄???????????0??2017-07-26?19:27??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\WEB-INF\
?????目錄???????????0??2017-07-26?19:27??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\WEB-INF\classes\
?????文件?????????429??2017-07-25?20:06??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\WEB-INF\classes\c3p0-config.xm
?????目錄???????????0??2017-07-26?19:27??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\WEB-INF\classes\yk\
?????目錄???????????0??2017-07-26?19:27??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\WEB-INF\classes\yk\dao\
?????文件????????3753??2017-07-26?15:07??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\WEB-INF\classes\yk\dao\CityDao.class
?????文件????????3767??2017-07-26?18:52??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\WEB-INF\classes\yk\dao\CountyDao.class
?????文件????????5372??2017-07-26?11:15??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\WEB-INF\classes\yk\dao\FirstSelect_twoDao.class
?????文件????????3647??2017-07-26?15:01??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\WEB-INF\classes\yk\dao\ProvinceDao.class
?????文件????????4864??2017-07-26?14:52??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\WEB-INF\classes\yk\dao\SecondSelect_twoDao.class
?????文件????????6888??2017-07-26?11:07??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\WEB-INF\classes\yk\dao\UserDao.class
?????目錄???????????0??2017-07-26?19:27??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\WEB-INF\classes\yk\entity\
?????文件?????????903??2017-07-26?14:53??ajaxExample_login_sanjiliandong_servletVersion\WebRoot\WEB-INF\classes\yk\entity\City.class
............此處省略72個文件信息
- 上一篇：OPENGL寫的四面體紋理貼圖
- 下一篇：圖像分類數(shù)據(jù)
評論
共有 條評論
川公網(wǎng)安備 51152502000135號