public List<TypeBean> TypeList() {
    List<TypeBean> list = new ArrayList<TypeBean>();
    Connection conn = null;

    CallableStatement stmt = null;
    ResultSet rs = null;
    try {
      conn = DbConnection.getConnection();
      stmt = conn.prepareCall("{call product_type()}");
      // String select = "select type_id,p_type FROM product_type";
      //			stmt.setString(1, "type_id");
      //			stmt.setString(2, "p_type");
      // .executeQuery("CREATE PROCEDURE shopping_expo.product_type(IN type_id INT , IN p_type
      // nvarchar(30)) BEGIN	select type_id,p_type FROM product_type;END;");
      System.out.println("Type Callable Executed");
      rs = stmt.executeQuery();
      while (rs.next()) {
        lb = new TypeBean();
        lb.setpType_Id(rs.getString("TYPE_ID"));
        lb.setpType(rs.getString("P_TYPE"));
        list.add(lb);
      }
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }

    return list;
  }
  public List<TypeBean> list() {
    List<TypeBean> list = new ArrayList<TypeBean>();
    Connection conn = null;

    CallableStatement stmt = null;
    ResultSet rs = null;
    try {
      conn = DbConnection.getConnection();
      stmt = conn.prepareCall("{CALL  getAllTypeProcedure()}");

      //	String select = "select * from product_type";

      rs = stmt.executeQuery();

      while (rs.next()) {
        lb = new TypeBean();
        lb.setpType_Id(rs.getString("TYPE_ID"));
        lb.setpType(rs.getString("P_TYPE"));
        list.add(lb);
      }
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      System.out.println("Exception :" + e.getMessage() + e.getErrorCode());
      e.printStackTrace();
    }

    return list;
  }