%@ 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;}
%>
<%if((request.getParameter("id")!=null)&&(!request.getParameter("id").equals(""))){%>企 业 数 据 修 改<%}else{%>企 业 数 据 添 加<%}%> |
|
<%if(rs!=null){rs.close();data.close();}%>