usereditaction.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"%>
<%
	String action,name,password,type;
	action=request.getParameter("action");
	name=request.getParameter("name");
	password=request.getParameter("password");
	type=request.getParameter("type");
	if(null==action && null==name && null==password && null==type){
		response.sendRedirect("UserList.jsp");
		return;
		}
	PreparedStatement pstmt;
	ConnectionDataBase connectionDataBase= new ConnectionDataBase();
	if(action.equals("add"))
	{
		String sql="insert into admin (name,password,type) values('"+name+"','"+password+"','"+type+"')";
		out.print(sql);
		pstmt=connectionDataBase.getConn().prepareStatement(sql);
		pstmt.executeUpdate();
		response.sendRedirect("UserList.jsp");
	}
	else if(action.equals("modify"))
	{
		int id=Integer.parseInt(request.getParameter("id"));
		String sql="update admin set name='"+name+"',password='"+password+"',type='"+type+"' where id="+id;
		System.out.print(sql);
		pstmt=connectionDataBase.getConn().prepareStatement(sql);
		pstmt.executeUpdate();
		response.sendRedirect("UserList.jsp");
	}
	else if(action.equals("del"))
	{
		int id=Integer.parseInt(request.getParameter("id"));
		String sql="delete admin where id="+id;
		out.print(sql);
		pstmt=connectionDataBase.getConn().prepareStatement(sql);
		pstmt.executeUpdate();
		response.sendRedirect("UserList.jsp");
	}
	else if(action.equals("delAll"))
	{
		String delId=request.getParameter("delId");
		String [] delAllId=delId.split(",");
		System.out.print(delAllId.length);
		for(int i=0;i<delAllId.length;i++){
			String sql="delete admin where id="+delAllId[i];
			System.out.print(sql);
			pstmt=connectionDataBase.getConn().prepareStatement(sql);
			pstmt.executeUpdate();
		}
		
		response.sendRedirect("UserList.jsp");
	}
	
%>