dongtaiinfomanager.java

着重用css实现页面显示功能,实现简单数据库连接,是很好的入门教程

/*
 * Created on 2006-7-3
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package cn.com.aheadsoft.infomanager;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import java.util.List;

import cn.com.aheadsoft.conndb.Configuration;
import cn.com.aheadsoft.conndb.DBConnection;



/**
 * @author
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class DongtaiInfoManager {
    
	private int PerSize =0;
		
    
	public DongtaiInfoManager(){
	    setPerSize();
	}

	public void setPerSize() {
	   String PerNum=Configuration.getInstance().getValue("cn.com.aheadsoft.page.perRow");
	   PerSize =Integer.parseInt(PerNum);
	}
	public int executeUpdate(String sql){
		DBConnection dbcn=new DBConnection();
		int num=0;
		Connection connection=null;
   	    Statement stm=null;
   	    try{
   	 	    connection =dbcn.getConnection();
   	 	    stm=connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                    ResultSet.CONCUR_READ_ONLY);
   	 	    num=stm.executeUpdate(sql);
   	 	    stm.close();
   	 	    connection.close();
   	 	    	 	
   	    }catch(Exception ex){
   	 	    System.out.println(ex);
   	 	    return 0;
   	    }finally{
    		try{
       		 dbcn.CloseCon();
       		}catch(Exception ex){
       			System.out.println(ex);
       		}
       	}    	
   	    return num;
	}
}