去书店!随便什么jsp都有!(不用给分
解决方案 »
- struts2 <s:url />标签传递参数乱码问题!
- 弹出选中列表信息
- 急,问个图片上传的小问题
- servlet 中的 自己写的 .java 文件 必须要手动 编译为 .class文件 么?
- 同一个页面上 jsp 传递参数的问题!
- 刚接触struts,对于action,actionform有点不明白
- JSP中如何将接收到文本框内容转化成小数?
- 在tomtac下怎么设置自己的主目录????
- 大虾们,我刚刚装了jsp的环境,谁能指点我的问题,我重分相送!
- 求个xpath的写法,不知道该怎么写了
- 关于用jsp处理上传下载遇到的问题(请路人甲和高手们指点)
- 接前面的《继续讨论文件目录处理的,高手指点!!》
http://61.144.28.245/hjc/web/doc/servlet-jsp/servlet-jsp4.html
package user;
import java.sql.*;public class check{
boolean right=true;
//¼ì²éÊÇ·ñÊý¾ÝΪ¿Õ
public boolean check_blank(String string){
boolean blank=true;
if(string==null||string.trim().compareTo("")==0)
blank=false;
return blank;
};//¼ì²éij¸ö×Ö·ûÊÇ·ñΪºÏ·¨×Ö·û
public boolean check_have(String[] words,String temp){
boolean have=true,have_tmp=false;
int i,j;
for(i=0;i<temp.length();i++){
String t=temp.substring(i,i+1);
for(j=0;j<words.length;j++){
have_tmp=false;
if(words[j].equals(t)){
have_tmp=true;
break;}
}
if(!have_tmp){
have=false;
break;
}}
return have;
}//¼ì²é×Ö·û´®Ê±ºòº¬ÓÐij¸ö×Ö·û
public boolean check_str_char(String str,String tag){
boolean have_tag=false;
int i;
for(i=0;i<str.length();i++){
if(str.substring(i,i+1).equals(tag))
have_tag=true;
}
return have_tag;
}//¼ì²éÓû§ÃûÊÇ·ñºÏ·¨
public boolean check_user(String str){
String[]
word={"a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p"
,"q","r","s","t","u","v","w","x","y","z","A","B","C","D","E","F","G",
"H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X",
"y","Z","0","1","2","3","4","5","6","7","8","9","_"};
if(str==null||str.trim().length()<3||str.trim().length()>20)
{right=false;}
else{
if(!check_have(word,str))
right=false;
}
return right;
}//¼ì²éÃÜÂëÊÇ·ñºÏ·¨
public boolean check_pass(String pass,String repass){
if(pass==null||pass.trim().length()<5||pass.trim().length()>20)
right=false;
else if(!pass.trim().equals(repass))
right=false;
return right;
}
//¼ì²éE-MailÊÇ·ñºÏ·¨
public boolean check_email(String email){
if(!check_str_char(email,"@")||!check_str_char(email,"."))
right=false;
return right;
}//¼ì²âÊÇ·ñÒѾ­×¢²á
public boolean check_user_have(String user){
int i=0;
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(java.lang.ClassNotFoundException e){
System.out.print(e);
}
try{
Conn=DriverManager.getConnection("jdbc:odbc:wangzhan","zijian","zijian");
Stmt=Conn.createStatement();
Rst=Stmt.executeQuery("select * from user_info where user_name='"+user+"'");
if(Rst.next())i=1;
Rst=Stmt.executeQuery("select * from teacher_info where user_name='"+user+"'");
if(Rst.next())i=1;
Rst.close();
Stmt.close();
Conn.close();}
catch(SQLException ex){
System.out.print(ex);}
if(i==0)return true;
else return false;
}
//ÅжÏÊÇ·ñ¿ÆÄ¿±»´´½¨
public boolean check_sub_have(String sub_name){
int i=0;
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(java.lang.ClassNotFoundException e){
System.out.print(e);
}
try{
Conn=DriverManager.getConnection("jdbc:odbc:wangzhan","zijian","zijian");
Stmt=Conn.createStatement();
Rst=Stmt.executeQuery("select * from teach_subject where sub_name='"+sub_name+"'");
if(Rst.next())right=false;
Rst.close();
Stmt.close();
Conn.close();}
catch(SQLException ex){
System.out.print(ex);}
return right;
}//ÅжÏÊÇ·ñÕ±»´´½¨
public boolean check_unit_have(String unit_name){
int i=0;
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(java.lang.ClassNotFoundException e){
System.out.print(e);
}
try{
Conn=DriverManager.getConnection("jdbc:odbc:wangzhan","zijian","zijian");
Stmt=Conn.createStatement();
Rst=Stmt.executeQuery("select * from teach_unit where unit_name='"+unit_name+"'");
if(Rst.next())right=false;
Rst.close();
Stmt.close();
Conn.close();}
catch(SQLException ex){
System.out.print(ex);}
return right;
}//ÅжÏÊÇ·ñ½Ú±»´´½¨
public boolean check_part_have(String part_name){
int i=0;
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(java.lang.ClassNotFoundException e){
System.out.print(e);
}
try{
Conn=DriverManager.getConnection("jdbc:odbc:wangzhan","zijian","zijian");
Stmt=Conn.createStatement();
Rst=Stmt.executeQuery("select * from teach_part where part_name='"+part_name+"'");
if(Rst.next())right=false;
Rst.close();
Stmt.close();
Conn.close();}
catch(SQLException ex){
System.out.print(ex);}
return right;
}
public boolean check_que_have(String que_name){
int i=0;
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(java.lang.ClassNotFoundException e){
System.out.print(e);
}
try{
Conn=DriverManager.getConnection("jdbc:odbc:wangzhan","zijian","zijian");
Stmt=Conn.createStatement();
Rst=Stmt.executeQuery("select * from teach_question where que_name='"+que_name+"'");
if(Rst.next())right=false;
Rst.close();
Stmt.close();
Conn.close();}
catch(SQLException ex){
System.out.print(ex);}
return right;
}
//ÅжÏÊÇ·ñbbsÂ۵㱻´´½¨
public boolean check_topic_have(String topic_name){
int i=0;
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(java.lang.ClassNotFoundException e){
System.out.print(e);
}
try{
Conn=DriverManager.getConnection("jdbc:odbc:wangzhan","zijian","zijian");
Stmt=Conn.createStatement();
Rst=Stmt.executeQuery("select * from bbs_topic where topic_name='"+topic_name+"'");
if(Rst.next())right=false;
Rst.close();
Stmt.close();
Conn.close();}
catch(SQLException ex){
System.out.print(ex);}
return right;
} //ÅжÏÊÇ·ñbbsÂ۵㱻ÊÕ²Ø
public boolean check_favlist_have(String user_name,int topic_id){
int i=0;
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(java.lang.ClassNotFoundException e){
System.out.print(e);
}
try{
Conn=DriverManager.getConnection("jdbc:odbc:wangzhan","zijian","zijian");
Stmt=Conn.createStatement();
Rst=Stmt.executeQuery("select * from bbs_favlist where fav_owner_name='"+user_name+"' and fav_topic_id='"+topic_id+"'");
if(Rst.next())right=false;
Rst.close();
Stmt.close();
Conn.close();}
catch(SQLException ex){
System.out.print(ex);}
return right;
} //ÅжÏÊÇ·ñbbsÂ۵㱻ÊÕ²Ø
public boolean check_quefav_have(String user_name,int que_id){
int i=0;
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(java.lang.ClassNotFoundException e){
System.out.print(e);
}
try{
Conn=DriverManager.getConnection("jdbc:odbc:wangzhan","zijian","zijian");
Stmt=Conn.createStatement();
Rst=Stmt.executeQuery("select * from teach_favlist where fav_owner_name='"+user_name+"' and fav_que_id='"+que_id+"'");
if(Rst.next())right=false;
Rst.close();
Stmt.close();
Conn.close();}
catch(SQLException ex){
System.out.print(ex);}
return right;
}
//ÓÃÖ¸¶¨µÄ×Ö·ûÌæ»»×Ö·û´®ÖÐij¸ö×Ö·û
public String replace(String con,String tag,String rep){
int j=0;
int i=0;
int k=0;
String RETU="";
String temp=con;
int tagc=tag.length();
while(i<con.length()){
if(con.substring(i).startsWith(tag)){
temp=con.substring(j,i)+rep;
RETU+=temp;
i+=tagc;
j=i;
}
else{i+=1;
}
}
RETU+=con.substring(j);
return RETU;
}//½ûÓÃHTML´úÂë±àÂë
public String html(String s){
String re;
re=replace(s,"<","<");
re=replace(re,">",">");
re=replace(re,"\n","<br>");
re=replace(re," "," ");
re=replace(re,"'","'");
return re;
}//УÓѼ¡ªÑ§Ð£Ãû³ÆÊÇ·ñÒѾ­´æÔÚ
public boolean check_school_have(String school_name){
int i=0;
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(java.lang.ClassNotFoundException e){
System.out.print(e);
}
try{
Conn=DriverManager.getConnection("jdbc:odbc:wangzhan","zijian","zijian");
Stmt=Conn.createStatement();
Rst=Stmt.executeQuery("select * from alumnus_school where school_name='"+school_name+"'");
if(Rst.next())right=false;
Rst.close();
Stmt.close();
Conn.close();}
catch(SQLException ex){
System.out.print(ex);}
return right;
} //УÓѼ¡ª°à¼¶Ãû³ÆÊÇ·ñÒѾ­´æÔÚ
public boolean check_class_have(String class_name){
int i=0;
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(java.lang.ClassNotFoundException e){
System.out.print(e);
}
try{
Conn=DriverManager.getConnection("jdbc:odbc:wangzhan","zijian","zijian");
Stmt=Conn.createStatement();
Rst=Stmt.executeQuery("select * from alumnus_class where class_name='"+class_name+"'");
if(Rst.next())right=false;
Rst.close();
Stmt.close();
Conn.close();}
catch(SQLException ex){
System.out.print(ex);}
return right;
}
}
public boolean check_que_have(String que_name){
int i=0;
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(java.lang.ClassNotFoundException e){
System.out.print(e);
}
try{
Conn=DriverManager.getConnection("jdbc:odbc:wangzhan","zijian","zijian");
Stmt=Conn.createStatement();
Rst=Stmt.executeQuery("select * from teach_question where que_name='"+que_name+"'");
if(Rst.next())right=false;
Rst.close();
Stmt.close();
Conn.close();}
catch(SQLException ex){
System.out.print(ex);}
return right;
}
//ÅжÏÊÇ·ñbbsÂ۵㱻´´½¨
public boolean check_topic_have(String topic_name){
int i=0;
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(java.lang.ClassNotFoundException e){
System.out.print(e);
}
try{
Conn=DriverManager.getConnection("jdbc:odbc:wangzhan","zijian","zijian");
Stmt=Conn.createStatement();
Rst=Stmt.executeQuery("select * from bbs_topic where topic_name='"+topic_name+"'");
if(Rst.next())right=false;
Rst.close();
Stmt.close();
Conn.close();}
catch(SQLException ex){
System.out.print(ex);}
return right;
} //ÅжÏÊÇ·ñbbsÂ۵㱻ÊÕ²Ø
public boolean check_favlist_have(String user_name,int topic_id){
int i=0;
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(java.lang.ClassNotFoundException e){
System.out.print(e);
}
try{
Conn=DriverManager.getConnection("jdbc:odbc:wangzhan","zijian","zijian");
Stmt=Conn.createStatement();
Rst=Stmt.executeQuery("select * from bbs_favlist where fav_owner_name='"+user_name+"' and fav_topic_id='"+topic_id+"'");
if(Rst.next())right=false;
Rst.close();
Stmt.close();
Conn.close();}
catch(SQLException ex){
System.out.print(ex);}
return right;
} //ÅжÏÊÇ·ñbbsÂ۵㱻ÊÕ²Ø
public boolean check_quefav_have(String user_name,int que_id){
int i=0;
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(java.lang.ClassNotFoundException e){
System.out.print(e);
}
try{
Conn=DriverManager.getConnection("jdbc:odbc:wangzhan","zijian","zijian");
Stmt=Conn.createStatement();
Rst=Stmt.executeQuery("select * from teach_favlist where fav_owner_name='"+user_name+"' and fav_que_id='"+que_id+"'");
if(Rst.next())right=false;
Rst.close();
Stmt.close();
Conn.close();}
catch(SQLException ex){
System.out.print(ex);}
return right;
}
//ÓÃÖ¸¶¨µÄ×Ö·ûÌæ»»×Ö·û´®ÖÐij¸ö×Ö·û
public String replace(String con,String tag,String rep){
int j=0;
int i=0;
int k=0;
String RETU="";
String temp=con;
int tagc=tag.length();
while(i<con.length()){
if(con.substring(i).startsWith(tag)){
temp=con.substring(j,i)+rep;
RETU+=temp;
i+=tagc;
j=i;
}
else{i+=1;
}
}
RETU+=con.substring(j);
return RETU;
}//½ûÓÃHTML´úÂë±àÂë
public String html(String s){
String re;
re=replace(s,"<","<");
re=replace(re,">",">");
re=replace(re,"\n","<br>");
re=replace(re," "," ");
re=replace(re,"'","'");
return re;
}//УÓѼ¡ªÑ§Ð£Ãû³ÆÊÇ·ñÒѾ­´æÔÚ
public boolean check_school_have(String school_name){
int i=0;
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(java.lang.ClassNotFoundException e){
System.out.print(e);
}
try{
Conn=DriverManager.getConnection("jdbc:odbc:wangzhan","zijian","zijian");
Stmt=Conn.createStatement();
Rst=Stmt.executeQuery("select * from alumnus_school where school_name='"+school_name+"'");
if(Rst.next())right=false;
Rst.close();
Stmt.close();
Conn.close();}
catch(SQLException ex){
System.out.print(ex);}
return right;
} //УÓѼ¡ª°à¼¶Ãû³ÆÊÇ·ñÒѾ­´æÔÚ
public boolean check_class_have(String class_name){
int i=0;
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(java.lang.ClassNotFoundException e){
System.out.print(e);
}
try{
Conn=DriverManager.getConnection("jdbc:odbc:wangzhan","zijian","zijian");
Stmt=Conn.createStatement();
Rst=Stmt.executeQuery("select * from alumnus_class where class_name='"+class_name+"'");
if(Rst.next())right=false;
Rst.close();
Stmt.close();
Conn.close();}
catch(SQLException ex){
System.out.print(ex);}
return right;
}
}