新建 文本文档.jsp

这个也是师兄的毕业设计,具体的功能我也不清楚,不过是可以用来答辩的,完整的毕业设计,有源代码,可执行文件,文档资料.

<%if (id!=0)
	{
		sqlstr="delete from student where id=?";
		ps=conn.prepareStatement(sqlstr);
		ps.setInt(1,id);
		ps.executeUpdate();
	}
	sqlstr="select * from student";
	ps=conn.prepareStatement(sqlstr);
	result=ps.executeQuery();
/*/////////////////////////////////////////////
  String xh="";
  String xm="";
  if (request.getParameter("xh")!="") xh=request.getParameter("xh");
  if (request.getParameter("xm")!="") xm=request.getParameter("xm");
  if ((xh.compareTo(""))!=0 & xm.compareTo("")=0)
  { ps=conn.prepareStatement("select * from student where s_id=?");
    ps.setString(1,xh);
	Qresult=ps.executeQuery();}
/////////////////////////////////////////////////////////////*/
//while(Qresult.next())
//{%>
<table width="75%" border="0" align="center" class="table">
    <tr align="center" class="table">
      <td width="13%" class="table">学号</td>
      <td width="13%" class="table">密码</td>
      <td width="13%" class="table">姓名</td>
      <td width="13%" class="table">性别</td>
      <td width="13%" class="table">专业</td>
      <td width="23%" class="table">年级</td>
      <td width="12%" class="table">操作</td>
    </tr>
	
   <tr align="center" class="table">
		  <td class="table"><%//= result.getString("s_id") %>&nbsp;</td>
      <td class="table"><%//= result.getString("s_paw") %>&nbsp;</td>
      <td class="table"><%//= result.getString("s_name") %>&nbsp;</td>
      <td class="table"><%//= (result.getString("sex")!=null?result.getString("sex"):"") %>&nbsp;</td>
      <td class="table"><%//= (result.getString("major")!=null?result.getString("major"):"") %>&nbsp;</td>
      <td class="table"><%//= (result.getString("grade")!=null?result.getString("grade"):"") %>&nbsp;</td>
	  <td class="table"><a href="addobject.jsp?id=<%//=result.getString("id")%>">删除</a></td>
	   </tr>

	   <!--hr width="500" class="table"-->
  <table width="75%"  border="0" align="center" class="table">
    <tr align="center" class="table">
      <td width="13%" class="table">学号</td>
      <td width="13%" class="table">密码</td>
      <td width="13%" class="table">姓名</td>
      <td width="13%" class="table">性别</td>
      <td width="13%" class="table">专业</td>
      <td width="23%" class="table">年级</td>
      <td width="12%" class="table">操作</td>
    </tr>
   
  </table>
  <p><br>
  </p>
  <p class="banquan"><font color="#333333"></font></p>
  <p>&nbsp; </p>
  </table>
  <p><br>
  </p>
	 <%//break;
	// }%>

<%
	while (result.next())
	{
	%>
	<tr align="center" class="table">
		  <td class="table"><%= result.getString("s_id") %>&nbsp;</td>
      <td class="table"><%= result.getString("s_paw") %></td>
      <td class="table"><%= result.getString("s_name") %>&nbsp;</td>
      <td class="table"><%= (result.getString("sex")!=null?result.getString("sex"):"") %>&nbsp;</td>
      <td class="table"><%= (result.getString("major")!=null?result.getString("major"):"") %>&nbsp;</td>
      <td class="table"><%= (result.getString("grade")!=null?result.getString("grade"):"") %>&nbsp;</td>
      <td class="table"><a href="addobject.jsp?id=<%=result.getString("id")%>">删除</a></td>
	  <%
	  }
	  %>
    </tr>