无标题文档

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %> <%@ page import="com.bwm.db.Condb"%> 无标题文档 <% Condb con=new Condb(); String result=request.getParameter("result"); String mname=request.getParameter("mname"); String munit=request.getParameter("munit"); String moffice=request.getParameter("moffice"); int inttem=0; if(result!=null||result.equals("")||mname!=null||munit!=null||moffice!=null){ String str="select Member from tb_Member where MemID='"+result+"'"; ResultSet rs=con.executeQuery(str); while(rs.next()){ inttem++; } if(inttem==1){ %>

<%out.println("此成员ID已经被占用返回重新命名!");%>

<% } else if(inttem==0){ String sql="insert into tb_Member(MemID,Member,Munit,Moffice)values('"+result+"','"+mname+"','"+munit+"','"+moffice+"')"; con.executeUpdate(sql); %>

<%out.println("添加成功");%>

添加新成员

进入申报系统

<% } } con.close(); %>