WebRoot/xzds/xzdsdo.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

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

<%
/*
选择导师添加后台
*/
DBO db=new DBO();
request.setCharacterEncoding("gb2312");
ResultSet rs=null;
	String keyid =(String)request.getParameter("keyid");
String xs=(String)request.getParameter("xs");
String ds=(String)request.getParameter("ds");
String zt=(String)request.getParameter("zt");
String sj=(String)request.getParameter("sj");
String bz=(String)request.getParameter("bz");

String sql="";
 
;//选择导师SQL 语句
int row=1;
		
try{
	sql="select count(*) as num from xzds where xs='"+xs+"' and ds='"+ds+"'";

	rs=db.query(sql);
	if(rs.next()){
	if(rs.getInt("num")>0){
	out.println("<script>");
out.println("alert('选择失败，你已经提交选择申请，或者已经选择');");
out.println("window.location='xzdsadd.jsp'");
out.println("</script>");
	return;
	}
	}	
	
	sql="insert into xzds(xs,ds,zt,sj,bz) values('"+xs+"','"+ds+"','"+zt+"','"+sj+"','"+bz+"')";
		//int row =0;
		row=db.update(sql);
}catch(Exception e){
System.out.println(e.toString());}
if(row==1){
out.println("<script>");
out.println("alert('操作成功');");
out.println("window.location='xzdsadd.jsp'");
out.println("</script>");
}else{
out.println("<script>");
out.println("alert('操作失败');");
out.println("window.location='xzdsadd.jsp'");
out.println("</script>");
}
db.close();
%>