articleaction.jsp

学生学籍管理系统sql 学生学籍管理系统sql

<%@ page language="java" contentType="text/html; charset=gb2312" pageEncoding="GBK"%>
<%@page  import="com.record.connectionDataBase.ConnectionDataBase,java.sql.Connection,java.sql.PreparedStatement,java.sql.Statement"%>
<%
	request.setCharacterEncoding("GBK");
	int s_id=Integer.parseInt(request.getParameter("s_id"));
	int id=Integer.parseInt(request.getParameter("id"));
	String action=request.getParameter("action");
	//费用信息
	String c_selectmoney1,c_selectmoney2,c_selectmoney3;
	String c_housermoney1,c_housermoney2,c_housermoney3;
	String c_toolmoney1,c_toolmoney2,c_toolmoney3;
	String c_checkmoney1,c_checkmoney2,c_checkmoney3;
	String c_other1,c_other2,c_other3;
	String c_summoney1,c_summoney2,c_summoney3;
	String c_teacher1,c_teacher2,c_teacher3;
	//学年信息
	String d_people11,d_people12,d_people13,d_people21,d_people22,d_people23,d_people31,d_people32,d_people33,d_people41,d_people42,d_people43,d_people51,d_people52,d_people53;
	String d_description11,d_description12,d_description13,d_description21,d_description22,d_description23,d_description31,d_description32,d_description33,d_description41,d_description42,d_description43,d_description51,d_description52,d_description53;
	
	
	//取值
	
	//2费用信息
	c_selectmoney1=request.getParameter("c_selectmoney1");
	c_selectmoney2=request.getParameter("c_selectmoney2");
	c_selectmoney3=request.getParameter("c_selectmoney3");
	c_housermoney1=request.getParameter("c_housermoney1");
	c_housermoney2=request.getParameter("c_housermoney2");
	c_housermoney3=request.getParameter("c_housermoney3");
	c_toolmoney1=request.getParameter("c_toolmoney1");
	c_toolmoney2=request.getParameter("c_toolmoney2");
	c_toolmoney3=request.getParameter("c_toolmoney3");
	c_checkmoney1=request.getParameter("c_checkmoney1");
	c_checkmoney2=request.getParameter("c_checkmoney2");
	c_checkmoney3=request.getParameter("c_checkmoney3");
	c_other1=request.getParameter("c_other1");
	c_other2=request.getParameter("c_other2");
	c_other3=request.getParameter("c_other3");
	c_summoney1=request.getParameter("c_summoney1");
	c_summoney2=request.getParameter("c_summoney2");
	c_summoney3=request.getParameter("c_summoney3");
	c_teacher1=request.getParameter("c_teacher1");
	c_teacher2=request.getParameter("c_teacher2");
	c_teacher3=request.getParameter("c_teacher3");
	
	//3学年信息
	d_description11=request.getParameter("d_description11");
	d_description12=request.getParameter("d_description12");
	d_description13=request.getParameter("d_description13");
	d_description21=request.getParameter("d_description21");
	d_description22=request.getParameter("d_description22");
	d_description23=request.getParameter("d_description23");
	d_description31=request.getParameter("d_description31");
	d_description32=request.getParameter("d_description32");
	d_description33=request.getParameter("d_description33");
	d_description41=request.getParameter("d_description41");
	d_description42=request.getParameter("d_description42");
	d_description43=request.getParameter("d_description43");
	d_description51=request.getParameter("d_description51");
	d_description52=request.getParameter("d_description52");
	d_description53=request.getParameter("d_description53");
	
	
	d_people11=request.getParameter("d_people11");
	d_people12=request.getParameter("d_people12");
	d_people13=request.getParameter("d_people13");
	d_people21=request.getParameter("d_people21");
	d_people22=request.getParameter("d_people22");
	d_people23=request.getParameter("d_people23");
	d_people31=request.getParameter("d_people31");
	d_people32=request.getParameter("d_people32");
	d_people33=request.getParameter("d_people33");
	d_people41=request.getParameter("d_people41");
	d_people42=request.getParameter("d_people42");
	d_people43=request.getParameter("d_people43");
	d_people51=request.getParameter("d_people51");
	d_people52=request.getParameter("d_people52");
	d_people53=request.getParameter("d_people53");
	
	
	PreparedStatement pstmt1,pstmt2,pstmt3,pstmt4,pstmt5,pstmt6,pstmt7,pstmt8,pstmt9,pstmt10,pstmt11,pstmt12,pstmt13,pstmt14,pstmt15,pstmt16,pstmt17,pstmt18,pstmt19;
	ConnectionDataBase connectionDataBase= new ConnectionDataBase();
	
	String sqlchange1="";
	String sqlchange2="";
	String sqlchange3="";
	
	String sqldetail11="";
	String sqldetail12="";
	String sqldetail13="";
	String sqldetail14="";
	String sqldetail15="";
	
	String sqldetail21="";
	String sqldetail22="";
	String sqldetail23="";
	String sqldetail24="";
	String sqldetail25="";
	
	String sqldetail31="";
	String sqldetail32="";
	String sqldetail33="";
	String sqldetail34="";
	String sqldetail35="";
	
		if(action.equals("add")){
			sqlchange1="insert into charge values("+s_id+",'"+c_selectmoney1+"','"+c_housermoney1+"','"+c_toolmoney1+"','"+c_checkmoney1+"','"+c_other1+"','"+c_teacher1+"','1')";
			sqlchange2="insert into charge values("+s_id+",'"+c_selectmoney2+"','"+c_housermoney2+"','"+c_toolmoney2+"','"+c_checkmoney2+"','"+c_other2+"','"+c_teacher2+"','2')";
			sqlchange3="insert into charge values("+s_id+",'"+c_selectmoney3+"','"+c_housermoney3+"','"+c_toolmoney3+"','"+c_checkmoney3+"','"+c_other3+"','"+c_teacher3+"','3')";
			
			sqldetail11="insert into detail values("+s_id+",'学费','"+d_description11+"','"+d_people11+"','1')";
			sqldetail12="insert into detail values("+s_id+",'住宿费','"+d_description21+"','"+d_people21+"','1')";
			sqldetail13="insert into detail values("+s_id+",'工具费','"+d_description31+"','"+d_people31+"','1')";
			sqldetail14="insert into detail values("+s_id+",'考核费','"+d_description41+"','"+d_people41+"','1')";
			sqldetail15="insert into detail values("+s_id+",'其他','"+d_description51+"','"+d_people51+"','1')";
			
			sqldetail21="insert into detail values("+s_id+",'学费','"+d_description12+"','"+d_people12+"','2')";
			sqldetail22="insert into detail values("+s_id+",'住宿费','"+d_description22+"','"+d_people22+"','2')";
			sqldetail23="insert into detail values("+s_id+",'工具费','"+d_description32+"','"+d_people32+"','2')";
			sqldetail24="insert into detail values("+s_id+",'考核费','"+d_description42+"','"+d_people42+"','2')";
			sqldetail25="insert into detail values("+s_id+",'其他','"+d_description52+"','"+d_people52+"','2')";
			
			sqldetail31="insert into detail values("+s_id+",'学费','"+d_description13+"','"+d_people13+"','3')";
			sqldetail32="insert into detail values("+s_id+",'住宿费','"+d_description23+"','"+d_people23+"','3')";
			sqldetail33="insert into detail values("+s_id+",'工具费','"+d_description33+"','"+d_people33+"','3')";
			sqldetail34="insert into detail values("+s_id+",'考核费','"+d_description43+"','"+d_people43+"','3')";
			sqldetail35="insert into detail values("+s_id+",'其他','"+d_description53+"','"+d_people53+"','3')";
		}
		else if(action.equals("modify")){
			sqlchange1="update charge set c_selectmoney='"+c_selectmoney1+"',c_housermoney='"+c_housermoney1+"',c_toolmoney='"+c_toolmoney1+"',c_checkmoney='"+c_checkmoney1+"',c_other='"+c_other1+"',c_teacher='"+c_teacher1+"' where s_id="+s_id+" and c_term='1'";
			sqlchange2="update charge set c_selectmoney='"+c_selectmoney2+"',c_housermoney='"+c_housermoney2+"',c_toolmoney='"+c_toolmoney2+"',c_checkmoney='"+c_checkmoney2+"',c_other='"+c_other2+"',c_teacher='"+c_teacher2+"' where s_id="+s_id+" and c_term='2'";
			sqlchange3="update charge set c_selectmoney='"+c_selectmoney3+"',c_housermoney='"+c_housermoney3+"',c_toolmoney='"+c_toolmoney3+"',c_checkmoney='"+c_checkmoney3+"',c_other='"+c_other3+"',c_teacher='"+c_teacher3+"' where s_id="+s_id+" and c_term='3'";
			
			sqldetail11="update detail set d_description='"+d_description11+"',d_people='"+d_people11+"' where s_id="+s_id+" and d_type='学费' and c_term='1'";
			sqldetail12="update detail set d_description='"+d_description21+"',d_people='"+d_people21+"' where s_id="+s_id+" and d_type='住宿费' and c_term='1'";
			sqldetail13="update detail set d_description='"+d_description31+"',d_people='"+d_people31+"' where s_id="+s_id+" and d_type='工具费' and c_term='1'";
			sqldetail14="update detail set d_description='"+d_description41+"',d_people='"+d_people41+"' where s_id="+s_id+" and d_type='考核费' and c_term='1'";
			sqldetail15="update detail set d_description='"+d_description51+"',d_people='"+d_people51+"' where s_id="+s_id+" and d_type='其他' and c_term='1'";
			
			sqldetail21="update detail set d_description='"+d_description12+"',d_people='"+d_people12+"' where s_id="+s_id+" and d_type='学费' and c_term='2'";
			sqldetail22="update detail set d_description='"+d_description22+"',d_people='"+d_people22+"' where s_id="+s_id+" and d_type='住宿费' and c_term='2'";
			sqldetail23="update detail set d_description='"+d_description32+"',d_people='"+d_people32+"' where s_id="+s_id+" and d_type='工具费' and c_term='2'";
			sqldetail24="update detail set d_description='"+d_description42+"',d_people='"+d_people42+"' where s_id="+s_id+" and d_type='考核费' and c_term='2'";
			sqldetail25="update detail set d_description='"+d_description52+"',d_people='"+d_people52+"' where s_id="+s_id+" and d_type='其他' and c_term='2'";
			
			sqldetail31="update detail set d_description='"+d_description13+"',d_people='"+d_people13+"' where s_id="+s_id+" and d_type='学费' and c_term='3'";
			sqldetail32="update detail set d_description='"+d_description23+"',d_people='"+d_people23+"' where s_id="+s_id+" and d_type='住宿费' and c_term='3'";
			sqldetail33="update detail set d_description='"+d_description33+"',d_people='"+d_people33+"' where s_id="+s_id+" and d_type='工具费' and c_term='3'";
			sqldetail34="update detail set d_description='"+d_description43+"',d_people='"+d_people43+"' where s_id="+s_id+" and d_type='考核费' and c_term='3'";
			sqldetail35="update detail set d_description='"+d_description53+"',d_people='"+d_people53+"' where s_id="+s_id+" and d_type='其他' and c_term='3'";
			
		}
		
		
		pstmt2=connectionDataBase.getConn().prepareStatement(sqlchange1);
		pstmt3=connectionDataBase.getConn().prepareStatement(sqlchange2);
		pstmt4=connectionDataBase.getConn().prepareStatement(sqlchange3);
		
		pstmt5=connectionDataBase.getConn().prepareStatement(sqldetail11);
		pstmt6=connectionDataBase.getConn().prepareStatement(sqldetail12);
		pstmt7=connectionDataBase.getConn().prepareStatement(sqldetail13);
		pstmt8=connectionDataBase.getConn().prepareStatement(sqldetail14);
		pstmt9=connectionDataBase.getConn().prepareStatement(sqldetail15);
		
		pstmt10=connectionDataBase.getConn().prepareStatement(sqldetail21);
		pstmt11=connectionDataBase.getConn().prepareStatement(sqldetail22);
		pstmt12=connectionDataBase.getConn().prepareStatement(sqldetail23);
		pstmt13=connectionDataBase.getConn().prepareStatement(sqldetail24);
		pstmt14=connectionDataBase.getConn().prepareStatement(sqldetail25);
		
		pstmt15=connectionDataBase.getConn().prepareStatement(sqldetail31);
		pstmt16=connectionDataBase.getConn().prepareStatement(sqldetail32);
		pstmt17=connectionDataBase.getConn().prepareStatement(sqldetail33);
		pstmt18=connectionDataBase.getConn().prepareStatement(sqldetail34);
		pstmt19=connectionDataBase.getConn().prepareStatement(sqldetail35);
		
		
		
		pstmt2.executeUpdate();
		pstmt3.executeUpdate();
		pstmt4.executeUpdate();
		pstmt5.executeUpdate();
		pstmt6.executeUpdate();
		pstmt7.executeUpdate();
		pstmt8.executeUpdate();
		pstmt9.executeUpdate();
		pstmt10.executeUpdate();
		pstmt11.executeUpdate();
		pstmt12.executeUpdate();
		pstmt13.executeUpdate();
		pstmt14.executeUpdate();
		pstmt15.executeUpdate();
		pstmt16.executeUpdate();
		pstmt17.executeUpdate();
		pstmt18.executeUpdate();
		pstmt19.executeUpdate();
		
		response.sendRedirect("ArticleList.jsp");
	
%>