DWR.docx

1、DWRDWR整理： 导入：dwr.jar 包script type=text/javascript src=/dwr/util.jsscript type=text/javascript src=/dwr/interface/commDictDWR.js/ 下拉菜单选项Jsp:var status=; / 理赔状态var clmRsn =;function initPage() showSelect(250,status,status); showSelect(310,clmRsn,clmRsn); function showSelect(dictType,id,defaultValue) c

2、ommDictDWR.qryCommDictByType(dictType,function(date) DWRUtil.addOptions(id,:请选择); DWRUtil.addOptions(id,date,id,name); DWRUtil.setValue(id,defaultValue); );Java:public class CommDictDWR /* * 通过字典类型代码取得字段清单 * * param type * 字典类型代码 * return * throws Exception */ public ListMap qryCommDictByType(String

3、 type) throws Exception ListMap list = new ArrayListMap(); Map map = null; DBPool db = null; try String sql = select C_DICT_CDE,C_DICT_NME from TB_COMM_DICT where C_DICT_TYPE=? and C_STATE=1 order by C_DICT_CDE; db = new DBPool(DBConnection.getDBConnection(); db.prepareStatement(sql); db.setString(1

4、, type); ResultSet rs = db.executeQuery(); while (rs.next() map = new HashMap(); map.put(id, rs.getString(C_DICT_CDE); map.put(name, rs.getString(C_DICT_NME); list.add(map); rs.close(); rs = null; catch (Exception e) e.printStackTrace(); throw new Exception(根据字典类型代码查询字典清单出错); finally db.close(); ret

5、urn list; Dwr.xml配置： . Web.xml配置： dwr-invoker /dwr/* DBPool的封装类：import java.io.InputStream;import java.math.BigDecimal;import java.sql.Connection;import java.sql.Date;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.sql.Ti

6、mestamp;import javax.naming.InitialContext;import javax.naming.NamingException;import javax.sql.DataSource;import javax.sql.RowSet;import com.sun.rowset.CachedRowSetImpl;public class DBPool private static DataSource datasource2 = null; private java.sql.Connection conn = null; private ResultSet rs =

7、null; private Statement stmt = null; private PreparedStatement prepstmt = null; public DBPool() /* * 得到数据源连接 * * return * throws Exception * throws SQLException */ private static Connection setConnection() throws Exception Connection connection = null; try if (datasource2 = null) InitialContext init

8、ialcontext = new InitialContext(); / Get DS from JNDI datasource2 = (DataSource) initialcontext.lookup(java:/hacdxDS); connection = datasource2.getConnection(); catch (NamingException namingexception) namingexception.printStackTrace(); throw namingexception; catch (SQLException sqlexception) sqlexce

9、ption.printStackTrace(); throw sqlexception; catch (Exception e) e.printStackTrace(); throw e; return connection; public DBPool(Connection connection) throws SQLException try this.conn = connection; stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); / 只读的形式取数

10、据 catch (SQLException e) throw e; public DBPool(boolean isConnection) throws Exception try if (isConnection) this.conn = setConnection(); stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); / 只读的形式取数据 catch (SQLException e) throw e; public void setConnection(C

11、onnection connection) throws SQLException try this.conn = connection; stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); catch (SQLException e) throw e; /* * function prepareStatement * param sql * String * throws SQLException */ public void prepareStatement(

12、String sql) throws SQLException if (prepstmt != null) prepstmt.close(); prepstmt = null; if (null = conn) System.out.println(连接为空!); prepstmt = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); /* * function prepareStatement * param sbSql * StringBuffer * thr

13、ows SQLException */ public void prepareStatement(StringBuffer sbSql) throws SQLException if (prepstmt != null) prepstmt.close(); prepstmt = null; if (null = conn) System.out.println(连接为空!); prepstmt = conn.prepareStatement(sbSql.toString(), ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ON

14、LY); /* * function get a connection * * return Connection */ public Connection getConnection() throws SQLException return conn; /* * function prepareStatement * param sql * String * param resultSetType * int * param resultSetConcurrency * int * throws SQLException */ public void prepareStatement(Str

15、ing sql, int resultSetType, int resultSetConcurrency) throws SQLException prepstmt = conn.prepareStatement(sql, resultSetType, resultSetConcurrency); /* * function executeQuery * param sql * String * throws SQLException * return ResultSet */ public ResultSet executeQuery(String sql) throws SQLExcept

16、ion if (stmt != null) return stmt.executeQuery(sql); else return null; /* * function executeQuery * throws SQLException * return ResultSet */ public RowSet executeQuery() throws SQLException CachedRowSetImpl rowset = new CachedRowSetImpl(); ResultSet rs = null; if (prepstmt != null) rs = prepstmt.ex

17、ecuteQuery(); rowset.populate(new ResultSetWrapper(rs); rs.close(); prepstmt.close(); rs = null; prepstmt = null; else return null; return rowset; public void executeSql(String sql) throws SQLException if (stmt != null) stmt.execute(sql.trim(); else throw new SQLException(数据库连接失败); /* * function exe

18、cuteUpdate * param sql * String * throws SQLException */ public void executeUpdate(String sql) throws SQLException if (stmt != null) stmt.executeUpdate(sql); /* * function executeUpdate * throws SQLException */ public int executeUpdate() throws SQLException int i = -1; if (prepstmt != null) i = prep

19、stmt.executeUpdate(); prepstmt.close(); prepstmt = null; return i; public void execute() throws SQLException if (prepstmt != null) prepstmt.execute(); prepstmt.close(); prepstmt = null; /* * function executeUpdate * throws SQLException */ public void executeBatch() throws SQLException if (prepstmt !

20、= null) prepstmt.executeBatch(); /* * function addBatch * param value * String * throws SQLException */ public void addBatch(String value) throws SQLException prepstmt.addBatch(value); public void addBatch() throws SQLException prepstmt.addBatch(); public void clearBatch() throws SQLException prepst

21、mt.clearBatch(); public void prepstmtClose() throws SQLException prepstmt.close(); public void setString(int index, String value) throws SQLException prepstmt.setString(index, value); public void setObject(int index, Object value) throws SQLException prepstmt.setObject(index, value); public void set

22、Int(int index, int value) throws SQLException prepstmt.setInt(index, value); public void setBigDecimal(int index, BigDecimal value) throws SQLException prepstmt.setBigDecimal(index, value); public void setBoolean(int index, boolean value) throws SQLException prepstmt.setBoolean(index, value); /* * f

23、unction setDate * param index * int * param value * Date * throws SQLException */ public void setDate(int index, Date value) throws SQLException prepstmt.setDate(index, value); /* * function setLong * param index * int * param value * long * throws SQLException */ public void setLong(int index, long

24、 value) throws SQLException prepstmt.setLong(index, value); /* * function setFloat * param index * int * param value * float * throws SQLException */ public void setFloat(int index, float value) throws SQLException prepstmt.setFloat(index, value); /* * function setBytes * param index * int * param v

25、alue * byte * throws SQLException */ public void setBytes(int index, byte value) throws SQLException prepstmt.setBytes(index, value); /* * function setBinaryStream * param index * int * param value * InputStream * param len * int * throws SQLException */ public void setBinaryStream(int index, InputStream value, int len) throws S