index.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
</head>
<body>
<%
session.setAttribute("flag","flag");
%>
<form action="./LoginServlet" method="post">
员工信息录入<br/>
用户名:<input type="text" value="" name="username" /> <br/>
密码:<input type="password" name="psw"/> <br/>
<input type="submit" value="保存" οnclick="save()"/>
</form>
</body>
<!--
<script type="text/javascript">
var flagSubmit=false;
//false表示可以提交表单,true表示不可以提交
function save(){
if(!flagSubmit){
document.forms[0].submit();
flagSubmit=true;
}else{
alert("您已重复提交");
}
}
</script>
-->
</html>
2. LoginServlet:
package day21;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
public class LoginServlet extends HttpServlet {
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
String username=request.getParameter("username");
DaoEmpImpl daoEmpImpl=new DaoEmpImpl();
HttpSession session=request.getSession();
String flag=(String)session.getAttribute("flag");
try {
if(flag!=null){
daoEmpImpl.saveEmp(username);
session.removeAttribute("flag");
}else {
System.out.println("您已重复提交");
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String path="/success.jsp";
request.getRequestDispatcher(path).forward(request, response);
}
}
<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>lianxi</title>
</head>
<body>
XXXXXXX <br>
</body>
</html>
4. DaoEmpImpl:
package day21;
import java.sql.Connection;
import java.sql.PreparedStatement;
public class DaoEmpImpl {
public void saveEmp(String username) throws Exception {
DBManager dbManager=null;
Connection conn=null;
dbManager=DBManager.getDbManager();
conn=dbManager.getConnection();
PreparedStatement pstmt=null;
String sql="insert into employees(id,username)values(null,?) ";
pstmt= conn.prepareStatement(sql);
pstmt.setString(1, username);
pstmt.executeUpdate();
dbManager.closeResource(conn, pstmt, null);
}
}