|
<%
oldNum = num;
num = 9;
counter = 0;
out.print("
");
out.print(" ![](\"images/newsBT.gif\"){kind=small} ");//数学相关的新闻out.print(" "); try{ rs = stmt.executeQuery("select * from news order by pdate desc"); counter = 1; while(rs.next()){ out.println(" ![](\"images/listDot.jpg\"){kind=small} ");
out.print("");
out.println(rs.getString("subject"));
out.println("");
out.println(""); counter++; if(counter > num){ more = true; counter = 0; break; } } if(more == true){ more = false; out.println(" "); %> "); if(rs!=null){ rs.close(); } %> |
<%
oldNum = num;
num = 19;
counter = 0;
try{
class1="镜像站点";
class2="协会组织";
out.print("
");
out.print("协会组织站点镜像");//协会 ");
sql = "select id,class1,class2,subject,url,pby,pdate from data where class1='"+class1+"' and class2='"+class2+"' order by class1,class2,subject";
//out.print(sql);
rs = stmt.executeQuery(sql);
out.print("out.print(" "); ////////////// if(rs.first()){//数据非空 try{ int s = rs.getRow(); rs.last(); int e = rs.getRow(); itemNum = e-s+1; }catch(SQLException ex){ out.print(ex.getMessage()); } rs.first(); do{ out.println(" ");
out.print("");
out.println(rs.getString("subject"));
out.println("");
out.println(""); counter++; if(counter > num){ more = true; counter = 0; break; } }while(rs.next()); if(more == true){ more = false; out.println(" "); %> "); if(rs!=null){ rs.close(); } %> |
||
|
<%
oldNum = num;
num = 12;
counter = 0;
try{
class1="南开资源";
out.print("
");
out.print(class1);
out.print(" ");
//class2="期刊";
//sql = "select id,class1,class2,subject,url,pby,pdate from data where class1='"+class1+"' and class2='"+class2+"' order by class1,class2,subject";
sql = "select id,class1,class2,subject,url,pby,pdate from data where class1='"+class1+"' order by class1,class2,subject";
//out.print(sql);
rs = stmt.executeQuery(sql);
out.print(""); ////////////// if(rs.first()){//数据非空 try{ int s = rs.getRow(); rs.last(); int e = rs.getRow(); itemNum = e-s+1; }catch(SQLException ex){ out.print(ex.getMessage()); } rs.first(); do{ out.println(" ");
out.print("");
out.println(rs.getString("subject"));
out.println("");
out.println(""); counter++; if(counter >num){ more = true; counter = 0; break; } }while(rs.next()); if(more == true){ more = false; out.println(" "); %> "); if(rs!=null){ rs.close(); } %> |
<%
oldNum = num;
num = 13;
counter = 0;
try{
class1="镜像站点";
class2="大学院所";
out.print("
");
out.print("大学院所站点镜像");
out.print(" ");
sql = "select id,class1,class2,subject,url,pby,pdate from data where class1='"+class1+"' and class2='"+class2+"' order by class1,class2,subject";
//out.print(sql);
rs = stmt.executeQuery(sql);
out.print(""); ////////////// if(rs.first()){//数据非空 try{ int s = rs.getRow(); rs.last(); int e = rs.getRow(); itemNum = e-s+1; }catch(SQLException ex){ out.print(ex.getMessage()); } rs.first(); do{ out.println(" ");
out.print("");
out.println(rs.getString("subject"));
out.println("");
out.println(""); counter++; if(counter > num){ more = true; counter = 0; break; } }while(rs.next()); if(more == true){ more = false; out.println(" "); %> "); if(rs!=null){ rs.close(); } %> |
||
|
<%
oldNum = num;
num = 11;
counter = 0;
try{
class1="Net资源";
class2="期刊";
out.print("
");
out.print("期刊网址");
out.print(" ");
sql = "select id,class1,class2,subject,url,pby,pdate from data where class1='"+class1+"' and class2='"+class2+"' order by class1,class2,subject";
//out.print(sql);
rs = stmt.executeQuery(sql);
//////////////
if(rs.first()){//数据非空
try{
int s = rs.getRow();
rs.last();
int e = rs.getRow();
itemNum = e-s+1;
}catch(SQLException ex){
out.print(ex.getMessage());
}
rs.first();
do{
out.println("");
out.print("");
out.println(rs.getString("subject"));
out.println("");
out.println(""); counter++; if(counter >num){ more = true; counter = 0; break; } }while(rs.next()); if(more == true){ more = false; %> "); if(rs!=null){ rs.close(); } %> |
|||
|
<%
oldNum = num;
num = 11;
counter = 0;
boolean newRow = true;
boolean blankTd = false;
try{
class1="Net资源";
class2="数学软件";
out.print("
");
out.print("数学软件公司网址");
out.print(" ");
sql = "select id,class1,class2,subject,url,pby,pdate from data where class1='"+class1+"' and class2='"+class2+"' order by class1,class2,subject";
//out.print(sql);
rs = stmt.executeQuery(sql);
//////////////
if(rs.first()){//数据非空
try{
int s = rs.getRow();
rs.last();
int e = rs.getRow();
itemNum = e-s+1;
}catch(SQLException ex){
out.print(ex.getMessage());
}
rs.first();
do{
out.println("");
out.print("");
out.println(rs.getString("subject"));
out.println("");
out.println(""); counter++; if(counter >num){ more = true; counter = 0; break; } ///// /* try{ int s = rs.getRow(); rs.last(); int e = rs.getRow(); itemNum = e-s+1; }catch(SQLException ex){ out.print(ex.getMessage()); } if(itemNum > num){ if(num%2==0) blankTd = false; else blankTd = true; }else{ if(itemNum%2==0) blankTd = false; else blankTd = true; } rs.first(); do{ if(newRow == true){ out.print(" | ");
if(counter%2==1)
out.print("");
out.print("");
out.println(rs.getString("subject"));
out.println(""); if(rs!=null){ rs.close(); } %>
<%
oldNum = num;
num = 11;
counter = 0;
try{
class1="Net资源";
class2="数学学会";
out.print("
");
out.print("数学学会网址");
out.print(" ");
sql = "select id,class1,class2,subject,url,pby,pdate from data where class1='"+class1+"' and class2='"+class2+"' order by class1,class2,subject";
//out.print(sql);
rs = stmt.executeQuery(sql);
//////////////
if(rs.first()){//数据非空
try{
int s = rs.getRow();
rs.last();
int e = rs.getRow();
itemNum = e-s+1;
}catch(SQLException ex){
out.print(ex.getMessage());
}
rs.first();
do{
out.println("");
out.print("");
out.println(rs.getString("subject"));
out.println("");
out.println(""); counter++; if(counter >num){ more = true; counter = 0; break; } }while(rs.next()); if(more == true){ more = false; %> "); if(rs!=null){ rs.close(); } %> |
||
|
<%
oldNum = num;
num = 9;
counter = 0;
try{
class1="Net资源";
class2="数学机构";
out.print("
");
out.print("数学机构网址");
out.print(" ");
sql = "select id,class1,class2,subject,url,pby,pdate from data where class1='"+class1+"' and class2='"+class2+"' order by class1,class2,subject";
//out.print(sql);
rs = stmt.executeQuery(sql);
//////////////
if(rs.first()){//数据非空
try{
int s = rs.getRow();
rs.last();
int e = rs.getRow();
itemNum = e-s+1;
}catch(SQLException ex){
out.print(ex.getMessage());
}
rs.first();
do{
out.println("");
out.print("");
out.println(rs.getString("subject"));
out.println("");
out.println(""); counter++; if(counter >num){ more = true; counter = 0; break; } }while(rs.next()); if(more == true){ more = false; %> "); if(rs!=null){ rs.close(); } %>
<%
oldNum = num;
num = 11;
counter = 0;
try{
class1="Net资源";
class2="数学专题";
out.print("
");
out.print("数学各专业网址");
out.print(" ");
sql = "select id,class1,class2,subject,url,pby,pdate from data where class1='"+class1+"' and class2='"+class2+"' order by class1,class2,subject";
//out.print(sql);
rs = stmt.executeQuery(sql);
//////////////
if(rs.first()){//数据非空
try{
int s = rs.getRow();
rs.last();
int e = rs.getRow();
itemNum = e-s+1;
}catch(SQLException ex){
out.print(ex.getMessage());
}
rs.first();
do{
out.println("");
out.print("");
out.println(rs.getString("subject"));
out.println("");
out.println(""); counter++; if(counter >num){ more = true; counter = 0; break; } }while(rs.next()); if(more == true){ more = false; %> "); if(rs!=null){ rs.close(); } %> |
|||
|
<%
oldNum = num;
num = 9;
counter = 0;
try{
class1="Net资源";
class2="数学院系";
out.print("
");
out.print("数学院系网址");
out.print(" ");
sql = "select id,class1,class2,subject,url,pby,pdate from data where class1='"+class1+"' and class2='"+class2+"' order by class1,class2,subject";
//out.print(sql);
rs = stmt.executeQuery(sql);
//////////////
if(rs.first()){//数据非空
try{
int s = rs.getRow();
rs.last();
int e = rs.getRow();
itemNum = e-s+1;
}catch(SQLException ex){
out.print(ex.getMessage());
}
rs.first();
do{
out.println("");
out.print("");
out.println(rs.getString("subject"));
out.println("");
out.println(""); counter++; if(counter >num){ more = true; counter = 0; break; } }while(rs.next()); if(more == true){ more = false; %> "); if(rs!=null){ rs.close(); } %> |
|||
<%@ page import="java.io.*" %>
<%
//out.println(request.getHeader("Cookie"));
String currentRecord = null;//保存文本的变量
BufferedReader file; //BufferedReader对象，用于读取文件数据
String nameFile = "count.txt";
File f = null;
FileReader ff = null;
f = new File(nameFile);
try{
if(f.canRead()){
ff = new FileReader(f);
}else{
f.createNewFile();
ff = new FileReader(f);
}
}catch(FileNotFoundException ex){
}
//读取
file = new BufferedReader(ff);
String readStr =null;
int writeStr =0; //如果计数文本中的计数值为空则让它显示时变成1并写入
try{
readStr = file.readLine();
}catch (IOException e){
System.out.println("读取数据错误.");
}
if (readStr == null)
readStr = "没有任何记录"; //判断cookie,第一次登陆时加1,刷新时不累计计数
else if(request.getHeader("Cookie")==null){
writeStr = Integer.parseInt(readStr)+1;
}else{
writeStr = Integer.parseInt(readStr);
}
//写入时控制因为刷新引起的重复计数
if (request.getHeader("Cookie")==null){
try {
PrintWriter pw = new PrintWriter(new FileOutputStream(nameFile));
pw.println(writeStr);
pw.close();
}catch(IOException e){
out.println(e.getMessage());
}
}
%>
您是本站点第<%=writeStr%>位客人。
All original content copyright © 2006-2007 the School of Mathmatical Sciences,NanKai
University & CerNet.All other trademarks and copyrights on this site are owned by their respective owners.
