测试数据库连接.pptx

测试数据库连接北京电子科技职业学院 测试数据库连接编写ColumnDao类的getAll()方法编写测试类 角色管理模块中包含新增find方法 public T ListT find(String sql, ListObject params, ClassT clazz) { ListT list = new ArrayListT(); try { Connection conn = getConnection(); PreparedStatement stmt = conn.prepareStatement(sql); ParameterMetaData pmd = stmt.getParameterMetaData(); for (int i = 0; i pmd.getParameterCount(); i++) { stmt.setObject(i+1, params.get(i)); } ResultSet rs = stmt.executeQuery(); ResultSetMetaData rsmd = rs.getMetaData(); while (rs.next()) { T obj = clazz.newInstance(); //实例化对象 for (int i = 0; i rsmd.getColumnCount(); i++) { String colName = rsmd.getColumnName(i+1); Object value = rs.getObject(colName); BeanUtilsEx.setProperties(obj, colName, value); } list.add(obj); } } catch (Exception e) { e.printStackTrace(); } finally { closeAll(conn, stmt, rs); } return list; } 谢 谢 观 看北京电子科技职业学院