/** 修改历史
* 日期 作者 修改内容
* -----------------------------------------------------------------------------
* 2009-11-30 李小强 创建CLASS
*/
package com.kinth.gdgs.yw.bpo;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.kinth.gdgs.common.AccessConn;
import com.kinth.gdgs.yw.bean.KnowBase;
/**
* <p>description:广州金税信息系统集成有限公司工作流平台, </p>
* <p>Title广州金税信息系统集成有限公司工作流平台</p>
* <p>Copyright: Copyright (c) 2009</p>
* <p>Company: 广州金税信息系统集成有限公司</p>
* @author 李小强 leaderbird
* <p>@version 1.0</p>
* <p>@date : 2009-11-30
*/
public class KnowBaseBPO {
public void saveKnowBase(Connection conn, KnowBase kb) {
boolean isOwner = false;
if (conn == null) {
conn = AccessConn.getConnect();
} else {
isOwner = true;
}
Statement st = null;
try {
StringBuffer sql = new StringBuffer("insert into KnowBase (username,password,userTruename,telephone,address) values(" );
sql.append("'"+kb.getUsername()+"','"+kb.getPassword()+"','"+kb.getUserTruename()+"','"+kb.getTelephone()+"','"+kb.getAddress()+"'");
sql.append(" )");
st = conn.createStatement();
st.execute(sql.toString());
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
st.close();
if (isOwner) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public List<KnowBase> getKnowBase(KnowBase knowBase){
Connection conn = AccessConn.getConnect();
Statement stmt;
List<KnowBase> kbList = new ArrayList();
try {
stmt = conn.createStatement();
String sql = "select * from KnowBase";
ResultSet rs = null;
rs = stmt.executeQuery(sql); // sql存放用来执行的sql语句，本示例中未对sql进行初始化。
while(rs.next()){
kbList.add(getKnowBaseBean(rs));
}
rs.close();
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return kbList;
}
private KnowBase getKnowBaseBean(ResultSet rs) throws SQLException{
KnowBase kb = new KnowBase();
kb.setUsername(rs.getString("username"));
kb.setPassword(rs.getString("password"));
kb.setUserTruename(rs.getString("userTruename"));
kb.setTelephone(rs.getString("telephone"));
kb.setAddress(rs.getString("address"));
return kb;
}
public static void main(String[] args){
KnowBaseBPO kmbpo = new KnowBaseBPO();
List<KnowBase> kbList=kmbpo.getKnowBase(null);
for(KnowBase kb:kbList){
System.out.println(kb.getUsername());
}
}
}
java+servlet+access.rar （28个子文件） 
java+servlet+access gdgs 
.project 1KB .mymetadata 285B db gdbs.mdb 1.02MB WebRoot WEB-INF web.xml 566B lib 
commons-logging.jar 31KB commons-digester.jar 107KB commons-fileupload.jar 22KB commons-beanutils.jar 116KB commons-lang.jar 62KB commons-validator.jar 46KB jakarta-oro.jar 64KB commons-collections.jar 161KB classes com kinth gdgs common AccessConn.class 1KB Utils.class 1KB yw bean KnowBase.class 2KB dao KnowBaseDao.class 302B bpo KnowBaseBPO.class 4KB servlet KnowBaseServlet.class 3KB META-INF MANIFEST.MF 39B register.jsp 1KB userList.jsp 2KB .myeclipse src com kinth gdgs common AccessConn.java 1KB Utils.java 1KB yw bean KnowBase.java 2KB dao KnowBaseDao.java 566B bpo KnowBaseBPO.java 3KB servlet KnowBaseServlet.java 2KB .classpath 969B资源评论
zhang67133452014-05-20这个不错，很简单很有用
alex1962013-06-15好用，好的很- raptor20052015-04-01下了，不错的，很好用
chengxuyuan2012-07-16嗯，这个描述还是比较符合的，拿过来改了一下就用来做了一个简单的东西，还挣了点钱钱
