实训15

Servlet登录界面增加了新增和删除功能

一.删除
新建了几个JAVA文件 deleteServlet addservlet findservlet 还有jsp文件adduser

deleteservlet中代码

public class DeleteServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String id1=req.getParameter(“id”);
int id2=Integer.parseInt(id1);
IUserService userService=new UserServiceImpl();
userService.delete(id2);

    req.getRequestDispatcher("/find").forward(req, resp);
}

}

web中添加以下代码

DeleteServlet com.zhongruan.servlet.DeleteServlet DeleteServlet /delete

IcosumerDao中添加以下代码

void delete(int id);
1
再在CousumerDaoImpl中添加以下代码

public void delete(int id) {
Connection connection=null;
PreparedStatement statement=null;
try{
connection=DBUtil.getConnection();
statement=connection.prepareStatement(“delete from consumer where id=?”);
statement.setInt(1,id);
statement.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally {
DBUtil.closeAll(null,statement,connection);
}
}

UserServiceImpl中添加以下代码

public void delete(int id) {
iConsumerDao.delete(id);
}
1
2
3
IUserService中添加以下代码

void delete(int id);

二.新增

新增用户名和密码
新建jsp文件addUser 添加以下代码

<

基于servlet+jsp框架的管理系统：简单实现增、删、改、查。

<div class="row clearfix">
    <div class="col-md-12 column">
        <div class="page-header">
            <h1>
                <small>新增用户</small>
            </h1>
        </div>
    </div>
</div>
<form action="/add" method="post">
    <br><br><br>
    用户姓名：<input type="text" name="username"><br><br><br>
    用户密码：<input type="text" name="password"><br><br><br>
    <input type="submit" value="添加" >
</form>

在IConsumerDao中添加以下代码

void add(String name,String password);
1
consumerDaoImpl中就会报红出现异常 alt+shift抛出异常后在方法里添加以下代码

public void add(String name, String password) {
Connection connection=null;
PreparedStatement statement=null;
try{
connection=DBUtil.getConnection();
statement=connection.prepareStatement(“insert into consumer(name,password) values (?,?)”);
statement.setString(1,name);
statement.setString(2,password);
statement.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally {
DBUtil.closeAll(null,statement,connection);
}
}

在IUserService中添加以下代码

void add(String name,String password);

UserServiceImpl中也会出现异常 抛出后添加以下代码

public void add(String name, String password) {
iConsumerDao.add(name, password);
}

AddServlet中添加以下代码

public class AddServlet extends HttpServlet {
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String name=req.getParameter(“username”);
String password=req.getParameter(“password”);
IUserService userService=new UserServiceImpl();
userService.add(name,password);
req.getRequestDispatcher("/find").forward(req,resp);
}
}

web里添加以下代码

AddServlet com.zhongruan.servlet.AddServlet AddServlet /add 1 2 3 4 5 6 7 8 FindServlet中添加以下代码

public class FindServlet extends HttpServlet {
IUserService userService=new UserServiceImpl();
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
List consumers=userService.findAll();
HttpSession session=req.getSession();
session.setAttribute(“consumerslist”,consumers);
req.getRequestDispatcher(“allUser.jsp”).forward(req,resp);
}
}
1
2
3
4
5
6
7
8
9
10
web里添加以下代码

FindServlet com.zhongruan.servlet.FindServlet FindServlet /find 1 2 3 4 5 6 7 8 LoginServlet中代码改为以下代码

protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String name = req.getParameter(“username”);
String password = req.getParameter(“password”);
IUserService userService=new UserServiceImpl();
userService.login(name,password);
Boolean flag=userService.login(name,password);
if (flag) {
req.getRequestDispatcher("/find").forward(req, resp);
} else {
req.getRequestDispatcher(“fail.jsp”).forward(req,resp);
}
}