<% String sql,sqlStr;
ResultSet rs=null;
sql="select * from lab where LabName='"+LabName+"' or LabAdd='"+LabAdd+"'";
rs=Add_DBBean.executeQuery(sql);
while(rs.next())
{
out.println("输入实验室已存在,3秒后自动返回");
session.putValue("welcome","输入实验室已存在,请重新输入");
%>
<jsp:forward page="add_record.jsp"/>
<%
}
sqlStr="insert into lab(LabName,LabAdd,LabSeat,Others) values('"+LabName+"','"+LabAdd+"','"+LabSeat+"','"+Others+"')";
Add_DBBean.executeUpdate(sqlStr);
%>
添加成功!3秒后自动<a href="add_record.jsp">返回</a>
<% response.setHeader("Refresh","3;URL=add_record.jsp");
}
%>
ResultSet rs=null;
sql="select * from lab where LabName='"+LabName+"' or LabAdd='"+LabAdd+"'";
rs=Add_DBBean.executeQuery(sql);
while(rs.next())
{
out.println("输入实验室已存在,3秒后自动返回");
session.putValue("welcome","输入实验室已存在,请重新输入");
%>
<jsp:forward page="add_record.jsp"/>
<%
}
sqlStr="insert into lab(LabName,LabAdd,LabSeat,Others) values('"+LabName+"','"+LabAdd+"','"+LabSeat+"','"+Others+"')";
Add_DBBean.executeUpdate(sqlStr);
%>
添加成功!3秒后自动<a href="add_record.jsp">返回</a>
<% response.setHeader("Refresh","3;URL=add_record.jsp");
}
%>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货