📄 articleeditcharge.jsp

📁 学生学籍管理系统sql 学生学籍管理系统sql
💻 JSP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<%@ page language="java" contentType="text/html; charset=gb2312" pageEncoding="gb2312"%>
<%@page  import="com.record.connectionDataBase.ConnectionDataBase,com.record.publicCode.PrintModifyValue,java.sql.Connection,java.sql.PreparedStatement,java.sql.Statement,java.sql.ResultSet"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312" />
<meta http-equiv="Content-Language" content="zh-CN" />
<meta name="robots" content="all" />
<meta name="author" content="WanfuZheng | www.52ay.com" />
<meta name="Copyright" content="Copyright (c) 2000-2005 www.52ay.com" />
<link rel="icon" href="/favicon.ico" type="image/x-icon" media="screen" />
<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon" media="screen" />
<link rel="stylesheet" href="css/style.css" type="text/css" media="all" />
<meta name="description" content="网页制作" />
<meta name="keywords" content="e266@163.com,http://blog.46com.com,郑万福(qq:30401653),制作,卧龙工作室,天翼数码,网站制作,Falsh,下载,成都,多媒体制作,asp,jsp,php,sql,mssql,mysql,酷网站,图标,音乐,mp3" />
<style>
	input{border:1px solid #999; height:30px;width:60px;padding:4px 0px 4px 0px;font-size:18px;margin:2px;}
	.inp1{border:1px solid #999; height:25px;width:150px;padding:4px 0px 4px 0px;font-size:18px;margin:2px;}
	.inp2{border:1px solid #999; height:25px;width:100px;padding:4px 0px 4px 0px;font-size:18px;margin:2px;}
	.btn{}
</style>

<title>Insert title here</title>
<script language="javascript" src="/pages/js/command.js"></script>

</head>
<%
	request.setCharacterEncoding("gb2312");
	String action="";
	action=request.getParameter("action");
	//out.print(action.equals("delAll"));
	int s_id=0;
	//学生信息
	String s_no,s_class,s_code,s_name,s_sex,s_birthday,s_knowledge,s_tel,s_card,s_address,s_signaddress,s_studyaddress;
	//1学生信息
	s_no=request.getParameter("s_no");
	//out.print(s_no);
	s_class=request.getParameter("s_class");
	s_code=request.getParameter("s_code");
	s_name=request.getParameter("s_name");
	s_sex=request.getParameter("s_sex");
	s_birthday=request.getParameter("s_birthday");
	s_knowledge=request.getParameter("s_knowledge");
	s_tel=request.getParameter("s_tel");
	s_card=request.getParameter("s_card");
	s_address=request.getParameter("s_address");
	s_signaddress=request.getParameter("s_signaddress");
	s_studyaddress=request.getParameter("s_studyaddress");
	int id=Integer.parseInt(request.getParameter("id"));
	ConnectionDataBase connectionDataBase= new ConnectionDataBase();
	PrintModifyValue printModifyValue=new PrintModifyValue();
	
	if(action.equals("add"))
	{
		String sql="insert into student(s_no,s_class,s_code,s_name,s_sex,s_birthday,s_knowledge,s_tel,s_card,s_address,s_signaddress,s_studyaddress) values('"+s_no+"','"+s_class+"','"+s_code+"','"+s_name+"','"+s_sex+"','"+s_birthday+"','"+s_knowledge+"','"+s_tel+"','"+s_card+"','"+s_address+"','"+s_signaddress+"','"+s_studyaddress+"')";
		PreparedStatement pstmt1;
		pstmt1=connectionDataBase.getConn().prepareStatement(sql);
		pstmt1.executeUpdate();
	}
	else if(action.equals("modify"))
	{
		String sql="update student set s_no='"+s_no+"',s_class='"+s_class+"',s_name='"+s_name+"',s_sex='"+s_sex+"',s_birthday='"+s_birthday+"',s_knowledge='"+s_knowledge+"',s_tel='"+s_tel+"',s_card='"+s_card+"',s_address='"+s_address+"',s_signaddress='"+s_signaddress+"',s_studyaddress='"+s_studyaddress+"' where id="+id;
		PreparedStatement pstmt1;
		pstmt1=connectionDataBase.getConn().prepareStatement(sql);
		pstmt1.executeUpdate();
	}
	else if(action.equals("del"))
	{
		int idd=Integer.parseInt(request.getParameter("id"));
		PreparedStatement pstmt1;
		String sql="delete student where id="+idd;
		//out.print(sql);
		pstmt1=connectionDataBase.getConn().prepareStatement(sql);
		pstmt1.executeUpdate();
		response.sendRedirect("ArticleList.jsp");
		
	}
	else if(action.equals("delAll"))
	{
		String delId=request.getParameter("delId");
		String [] delAllId=delId.split(",");
		PreparedStatement pstmt1;
		System.out.print(delAllId.length);
		for(int i=0;i<delAllId.length;i++){
			String sql="delete student where id="+delAllId[i];
			System.out.print(sql);
			pstmt1=connectionDataBase.getConn().prepareStatement(sql);
			pstmt1.executeUpdate();
		}
		
		response.sendRedirect("ArticleList.jsp");
	}
	
	String sqlStudentId="select id from student where s_name='"+s_name+"'";
	try {
		ResultSet rs=connectionDataBase.getConn().createStatement().executeQuery(sqlStudentId);
		if(rs.next())
		{
			s_id=rs.getInt("id");
		}
	} catch (Exception e) {
		// TODO: handle exception
	}

	
 %>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form action="ArticleAction.jsp?action=<%=action%>&id=<%=id%>" method="post" >
<input type="hidden" name="s_id" value="<%=s_id%>">
<table id="bd" border="0" cellpadding="0" cellspacing="1" width="95%" height="25" align="center" bgcolor="#999999">
  <tr bgcolor="#EEEEEE">
    <td align="left">管理首页 &gt;&gt; 报名交费登记表</td>
  </tr>
</table>
<table border="0" cellpadding="0" cellspacing="1" width="95%" align="center" bgcolor="#4881B7">
12 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -