useradmin.java

页面抓取新闻并自动生成网页的代码 有兴趣的可以看看,很有意思的东西

package admin;
import java.sql.*;
public class UserAdmin{
	String turl="";
	Connection conn=null;
	Statement st=null;
	ResultSet rst=null;
	public void setUrl(String turl){
		this.turl=turl;
		}
	public void setLink(){
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn=DriverManager.getConnection(turl);
			st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			
		  }catch(Exception e){
		  	System.out.println(e.getMessage());
		  	}
		}
	public void setClose(){
		try{
			if(rst!=null)rst.close();
			if(st!=null)st.close();
			if(conn!=null)conn.close();
		  }catch(Exception closeExcption){
		  	System.out.println(closeExcption.getMessage());
		  	}	
		}
	public ResultSet query(String sql)throws Exception{  //SQL查询
		String tsql=sql;
		try{
		  rst=st.executeQuery(tsql);
		    }catch(Exception queryE){
		    	System.out.println(queryE.getMessage());
		    	}
      return rst;
		  }
	public String getStr(String s){  //编码处理
		String str=s;
		try{
		  byte b[]=str.getBytes("ISO-8859-1");
		  str=new String(b);
		  }catch(Exception e){return null;}
    return str;
    }	
  public int upNew(String sql) throws Exception{ //数据库更新
  	int numb=0;
    try{
      numb=st.executeUpdate(sql);
      }catch(SQLException ex){
         System.out.println("sql.executeUpdate:"+ex.getMessage());
         ex.printStackTrace();
         System.out.println("sql.toString:"+ex.toString());
         return numb;
         } 
    return  numb;
    }
  public String gb2iso(String qs){ 
    try{ 
      if (qs == null) return "NULL"; 
      else return new String(qs.getBytes("gb2312"),"iso-8859-1"); 
      }catch(Exception gE){ 
         System.out.println("gb2iso error："+gE.getMessage());
         } 
    return "NULL"; 
    }           			
	}