SHOW:
|
|
- or go back to the newest paste.
| 1 | public void insertCategory(List<CategoryDTO> listCategory) {
| |
| 2 | JDBCUtil util = new JDBCUtil(); | |
| 3 | String conString = util.createConnectionString("XMLData", "sa", "123456");
| |
| 4 | ||
| 5 | int i = 1; | |
| 6 | String query = "Insert into Category values(?,?)"; | |
| 7 | for (CategoryDTO cate : listCategory) {
| |
| 8 | Object[] params = new Object[2]; | |
| 9 | params[0] = cate.getId(); | |
| 10 | params[1] = cate.getName(); | |
| 11 | ||
| 12 | boolean success = util.insert(conString, query, params); | |
| 13 | ||
| 14 | if (!success) {
| |
| 15 | System.out.println(query); | |
| 16 | System.out.println("Error categories.");
| |
| 17 | break; | |
| 18 | } | |
| 19 | i++; | |
| 20 | } | |
| 21 | } | |
| 22 | ||
| 23 | ||
| 24 | ||
| 25 | public List<CategoryDTO> getAllCategory(){
| |
| 26 | List<CategoryDTO> listCate = new ArrayList<CategoryDTO>(); | |
| 27 | JDBCUtil util = new JDBCUtil(); | |
| 28 | String conString = util.createConnectionString("XMLData", "sa", "123456");
| |
| 29 | ||
| 30 | String query = "Select * from Category"; | |
| 31 | try {
| |
| 32 | List<Object[]> data = util.getAll(conString, query); | |
| 33 | for (Object[] obj : data) {
| |
| 34 | CategoryDTO cate = new CategoryDTO(); | |
| 35 | cate.setId(Integer.parseInt(obj[0].toString())); | |
| 36 | cate.setName(obj[1].toString()); | |
| 37 | listCate.add(cate); | |
| 38 | } | |
| 39 | return listCate; | |
| 40 | } catch (SQLException ex) {
| |
| 41 | ex.printStackTrace(); | |
| 42 | } | |
| 43 | return null; | |
| 44 | ||
| 45 | } |
