資源簡(jiǎn)介
本系統(tǒng)為博主所寫的汽車管理系統(tǒng)，僅供學(xué)習(xí)使用 V2.0
1.本系統(tǒng)實(shí)現(xiàn)了用戶的注冊(cè)和登錄，登錄后對(duì)登錄狀態(tài)做判斷而展現(xiàn)出‘用戶登錄’和‘退出登錄’的效果
2.實(shí)現(xiàn)的對(duì)汽車的增刪該查
3.博主使用的為MySQL數(shù)據(jù)庫和JDBC技術(shù)
4.本系統(tǒng)的幾個(gè)亮點(diǎn)：
1.實(shí)現(xiàn)了用戶的登錄狀態(tài)
2.在修改的時(shí)候?qū)崿F(xiàn)了數(shù)據(jù)回顯
3.實(shí)現(xiàn)了批量刪除功能
4.使用過濾器修改編碼格式
V2.0新增：
1.用戶登錄狀態(tài)判斷的完善
2.增加了分頁功能
3.增加了搜索框查詢功能
代碼片段和文件信息
package?com.xs.controller;
import?java.io.IOException;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;
import?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;
import?com.xs.entity.Car;
public?class?CarAddServlet?extends?HttpServlet?{
@Override
protected?void?service（HttpServletRequest?request?HttpServletResponse?response）
throws?ServletException?IOException?{
String?cid?=?request.getParameter（“cid“）;
String?cname?=?request.getParameter（“cname“）;
String?cprice?=?request.getParameter（“cprice“）;
String?color?=?request.getParameter（“color“）;
String?cbrand?=?request.getParameter（“cbrand“）;
String?clazz?=?request.getParameter（“clazz“）;
Connection?conn?=?null;
try?{
Class.forName（“com.mysql.jdbc.Driver“）;
conn?=?DriverManager.getConnection（“jdbc:mysql://localhost:3306/weekdemo““root““root“）;
PreparedStatement?ps?=?conn.prepareStatement（“insert?into?tb_car?values（??????）“）;
ps.setInt（1?Integer.parseInt（cid））;
ps.setString（2?cname）;
ps.setDouble（3?Double.parseDouble（cprice））;
ps.setString（4?color）;
ps.setString（5?cbrand）;
ps.setString（6?clazz）;
int?in?=?ps.executeUpdate（）;
if（in?>?0）{
response.sendRedirect（“show“）;
}else{
response.sendRedirect（“error.jsp“）;
}
}?catch?（Exception?e）?{
//?TODO?Auto-generated?catch?block
e.printStackTrace（）;
}?finally{
if（conn?!=?null）{
try?{
conn.close（）;
}?catch?（SQLException?e）?{
//?TODO?Auto-generated?catch?block
e.printStackTrace（）;
}?finally{
if（conn?!=?null）{
try?{
conn.close（）;
}?catch?（SQLException?e）?{
//?TODO?Auto-generated?catch?block
e.printStackTrace（）;
}
}
}
}
}
}
}
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-11-20?14:31??weekDemo1\
?????文件?????????922??2018-11-20?14:31??weekDemo1\.classpath
?????文件????????1042??2018-11-20?14:31??weekDemo1\.project
?????目錄???????????0??2018-11-20?14:31??weekDemo1\.settings\
?????文件?????????503??2018-11-20?14:31??weekDemo1\.settings\.jsdtscope
?????文件?????????364??2018-11-20?14:31??weekDemo1\.settings\org.eclipse.jdt.core.prefs
?????文件?????????479??2018-11-20?14:31??weekDemo1\.settings\org.eclipse.wst.common.component
?????文件?????????345??2018-11-20?14:31??weekDemo1\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2018-11-20?14:31??weekDemo1\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-11-20?14:31??weekDemo1\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-11-20?14:31??weekDemo1\build\
?????目錄???????????0??2018-11-20?14:31??weekDemo1\build\classes\
?????目錄???????????0??2018-11-20?14:31??weekDemo1\build\classes\com\
?????目錄???????????0??2018-11-20?14:31??weekDemo1\build\classes\com\xs\
?????目錄???????????0??2018-11-20?14:31??weekDemo1\build\classes\com\xs\controller\
?????文件????????3691??2018-11-20?14:31??weekDemo1\build\classes\com\xs\controller\CarAddServlet.class
?????文件????????3105??2018-11-20?14:31??weekDemo1\build\classes\com\xs\controller\CarDeleteByIdServlet.class
?????文件????????3657??2018-11-20?14:31??weekDemo1\build\classes\com\xs\controller\CarDeleteServlet.class
?????文件????????4947??2018-11-20?14:31??weekDemo1\build\classes\com\xs\controller\CarSelectByNameServlet.class
?????文件????????5004??2018-11-20?14:31??weekDemo1\build\classes\com\xs\controller\CarShowServlet.class
?????文件????????3746??2018-11-20?14:31??weekDemo1\build\classes\com\xs\controller\CarUpdateByIdServlet.class
?????文件????????3073??2018-11-20?14:31??weekDemo1\build\classes\com\xs\controller\UserLoginServlet.class
?????文件????????2455??2018-11-20?14:31??weekDemo1\build\classes\com\xs\controller\UserRegServlet.class
?????目錄???????????0??2018-11-20?14:31??weekDemo1\build\classes\com\xs\entity\
?????文件????????2196??2018-11-20?14:31??weekDemo1\build\classes\com\xs\entity\Car.class
?????文件????????1706??2018-11-20?14:31??weekDemo1\build\classes\com\xs\entity\User.class
?????目錄???????????0??2018-11-20?14:31??weekDemo1\build\classes\com\xs\filter\
?????文件????????1233??2018-11-20?14:31??weekDemo1\build\classes\com\xs\filter\ServletFilter.class
?????目錄???????????0??2018-11-20?14:31??weekDemo1\src\
?????目錄???????????0??2018-11-20?14:31??weekDemo1\src\com\
?????目錄???????????0??2018-11-20?14:31??weekDemo1\src\com\xs\
............此處省略35個(gè)文件信息
評(píng)論
共有 條評(píng)論
川公網(wǎng)安備 51152502000135號(hào)