基于JSP设计的教务系统中的学生信息管理系统 - 图文

<% String num=(String)session.getAttribute(\); if(num==null) num =\; %>

\ />

AddRecord.tag

<%@ tag pageEncoding=\ %>

<%@ tag import=\ %>

<%@ attribute name=\ required=\ %> <%@ attribute name=\ required=\ %> <%@ attribute name=\ required=\ %> <%@ attribute name=\ required=\ %> <%@ attribute name=\ required=\ %> <%@ attribute name=\ required=\ %> <%@ attribute name=\ required=\ %> <%@ attribute name=\ required=\ %> <%@ attribute name=\ required=\ %> <%@ attribute name=\ required=\ %> <%

String condition=

\+

\+\+number+\+name+\+sex+\+date+\+clas+\+minzu+\+phone+\+zzmm+\+address+\+zhuanye+\; try{ Class.forName(\); }

catch(Exception e){} Connection con; Statement sql; ResultSet rs; try{ String uri=

\+

\; con=DriverManager.getConnection(uri); sql=con.createStatement(); sql.executeUpdate(condition); con.close(); }

catch(Exception e){ out.print(\+e); } %>

ClassConditon.tag

<%@ tag pageEncoding=\ %> <%@ tag import=\ %>

<%@ attribute name=\ required=\ %>

<%@ variable name-given=\ scope=\ %> <% StringBuffer result; result=new StringBuffer();

try{ Class.forName(\);

}

catch(Exception e){} Connection con; Statement sql; ResultSet rs; int n=0;

try{ result.append(\); String uri=

\+

\; con=DriverManager.getConnection(uri); DatabaseMetaData metadata=con.getMetaData();

ResultSet rs1=metadata.getColumns(null,null,\,null); int 字段个数=10; result.append(\);

result.append(\+\学号\); result.append(\+\姓名\); result.append(\+\性别\); result.append(\+\出生日期\); result.append(\+\班级\); result.append(\+\民族\); result.append(\+\联系方式\); result.append(\+\政治面貌\); result.append(\+\家庭住址\); result.append(\+\专业\); result.append(\); sql=con.createStatement(); String condition=

\+banji+\; rs=sql.executeQuery(condition); while(rs.next()){

result.append(\); for(int k=1;k<=字段个数;k++)

result.append(\+rs.getString(k)+\); result.append(\); }

result.append(\); con.close(); }

catch(SQLException e){ result.append(e); }

jspContext.setAttribute(\,new String(result)); %>

DelRecord.tag

<%@ tag pageEncoding=\ %> <%@ tag import=\ %>

<%@ attribute name=\ required=\ %> <% String condition =

\+number+\; try{ Class.forName(\); }

catch(Exception e){} Connection con; Statement sql; ResultSet rs; try{ String uri=

\+

\; con=DriverManager.getConnection(uri);

con=DriverManager.getConnection(uri,\,\); sql=con.createStatement(); sql.executeUpdate(condition); con.close(); }

catch(Exception e){ out.print(\+e); } %>

KeyWord.tag

<%@ tag pageEncoding=\ %> <%@ tag import=\ %>

<%@ attribute name=\ required=\ %> <%@ attribute name=\ required=\ %>

<%@ variable name-given=\ scope=\ %> <%

String condition=\+ziduan+\'%\+keyWord+\; StringBuffer result; result=new StringBuffer();

try{ Class.forName(\); }

catch(Exception e){} Connection con; Statement sql; ResultSet rs;