xutils保存数据库

 
 

  
  app类；
 
 

 
 

  
  public class 
  
  App 
  
  extends 
  
  Application{
 
 
 
 

  
      
  
  private 
  
  DbManager.DaoConfig 
  
  daoConfig
  
  ;
 
 
 
 

  
      
  
  @Override
 
 

 
 

  
      
  
  public void 
  
  onCreate() {
 
 
 
 

  
          
  
  super
  
  .onCreate();
 
 
 
 

  
          x.Ext.
  
  init
  
  (
  
  this
  
  );
 
 
 
 

  
          x.Ext.
  
  setDebug
  
  (BuildConfig.
  
  DEBUG
  
  );
 
 

 
 

  
          
  
  //创建数据库
 
 

 
 

  
          
  
  daoConfig 
  
  = 
  
  new 
  
  DbManager.DaoConfig()
 
 
 
 

  
                  
  
  //数据库名字
 
 

 
 

  
                  
  
  .setDbName(
  
  "yw.db"
  
  )
 
 
 
 

  
                  
  
  //数据集的版本
 
 

 
 

  
                  
  
  .setDbVersion(
  
  1
  
  )
 
 

 
 

  
                  
  
  //是否开启事物
 
 

 
 

  
                  
  
  .setAllowTransaction(
  
  true
  
  )
 
 
 
 

  
                  
  
  //创建表的监听
 
 

 
 

  
                  
  
  .setTableCreateListener(
  
  new 
  
  DbManager.TableCreateListener() {
 
 
 
 

  
                      
  
  @Override
 
 

 
 

  
                      
  
  public void 
  
  onTableCreated(DbManager db, TableEntity<?> table) {
 
 
 
 

  
                          Toast.
  
  makeText
  
  (App.
  
  this
  
  , table.getName(), Toast.
  
  LENGTH_SHORT
  
  ).show();
 
 
 
 

  
                      }
 
 
                })

 
 

  
                  
  
  //数据库打开的监听
 
 

 
 

  
                  
  
  .setDbOpenListener(
  
  new 
  
  DbManager.DbOpenListener() {
 
 
 
 

  
                      
  
  @Override
 
 

 
 

  
                      
  
  public void 
  
  onDbOpened(DbManager db) {
 
 
 
 

  
                          
  
  //提高访问数据库的效率
 
 

 
 

  
                          
  
  db.getDatabase().enableWriteAheadLogging();
 
 
                    }
                });

 
 

  
      
  
  public 
  
  DbManager.DaoConfig getDaoConfig() {
 
 
    }


 
 
        return daoConfig;

 
 

  
      }
 
 
 
 

  
  }
 
 

data（封装类）

//表名字

  
  

   
   @Table
   
   (name =
   
   "yws"
   
   )
  
  

  
  

   
   public class 
   
   DataBean {
  
  

  
  

   
           
   
   @Column
   
   (name = 
   
   "id"
   
   ,isId = 
   
   true
   
   )
  
  
  
  

   
           
   
   private 
   
   String 
   
   news_id
   
   ;
  
  
  
  

   
           
   
   @Column
   
   (name = 
   
   "news_title"
   
   )
  
  
  
  

   
           
   
   private 
   
   String 
   
   news_title
   
   ;
  
  
  
  

   
           
   
   private 
   
   String 
   
   news_summary
   
   ;
  
  
  
  

   
           
   
   @Column
   
   (name = 
   
   "pic_url"
   
   )
  
  
  
  

   
           
   
   private 
   
   String 
   
   pic_url
   
   ;
  
  

  
  

   
           
   
   public 
   
   String getNews_id() {
  
  
  
  

   
               
   
   return 
   
   news_id
   
   ;
  
  
  
  

   
           }
  
  

  
  

   
           
   
   public void 
   
   setNews_id(String news_id) {
  
  
  
  

   
               
   
   this
   
   .
   
   news_id 
   
   = news_id;
  
  
        }


  
  

   
           
   
   public 
   
   String getNews_title() {
  
  
  
  

   
               
   
   return 
   
   news_title
   
   ;
  
  
  
  

   
           }
  
  

  
  

   
           
   
   public void 
   
   setNews_title(String news_title) {
  
  
  
  

   
               
   
   this
   
   .
   
   news_title 
   
   = news_title;
  
  
        }


  
  

   
           
   
   public 
   
   String getNews_summary() {
  
  
  
  

   
               
   
   return 
   
   news_summary
   
   ;
  
  
  
  

   
           }
  
  

  
  

   
           
   
   public void 
   
   setNews_summary(String news_summary) {
  
  
  
  

   
               
   
   this
   
   .
   
   news_summary 
   
   = news_summary;
  
  
        }


  
  

   
           
   
   public 
   
   String getPic_url() {
  
  
  
  

   
               
   
   return 
   
   pic_url
   
   ;
  
  
  
  

   
           }
  
  

  
  

   
           
   
   public void 
   
   setPic_url(String pic_url) {
  
  
  
  

   
               
   
   this
   
   .
   
   pic_url 
   
   = pic_url;
  
  
        }


  
  

   
   }
  
  
 
 

  
  

 
 

mainactivity类

  
  

   
   //获取到数据库
  
  
App app = (App) getApplication();
DbManager db = x.getDb(app.getDaoConfig());
//判断数据库里面的内容
    
    

     
     try 
     
     {
    
    
    
    

     
         List<DataBean> list =  
     
     db
     
     .findAll(DataBean.
     
     class
     
     );
    
    
    
    

     
         
     
     if 
     
     (list!=
     
     null
     
     &&list.size()>
     
     0
     
     ){
    
    
    
    

     
             
     
     mlist
     
     .addAll(list);
    
    
    
    

     
             
     
     myadapter
     
     .notifyDataSetChanged();
    
    
    
    

     
             Toast.
     
     makeText
     
     (MainActivity.
     
     this
     
     ,
     
     "数据库"
     
     ,Toast.
     
     LENGTH_LONG
     
     ).show();
    
    
    
    

     
         }
     
     else 
     
     {
    
    
    
    

     
             Toast.
     
     makeText
     
     (MainActivity.
     
     this
     
     ,
     
     "网络"
     
     ,Toast.
     
     LENGTH_LONG
     
     ).show();
    
    
    
    

     
             loadData();
    
    
    }

    
    

     
     } 
     
     catch 
     
     (DbException e) {
    
    
    
    

     
         e.printStackTrace();
    
    
    
    

     
     }
    
    
   
   

    
    加入数据库
   
   
    
    

     
     try 
     
     {
    
    
    
    

     
         
     
     db
     
     .save(
     
     mlist
     
     );
    
    
    
    

     
     } 
     
     catch 
     
     (DbException e) {
    
    
    
    

     
         e.printStackTrace();
    
    
    
    

     
     }