//============일반적인 경우=============
OpenBoard openBoard = null;
ResultSet rs =null;
ArrayList arraylist = new ArrayList();
rs = stmt.executeQuery("select num ,titlt,contnet,inp_name,inp_date from open_board ");
while (rs.next()) {
openBoard = new openBoard();
openBoard.setNum(rs.getInt("num"));
openBoard.setTitle(rs.getString("title"));
openBoard.setContent(rs.getString("content"));
openBoard.setInpName(rs.getString("inp_name"));
openBoard.setInpDate(rs.getString("inp_date"));
arraylist.add(openBoard);
}
//=========Commons의 Dbutils===========
ResultSetHandler resultSetHandler= new BeanListHandler(OpenBoard.class);
QueryRunner queryRunner = new QueryRunner();
List list = (List)queryRunner.query(conn, "select num ,titlt,contnet,inp_name,inp_date from open_board ", resultSetHandler);
///-----조건이 있는경우------------
ArrayList param = new ArrayList();
param.add(req.getParameter("num"));
ResultSetHandler resultSetHandler= new BeanListHandler(OpenBoard.class);
QueryRunner queryRunner = new QueryRunner();
List list = (List)queryRunner.query(conn, "select num ,titlt,contnet,inp_name,inp_date from open_board where num=? ",param.toArray(), resultSetHandler);
|
