JSP数据库删除功能实现：删除员工信息delete.jsp

删除员工信息页面delete.jsp

<%@ page language="java" import="java.sql.*" pageEncoding="gb2312"%>
<%@ include file="conn.jsp" %>
<%request.setCharacterEncoding("gb2312");
String id=request.getParameter("id");
try{sql.executeUpdate("delete from employee_info where employee_num="+id);
con.close();
}
catch(SQLException e)
{ out.print(e);
}
%>
<script language="javascript">
alert("删除成功！");
window.location='admin.jsp';
</script>

<%@ include file="conn.jsp" %>
其中conn.jsp页面实现数据库连接功能，代码如下：

<%@ page language="java" import="java.sql.*" pageEncoding="gb2312"%>
<% Connection con;
Statement sql;
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{ out.print(e);
}
con=DriverManager.getConnection("jdbc:odbc:employee_dsn","sa","2005");
sql=con.createStatement();

%>