亚洲综合小说另类图片动图,亚洲AV无码国产精品色,亚洲毛片在线观看

JPBC ing：留言板之一：用JAVABEAN與DAO封裝數據的業務邏輯及操作

??????首先，先用DAO把數據業務邏輯部分分離開來，因為我只用到MySQL，所以就省略了工廠類，定了一個業務邏輯的接口及實現它的類。

?????MessageDAO.java??????

package?DAO.iface;

import?java.util.List;

/**

?*?進行數據操作的業務邏輯類接口的DAO

?*?@author?Administrator

?*/

public?interface?MessageDAO?{

????public?List?getMessageList();

}

???MessageDAOMySQL.java

package?DAO.impl;

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?bean.DatabaseBean;

import?bean.MessageBoardBean;

import?DAO.iface.MessageDAO;

/**

?*?進行數據操作的業務邏輯類

?*?@author?Administrator

?*/

public?class?MessageDAOMySQL?implements?MessageDAO?{

????private?DatabaseBean?db?=?null;

????private?Connection?conn?=?null;

????private?Statement?stmt?=?null;

????private?ResultSet?rs?=?null;

????private?List<MessageBoardBean>?messageList;

????public?MessageDAOMySQL()?{

????????db?=?new?DatabaseBean();

????}

????public?List?getMessageList()?{

????????????messageList?=?new?ArrayList<MessageBoardBean>();

????????????conn?=?db.getConn();

????????????stmt?=?db.getStatement(conn);

????????????rs?=?db.getResultSet(stmt,?"select?*?from?messageboard;");

????????????try?{

????????????????while?(rs.next())?{

????????????????????MessageBoardBean?tempMessage?=?new?MessageBoardBean();

????????????????????tempMessage.setUserName(rs.getString(2));

????????????????????tempMessage.setTitle(rs.getString(3));

????????????????????tempMessage.setWords(rs.getString(4));

????????????????????tempMessage.setTime(rs.getString(5));

????????????????????messageList.add(tempMessage);

????????????????}

????????????}?catch?(SQLException?e)?{

????????????????e.printStackTrace();

????????????}?finally?{

????????????????db.close(rs);

????????????????db.close(stmt);

????????????????db.close(conn);

????????????}

????????????return?messageList;

????}

}

??????為了對外擴展可能在此用到數據庫的操作，所以將數據庫的連接和簡單的增刪改查等操作封裝到一個Bean中。

???DatabaseBean.java
???

package?bean;

import?java.sql.Connection;

import?java.sql.DriverManager;

import?java.sql.ResultSet;

import?java.sql.SQLException;

import?java.sql.Statement;

public?class?DatabaseBean?{

????/**

?????*?數據庫的封裝，javaBean

?????*?@param?nonels

?????*/

????public??Connection?getConn()?{

????????Connection?conn?=?null;

????????try?{

????????????Class.forName("com.mysql.jdbc.Driver");

????????????conn?=?DriverManager.getConnection("jdbc:mysql://localhost/JPBC?user=root&password=root");

????????}?catch?(ClassNotFoundException?e)?{

????????????e.printStackTrace();

????????}?catch?(SQLException?e)?{

????????????e.printStackTrace();

????????}

????????return?conn;

????}

????

????public??Statement?getStatement(Connection?conn)?{

????????Statement?stmt?=?null;

????????try?{

????????????if(conn?!=?null)?{

????????????????stmt?=?conn.createStatement();

????????????}?

????????}?catch?(SQLException?e)?{

????????????e.printStackTrace();

????????}

????????return?stmt;

????}

????

????public??ResultSet?getResultSet(Statement?stmt,?String?sql)?{

????????ResultSet?rs?=?null;

????????try?{

????????????if(stmt?!=?null)?{

????????????????rs?=?stmt.executeQuery(sql);

????????????}

????????}?catch?(SQLException?e)?{

????????????e.printStackTrace();

????????}

????????return?rs;

????}

????

????public??void?close(Connection?conn)?{

????????try?{

????????????if(conn?!=?null)?{

????????????????conn.close();

????????????????conn?=?null;

????????????}

????????}?catch?(SQLException?e)?{

????????????e.printStackTrace();

????????}

????}

????

????public??void?close(Statement?stmt)?{

????????try?{

????????????if(stmt?!=?null)?{

????????????????stmt.close();

????????????????stmt?=?null;

????????????}

????????}?catch?(SQLException?e)?{

????????????e.printStackTrace();

????????}

????}

????

????public??void?close(ResultSet?rs)?{

????????try?{

????????????if(rs?!=?null)?{

????????????????rs.close();

????????????????rs?=?null;

????????????}

????????}?catch?(SQLException?e)?{

????????????e.printStackTrace();

????????}

????}

}

??????再將留言板的各個信息也封裝成一個Bean

??????MeassageBoardBean.java
??????

package?bean;

/**

?*??留言板信息的bean

?*?@author?nonles

?*/

public?class?MessageBoardBean?{

????private?String?userName;

????private?String?title;

????private?String?words;

????private?String?time;

????

????public?MessageBoardBean()?{

????????

????}

????

????public?String?getTime()?{

????????return?time;

????}

????public?void?setTime(String?time)?{

????????this.time?=?time;

????}

????public?String?getTitle()?{

????????return?title;

????}

????public?void?setTitle(String?title)?{

????????this.title?=?title;

????}

????public?String?getUserName()?{

????????return?userName;

????}

????public?void?setUserName(String?userName)?{

????????this.userName?=?userName;

????}

????public?String?getWords()?{

????????return?words;

????}

????public?void?setWords(String?words)?{

????????this.words?=?words;

????}

????

}

posted on 2008-10-16 23:45 nonels 閱讀(804) 評論(1) 編輯收藏所屬分類: J2EE


只有注冊用戶登錄后才能發表評論。




網站導航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關文章: JPBC ing：留言板之三：留言板JSP代碼 JPBC ing：留言板之二：處理jsp中出現的中文亂碼問題--字符過濾器 JPBC ing：留言板之一：用JAVABEAN與DAO封裝數據的業務邏輯及操作使用SAX解析XML文檔使用DOM解析XML文檔 Tomcat6.0 配置

# re: JPBC ing：留言板之一：用JAVABEAN與DAO封裝數據的業務邏輯及操作 2012-12-10 09:26 黑色紀念館

JPBC ing：留言板之一：用JAVABEAN與DAO封裝數據的業務邏輯及操作

評論

導航

統計

常用鏈接

留言簿(2)

隨筆分類(16)

隨筆檔案(16)

搜索

最新評論

閱讀排行榜

評論排行榜

JPBC ing： 留言板之一：用JAVABEAN與DAO封裝數據的業務邏輯及操作

評論

# re: JPBC ing： 留言板之一：用JAVABEAN與DAO封裝數據的業務邏輯及操作 2012-12-10 09:26 黑色紀念館

導航

統計

常用鏈接

留言簿(2)

隨筆分類(16)

隨筆檔案(16)

搜索

最新評論

閱讀排行榜

評論排行榜

JPBC ing：留言板之一：用JAVABEAN與DAO封裝數據的業務邏輯及操作

# re: JPBC ing：留言板之一：用JAVABEAN與DAO封裝數據的業務邏輯及操作 2012-12-10 09:26 黑色紀念館