<%@ page contentType="text/html; charset=gb2312" import="java.sql.*"%> <% request.setCharacterEncoding("gb2312");%> <%if((request.getParameter("id")!=null)&&(!request.getParameter("id").equals(""))){%>企业数据修改<%}else{%>企业数据添加<%}%> <%! String sql; int i; ResultSet rs; String id,name,address,phone,type; %> <% if(request.getParameter("action")!=null){ name=request.getParameter("name"); address=request.getParameter("address"); phone=request.getParameter("phone"); type=request.getParameter("type"); sql="insert into tb_Enterprise values('"+name+"','"+address+"','"+phone+"','"+type+"')"; i=data.getint(sql); if(i>0){ %> <%}}%> <% if(request.getParameter("change")!=null){ id=request.getParameter("id"); name=request.getParameter("name"); address=request.getParameter("address"); phone=request.getParameter("phone"); type=request.getParameter("type"); sql="update tb_Enterprise set Name='"+name+"',Address='"+address+"',Phone='"+phone+"',Style='"+type+"' where ID="+Integer.parseInt(request.getParameter("id")); i=data.getint(sql); if(i>0){ %> <%}}%> <% if((request.getParameter("id")!=null)&&(!request.getParameter("id").equals(""))){ sql="select * from tb_Enterprise where ID="+Integer.parseInt(request.getParameter("id")); rs=data.getrs(sql); } else{rs=null;} %>
Enterprise_Add.jsp?action=add<%}else{%>Enterprise_Add.jsp?change=change<%}%>">
<%if((request.getParameter("id")!=null)&&(!request.getParameter("id").equals(""))){%>企 业 数 据 修 改<%}else{%>企 业 数 据 添 加<%}%>
企业名称:
<%}}%>"> <%if(rs!=null){rs.beforeFirst();%><%}%>"><%}%>
企业地址:
<%}}%>" size="40">
联系电话:
<%}}%>" size="20">
企业类别:
添 加 <%}else{%> 修 改 <%}%>">
 
<%if(rs!=null){rs.close();data.close();}%>