reg.jsp

jsp实现的一个人事管理系统,功能包括登录注册、花名册、以及查询修改员工信息等基本功能

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<%
  request.setCharacterEncoding("GB2312");
  String 姓名=request.getParameter("姓名");
  String 出生年月=request.getParameter("出生年月");
  String 部门=request.getParameter("部门");
  String 性别=request.getParameter("性别");
  String 住址=request.getParameter("住址");
  String 职称=request.getParameter("职称");
  String 文化程度=request.getParameter("文化程度");
  String 联系电话=request.getParameter("联系电话");
  String Email=request.getParameter("Email");
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  //建立连接
  Connection conn=DriverManager.getConnection("jdbc:odbc:mydb","",""); //发送SQL语句
  Statement stmt=conn.createStatement(); 
  String sql;
  ResultSet rs;
  try{ 
  rs=stmt.executeQuery("SELECT 姓名 FROM employee_info where 姓名='"+姓名+"'");  
  if(rs.next())
  {%>
  <script language="javascript">alert("该姓名已经存在,请重新注册!");
  window.history.go(-1); 
  </script>
  <%
  rs.close();
  }
  else{%>
  <script language="javascript">alert("档案注册成功!"); 
  window.history.go(-1);</script> 
  <%
  sql="insert into employee_info(姓名,出生年月,部门,性别,住址,职称,文化程度,联系电话,Email)Values('"+姓名+"','"+出生年月+"','"+部门+"','"+性别+"','"+住址+"','"+职称+"','"+文化程度+"','"
  +联系电话+"','"+Email+"');";
  stmt.executeUpdate(sql);
  } 
}
catch(Exception e){
  out.println(e.getMessage());
  } 
  finally{
  stmt.close();
  conn.close(); 
  } 
%>