bean.java

简单的增删改查,用servlet做的,数据库用sql2000de,适合初步学习人员

package bean;

import java.sql.SQLException;
import java.util.List;

import persistence.DataBaseConnection;

public class Bean {
    public void  executeUpdate(String sql){
    	DataBaseConnection dbc=new DataBaseConnection();
    	dbc.createConnection();
    	dbc.executeUpdate(sql);
    	dbc.commit();
    	dbc.closeDBConnection();
    }
    public List executeQuery(String sql){
    	List list=null;
    	DataBaseConnection dbc=new DataBaseConnection();
    	dbc.createConnection();
    	try {
			list=dbc.executeQueryForList(sql);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
    	dbc.commit();
    	dbc.closeDBConnection();
		return list;
    }	
    
}