deletestudent.jsp

来自「这个也是师兄的毕业设计,具体的功能我也不清楚,不过是可以用来答辩的,完整的毕业设」· JSP 代码 · 共 80 行

<%@page import="java.util.*"%>
<%@ include file="change.jsp"%>
<%@ page language="java" import="java.sql.*"%>
<%@ include file="author.jsp" %>
<%request.setCharacterEncoding("gb2312");%>
<jsp:useBean id="linejdbc" scope="page" class="examinline.DBConnectionBean" />
<%linejdbc.setdrivername();%>
<%

Connection conn = linejdbc.getopenConnection();
PreparedStatement ps=null;
String sqlstr;
String S_id="";
String S_name="";
String Password="";
String sid="";
String Sex="";
String Major="";
String Grade="";
ResultSet result=null;
ResultSet Qresult=null;
int rs=0;
int id=0;
//boolean i=false;


if (request.getParameter("id")!=null)
  sid=((String)request.getParameter("id")).trim();
System.out.println(sid+"111111111");
if (sid.compareTo("")!=0)
	{ 
		System.out.println(sid+"2222222");
      
       try
		{
		   		System.out.println(sid+"33333333");
		sqlstr="delete from student where s_id=?";
		ps=conn.prepareStatement("delete from student where s_id=?");
				System.out.println(sid+ps);
		ps.setString(1,sid);
				System.out.println(ps+sqlstr);
		int t = ps.executeUpdate();
				System.out.println(t);



		if(t==1)
		{
			System.out.println("ddddddd");
		}

        sqlstr="delete from score where s_id=?";
		ps=conn.prepareStatement(sqlstr);
		ps.setString(1,sid);
		int mm = ps.executeUpdate();
        if (mm==1)
		{
			System.out.println("aaaaaaa");
		}

   sqlstr="select * from student";
	ps=conn.prepareStatement(sqlstr);
	Qresult=ps.executeQuery();

		}
		catch(SQLException ex)
		{
			
		}
		finally
		{
			//sid="";
        	conn.close();
		}
         
		//S_id="";
	   //}
	}
	response.sendRedirect("addadmin.jsp");
	%>