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

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(); 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(\请输入模糊查询条件\); }

//返回foundResult对象:

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

NewRecord.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 condition1=\+name+ \+\+number+\ , condition2=\+sex+ \+\+number+\, condition3=\+date+ \+\+number+\, condition4=\+clas+ \+\+number+\, condition5=\+minzu+ \+\+number+\, condition6=\+phone+ \+\+number+\, condition7=\+zzmm+ \+\+number+\,

condition8=\+address+ \+\+number+\, condition9=\+zhuanye+ \+\+number+\; try{ Class.forName(\); }

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

\+

\; con=DriverManager.getConnection(uri); sql=con.createStatement(); sql.executeUpdate(condition1); sql.executeUpdate(condition2); sql.executeUpdate(condition3); sql.executeUpdate(condition4); sql.executeUpdate(condition5); sql.executeUpdate(condition6); sql.executeUpdate(condition7);

sql.executeUpdate(condition8); sql.executeUpdate(condition9); con.close(); }

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

NumberConditon.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=

\+number+\; 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)); %>

SortTag.tag

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

<%@ attribute name=\ required=\ %> <%@ variable name-given=\ scope=\ %> <% String orderCondition=

\+orderType; 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();

rs=sql.executeQuery(orderCondition); 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(\); }

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