首先数据库脚本:
CREATE TABLE rent(
id INT(32) PRIMARY KEY AUTO_INCREMENT,
userName VARCHAr(22) NOT NULL,
carName VARCHAr(32) NOT NULL,
`status` INT(50) NOT NULL,
maturityDate DATE NOT NULL
)CHARSET=utf8;
INSERT INTO rent(userName,carName,`status`,maturityDate)
VALUES('周晓阳','京A3098W',1,'2022-06-17'),
('张三','冀DZ3344',0,'2022-08-17'),
('tom','豫JZ7631',0,'2023-06-17');
代码实现:
实体类:
private int id;
private String userName;
private String carName;
private int status;
private Date maturityDate;
//get+set方法
Dao层:
public interface RentDao {
//查询全部
List getAll();
//模糊查询(更具车牌号查询)
Rent getRentInfoByCarNum(String carName);
//添加的方法
int addRent(Rent rent);
//修改的方法
int updateRent(int status,int id);
}
Dao--impl:
public class RentDaoImpl extends BaseDao implements RentDao {
@Override
public List getAll() {
String sql="select * from rent";
ResultSet rs = this.executeQuery(sql, null);
List rentList=new ArrayList<>();
try {
while (rs.next()){
Rent rent=new Rent();
rent.setId(rs.getInt("id"));
rent.setUserName(rs.getString("userName"));
rent.setCarNum(rs.getString("carName"));
rent.setStatus(rs.getInt("status"));
rent.setMaturityDate(rs.getDate("maturityDate"));
rentList.add(rent);
}
} catch (SQLException throwables) {
throwables.printStackTrace();
}
return rentList;
}
@Override
public Rent getRentInfoByCarNum(String carName) {
String sql="select * from rent where carName=?";
Object[] objects={carName};
ResultSet rs = this.executeQuery(sql, objects);
Rent rent=null;
try {
if (rs.next()){
rent=new Rent();
rent.setId(rs.getInt("id"));
rent.setUserName(rs.getString("userName"));
rent.setCarNum(rs.getString("carName"));
rent.setStatus(rs.getInt("status"));
rent.setMaturityDate(rs.getDate("maturityDate"));
}
} catch (SQLException throwables) {
throwables.printStackTrace();
}
return rent;
}
@Override
public int addRent(Rent rent) {
String sql="INSERT INTO `rent`(`userName`,`carName`,`status`,`maturityDate`)n" +
"VALUES (?,?,?,?)";
Object[] objects={rent.getUserName(),rent.getCarNum(),rent.getStatus(),rent.getMaturityDate()};
return this.executeUpdate(sql,objects);
}
@Override
public int updateRent(int status,int id) {
String sql="update rent set status=? where id=?";
Object[] objects={status,id};
return this.executeUpdate(sql,objects);
}
}
Service层:
public interface RentService {
//查询全部
List getAll();
//模糊查询(更具车牌号查询)
boolean getRentInfoByCarName(String carName);
//添加的方法
boolean addRent(Rent rent);
//修改的方法
boolean updateRent(int status,int id);
}
ServiceImpl:
public class RentServiceImpl implements RentService {
RentDao rd=new RentDaoImpl();
@Override
public List getAll() {
return rd.getAll();
}
@Override
public boolean getRentInfoByCarName(String carName) {
if (rd.getRentInfoByCarNum(carName)!=null){
return true;
}
return false;
}
@Override
public boolean addRent(Rent rent) {
if (rd.addRent(rent)>0){
return true;
}
return false;
}
@Override
public boolean updateRent(int status, int id) {
if (rd.updateRent(status, id)>0){
return true;
}
return false;
}
}
页面:
sho.jsp的展示数据的页面关键代码:
停车场车位租聘管理系统 |
||||||||||
|
隔行换色:
$("[class='two'] tr:even").css("background","pink");
$(" [class='two'] tr:odd").css("background","orange");
修改的额脚本:
function updateStatus(status,id) {
if(status==0){
var answer = confirm("确认修改吗?");
if(answer){
$.ajax({
type:"get",
url:"UpdateServlet?status="+status+"&id="+id,//两个参数 状态和id
dataType:"json",
success:function (data) {
//根据回调函数 true:修改成功,修改页面上的文字
if(data.exist==true){
document.getElementById("c"+id).innerText='已过期';
document.getElementById("s"+id).innerHTML='已过期';
alert("修改成功!");
}else{
alert("修改失败");
}
}
})
}
}else{
alert("您的车位已到期!")
}
点击跳转的脚本:
function add() {
window.location="add.jsp";
}
添加表单:(展示需求填写信息的表单)关键代码
光标移开的事件,关键代码:
Servlet:
展示全部的Servlet(ShowServlet):
@WebServlet("/ShowServlet")
public class ShowServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
this.doPost(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
HttpSession session = request.getSession();
RentService rs=new RentServiceImpl();
String path = request.getParameter("path");
if (path==null){
List rentList= rs.getAll();
request.setAttribute("rentList",rentList);
request.getRequestDispatcher("show.jsp").forward(request,response);
}else if(path.equals("checkCarName")){
String carName = request.getParameter("carName");
boolean f = rs.getRentInfoByCarName(carName);
response.getWriter().print(f);
}
}
}
添加的Servlet(AddServlet):
@WebServlet("/AddServlet")
public class AddServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
this.doPost(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=UTF-8");
RentService rs=new RentServiceImpl();
String userName = request.getParameter("userName");
String carName = request.getParameter("carName");
String time = request.getParameter("time");
int status=0;
Rent rent=new Rent();
rent.setStatus(status);
rent.setUserName(userName);
rent.setCarNum(carName);
Date dTime=null;
SimpleDateFormat sdf=new SimpleDateFormat("yyy-MM-dd");
try {
dTime=sdf.parse(time);
} catch (ParseException e) {
e.printStackTrace();
}
rent.setMaturityDate(dTime);
boolean flag = rs.addRent(rent);
if(flag){
response.getWriter().print("");
}else{
response.getWriter().print("");
}
}
}
修改的Servlet(UpdateServlet):
@WebServlet("/UpdateServlet")
public class UpdateServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
this.doPost(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
RentService rs=new RentServiceImpl();
String id = request.getParameter("id");
String status = request.getParameter("status");
int s=1;
if((Integer.valueOf(status)==0)){
s=1;
//调用修改的方法
boolean flag = rs.updateRent(s, Integer.valueOf(id));
HashMap resultMap=new HashMap();
resultMap.put("exist",flag);
response.getWriter().print(JSON.toJSONString(resultMap));
}
}
}



