delete_enterprise.jsp

JSP科技企业信息管理系统源码(MSSQL数据库)

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>

<jsp:useBean id="j" scope="application" class="jdbc.jdbc"/>


<%
String enterprise_delete=new String(request.getParameter("delete_e").getBytes("ISO8859_1"), "GBK");

String e_d=enterprise_delete.trim();
try{
Connection con=j.getConnection();

Statement statement=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);


String upsql="delete from user_info where user_enterprise_name='"+e_d+"'";


statement.executeUpdate(upsql);


j.releaseConnection(con);
}


catch(SQLException ee){out.print("删除失败！");}


out.print("所选记录以成功删除！");

%>