Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class Item
- {
- private int id;
- private String name;
- private int parentId;
- public Item( )
- {
- }
- public Item(int _id,String _name,int _parentId)
- {
- this.id=_id;
- this.name=_name;
- this.parentId=_parentId;
- }
- public int getId() {
- return id;
- }
- public void setId(int id) {
- this.id = id;
- }
- public String getName() {
- return name;
- }
- public void setName(String name) {
- this.name = name;
- }
- public int getParentId() {
- return parentId;
- }
- public void setParentId(int parentId) {
- this.parentId = parentId;
- }
- @Override
- public String toString() {
- return String
- .format("Item [id=%s, name=%s, parentId=%s]",
- id, name, parentId);
- }
- }
- public class ItemDAO
- {
- private Connection myCon;
- public ItemDAO() throws SQLException
- {
- myCon=DriverManager.getConnection("jdbc:mysql://localhost:3306/demo","root","");
- System.out.println("Succesfull connection to database");
- }
- public List<Item> getAllItems() throws SQLException
- {
- List<Item> list =new ArrayList<>();
- Statement stmt;
- ResultSet result;
- stmt= myCon.createStatement();
- result=stmt.executeQuery("SELECT * FROM items");
- while(result.next())
- {
- Item em=convertRowToItem(result);
- list.add(em);
- }
- return list;
- }
- public int rowCount() throws SQLException
- {
- Statement stmt;
- ResultSet rows;
- int count=0;
- stmt=myCon.createStatement();
- rows=stmt.executeQuery("SELECT COUNT(*) FROM items");
- while(rows.next())
- {
- count=rows.getInt(1);
- }
- return count;
- }
- public String getRoot() throws SQLException
- {
- Statement stmt;
- ResultSet row;
- String str=null;
- stmt=myCon.createStatement();
- row=stmt.executeQuery("SELECT * FROM items WHERE parent_id=0");
- while(row.next())
- {
- str=row.getString("name");
- }
- return str;
- }
- private Item convertRowToItem(ResultSet res) throws SQLException
- {
- int id=res.getInt("id");
- String name=res.getString("name");
- int parentId=res.getInt("parent_id");
- Item emp=new Item(id,name,parentId);
- return emp;
- }
- }
Add Comment
Please, Sign In to add comment