本文主要是介绍非常好,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
public class DBManager {private DatabaseHelper DBhelper;private SQLiteDatabase db;private Context mContext;private SQLiteDatabase mSQLiteDatabase;public DBManager(Context context) {mContext = context;}//打开数据库public void openDataBase() throws SQLException {DBhelper=new DatabaseHelper(mContext);mSQLiteDatabase=DBhelper.getWritableDatabase(); //写数据库}//关闭数据库public void closeDataBase() {DBhelper.close();}//插入一行数据public long insertUserData(UserData userData){String userName=userData.getUserName();String userPwd=userData.getUserPwd();ContentValues values=new ContentValues();values.put("user_name", userName);values.put("user_pwd", userPwd);long long1=mSQLiteDatabase.insert(DatabaseHelper.TABLE_NAME, DatabaseHelper.ID, values);return long1;}//更新数据public boolean updateUserData(UserData userData){int id = userData.getUserId();String userName = userData.getUserName();String userPwd = userData.getUserPwd();ContentValues values = new ContentValues();values.put("user_name", userName);values.put("user_pwd", userPwd);return mSQLiteDatabase.update(DatabaseHelper.TABLE_NAME, values, DatabaseHelper.ID + "=" + id, null)> 0;}//查找数据 根据id查找public Cursor findUserData(int id) throws SQLException{Cursor mCursor =mSQLiteDatabase.query(false, DatabaseHelper.TABLE_NAME,null, DatabaseHelper.ID+ "=" + id, null, null, null, null, null);if(mCursor!=null){mCursor.moveToFirst();}return mCursor;}//查找所有数据public Cursor findAllUserDatas(){return mSQLiteDatabase.query(DatabaseHelper.TABLE_NAME, null, null, null, null, null,null);}//通过id删除指定数据public boolean deleteUserData(int id) {return mSQLiteDatabase.delete(DatabaseHelper.TABLE_NAME, DatabaseHelper.ID + "=" + id, null) > 0;}//删除所有数据public boolean deleteAllUserDatas(){return mSQLiteDatabase.delete(DatabaseHelper.TABLE_NAME, null, null) > 0;}//id行 通过知道列名字获取该列的信息public String getStringByColumnName(String columnName,int id) throws SQLException{Cursor mCursor =findUserData(id); //通过id获取一行信息int columnIndex = mCursor.getColumnIndex(columnName); //目标列 比如name列String columnValue =mCursor.getString(columnIndex); //返回这列的值mCursor.close();return columnValue;}//修改知道id行的数据信息public boolean updataUserDataById(String columnName,int id,String columnValue){ContentValues values = new ContentValues();values.put(columnName, columnValue);return mSQLiteDatabase.update(DatabaseHelper.TABLE_NAME, values, DatabaseHelper.ID + "=" + id, null) > 0;}//通过姓名获取有多少个相同分注册名public int findUserByName(String userName){int result= 0;Cursor mCursor=mSQLiteDatabase.query(DatabaseHelper.TABLE_NAME, null, DatabaseHelper.USER_NAME+"="+userName, null, null, null, null);if(mCursor!=null){ //如果不为空,就是有的注册名result=mCursor.getCount();mCursor.close();}return result;}public int findUserByNameAndPwd(String userName,String pwd){int result= 0;Cursor mCursor=mSQLiteDatabase.query(DatabaseHelper.TABLE_NAME, null, DatabaseHelper.USER_NAME+"="+userName+" and "+DatabaseHelper.USER_PWD+"="+pwd,null, null, null, null);if(mCursor!=null){result=mCursor.getCount();mCursor.close();}return result;}/订单记录//插入一行数据public int insertUserData2(OrderRecord data){String no1=data.getOrder();String no2=data.getTime();String no3=data.getJiafang();String no4=data.getYifang();String no5=data.getGoods();String no6=data.getNum();String no7=data.getCost();String no8=data.getMoney();String no9=data.getMymoney();ContentValues values=new ContentValues();values.put(DatabaseHelper.ORDER, no1);values.put(DatabaseHelper.TIME, no2);values.put(DatabaseHelper.JIAFANG, no3);values.put(DatabaseHelper.YIFANG, no4);values.put(DatabaseHelper.GOODS, no5);values.put(DatabaseHelper.NUMBER, no6);values.put(DatabaseHelper.COST, no7);values.put(DatabaseHelper.MONEY, no8);values.put(DatabaseHelper.MYMONEY, no9);int long1=(int) mSQLiteDatabase.insert(DatabaseHelper.TABLE_NAME2, DatabaseHelper.ID, values);return long1;}//查找数据public Cursor findAllUserDatas2() {return mSQLiteDatabase.query("orders", null, null, null, null, null,null);}//查找数据public List<OrderRecord> findAllUserDataList2() {List<OrderRecord> list=new ArrayList<OrderRecord>();OrderRecord orders=null;Cursor c= mSQLiteDatabase.query("orders", null, null, null, null, null,null);while(c.moveToNext()){orders=new OrderRecord();orders.setId(c.getInt(c.getColumnIndex(DatabaseHelper.ID)));orders.setJiafang(c.getString(c.getColumnIndex(DatabaseHelper.JIAFANG))); //甲方orders.setYifang(c.getString(c.getColumnIndex(DatabaseHelper.YIFANG))); //乙方orders.setOrder(c.getString(c.getColumnIndex(DatabaseHelper.ORDER))); //订单orders.setTime(c.getString(c.getColumnIndex(DatabaseHelper.TIME))); //时间orders.setGoods(c.getString(c.getColumnIndex(DatabaseHelper.GOODS))); //商品orders.setCost(c.getString(c.getColumnIndex(DatabaseHelper.COST))); //单价orders.setMoney(c.getString(c.getColumnIndex(DatabaseHelper.MONEY))); //金额orders.setMymoney(c.getString(c.getColumnIndex(DatabaseHelper.MYMONEY))); //佣金orders.setNum(c.getString(c.getColumnIndex(DatabaseHelper.NUMBER))); //数量list.add(orders);}return list; }//查找数据 根据id查找public Cursor findUserData2(long id) throws SQLException{Cursor mCursor =mSQLiteDatabase.query(false, DatabaseHelper.TABLE_NAME2,null, DatabaseHelper.ID+ "=" + id, null, null, null, null, null);if(mCursor!=null){mCursor.moveToFirst();}return mCursor;}//通过id删除指定数据public boolean deleteUserData2(int id) {return mSQLiteDatabase.delete(DatabaseHelper.TABLE_NAME2, DatabaseHelper.ID + "=" + id, null) > 0;}/费用记录//插入一行数据public int insertUserData3(CostRecord data){String no1=data.getTime();String no2=data.getMoney();String no3=data.getPurpose();String no4=data.getObject();ContentValues values=new ContentValues();values.put(DatabaseHelper.F_TIME, no1);values.put(DatabaseHelper.F_MONEY, no2);values.put(DatabaseHelper.F_PURPOSE, no3);values.put(DatabaseHelper.F_OBJECT, no4);int long1=(int) mSQLiteDatabase.insert(DatabaseHelper.TABLE_NAME3, DatabaseHelper.ID, values);return long1;}//查找数据public Cursor findAllUserDatas3() {return mSQLiteDatabase.query(DatabaseHelper.TABLE_NAME3, null, null, null, null, null,null);}//查找数据public List<CostRecord> findAllUserDataList3() {List<CostRecord> list=new ArrayList<CostRecord>();CostRecord costRecord=null;Cursor c= mSQLiteDatabase.query(DatabaseHelper.TABLE_NAME3, null, null, null, null, null,null);while(c.moveToNext()){costRecord=new CostRecord();costRecord.set_id(c.getInt(c.getColumnIndex(DatabaseHelper.ID)));costRecord.setTime(c.getString(c.getColumnIndex(DatabaseHelper.F_TIME))); //时间costRecord.setMoney(c.getString(c.getColumnIndex(DatabaseHelper.F_MONEY))); //金额costRecord.setPurpose(c.getString(c.getColumnIndex(DatabaseHelper.F_PURPOSE))); //用途costRecord.setObject(c.getString(c.getColumnIndex(DatabaseHelper.F_OBJECT))); //对象list.add(costRecord);}return list; }//通过id删除指定数据public boolean deleteUserData3(int id) {return mSQLiteDatabase.delete(DatabaseHelper.TABLE_NAME3, DatabaseHelper.ID + "=" + id, null) > 0;}/客户信息//插入一行数据public int insertUserData4(ClientRecord data){String no1=data.getName();String no2=data.getCall();String no3=data.getTel();String no4=data.getBank();String no5=data.getBank_account();String no6=data.getProduct();String no7=data.getAddress();ContentValues values=new ContentValues();values.put(DatabaseHelper.K_NAME, no1);values.put(DatabaseHelper.K_CALL, no2);values.put(DatabaseHelper.K_TEL, no3);values.put(DatabaseHelper.K_BANK, no4);values.put(DatabaseHelper.K_BANKACCOUNT, no5);values.put(DatabaseHelper.K_PRODUCT, no6);values.put(DatabaseHelper.K_ADDRESS, no7);int long1=(int) mSQLiteDatabase.insert(DatabaseHelper.TABLE_NAME4, DatabaseHelper.ID, values);return long1;}//查找数据public Cursor findAllUserDatas4() {return mSQLiteDatabase.query(DatabaseHelper.TABLE_NAME4, null, null, null, null, null,null);}public Cursor findUserData4(long id) throws SQLException{Cursor mCursor =mSQLiteDatabase.query(false, DatabaseHelper.TABLE_NAME4,null, DatabaseHelper.ID+ "=" + id, null, null, null, null, null);if(mCursor!=null){mCursor.moveToFirst();}return mCursor;}public List<ClientRecord> findAllUserDataList4() {List<ClientRecord> list=new ArrayList<ClientRecord>();ClientRecord clients=null;Cursor c= mSQLiteDatabase.query(DatabaseHelper.TABLE_NAME4, null, null, null, null, null,null);while(c.moveToNext()){clients=new ClientRecord();clients.set_id(c.getInt(c.getColumnIndex(DatabaseHelper.ID)));clients.setName(c.getString(c.getColumnIndex(DatabaseHelper.K_NAME)));clients.setCall(c.getString(c.getColumnIndex(DatabaseHelper.K_CALL)));clients.setTel(c.getString(c.getColumnIndex(DatabaseHelper.K_TEL)));clients.setBank(c.getString(c.getColumnIndex(DatabaseHelper.K_BANK)));clients.setBank_account(c.getString(c.getColumnIndex(DatabaseHelper.K_BANKACCOUNT)));clients.setProduct(c.getString(c.getColumnIndex(DatabaseHelper.K_PRODUCT)));clients.setAddress(c.getString(c.getColumnIndex(DatabaseHelper.K_ADDRESS)));list.add(clients); }return list; }//通过id删除指定数据public boolean deleteUserData4(int id) {return mSQLiteDatabase.delete(DatabaseHelper.TABLE_NAME4, DatabaseHelper.ID + "=" + id, null) > 0;}//修改知道id行的数据信息public boolean updataUserDataById4(int id,ClientRecord data){ContentValues values = new ContentValues();values.put(DatabaseHelper.K_NAME, data.getName());values.put(DatabaseHelper.K_CALL, data.getCall());values.put(DatabaseHelper.K_TEL, data.getTel());values.put(DatabaseHelper.K_BANK, data.getBank());values.put(DatabaseHelper.K_BANKACCOUNT, data.getBank_account());values.put(DatabaseHelper.K_PRODUCT, data.getProduct());values.put(DatabaseHelper.K_ADDRESS, data.getAddress());return mSQLiteDatabase.update(DatabaseHelper.TABLE_NAME4, values, DatabaseHelper.ID + "=" + id, null) > 0;// UPDATE table_anem SET column_name1 = value1, column_name2 = value2, ...WHERE ... ;}/货源信息//插入一行数据public int insertUserData5(SupplyRecord data){String no1=data.getName();String no2=data.getCall();String no3=data.getTel();String no4=data.getBank();String no5=data.getBank_account();String no6=data.getProduct();String no7=data.getAddress();ContentValues values=new ContentValues();values.put(DatabaseHelper.H_NAME, no1);values.put(DatabaseHelper.H_CALL, no2);values.put(DatabaseHelper.H_TEL, no3);values.put(DatabaseHelper.H_BANK, no4);values.put(DatabaseHelper.H_BANKACCOUNT, no5);values.put(DatabaseHelper.H_PRODUCT, no6);values.put(DatabaseHelper.H_ADDRESS, no7);int long1=(int) mSQLiteDatabase.insert(DatabaseHelper.TABLE_NAME5, DatabaseHelper.ID, values);return long1;}//查找数据public Cursor findAllUserDatas5() {return mSQLiteDatabase.query(DatabaseHelper.TABLE_NAME5, null, null, null, null, null,null);}//查找数据public List<SupplyRecord> findAllUserDataList5() {List<SupplyRecord> list=new ArrayList<SupplyRecord>();SupplyRecord supplys=null;Cursor c= mSQLiteDatabase.query(DatabaseHelper.TABLE_NAME5, null, null, null, null, null,null);while(c.moveToNext()){supplys=new SupplyRecord();supplys.set_id(c.getInt(c.getColumnIndex(DatabaseHelper.ID)));supplys.setName(c.getString(c.getColumnIndex(DatabaseHelper.H_NAME)));supplys.setCall(c.getString(c.getColumnIndex(DatabaseHelper.H_CALL)));supplys.setTel(c.getString(c.getColumnIndex(DatabaseHelper.H_TEL)));supplys.setBank(c.getString(c.getColumnIndex(DatabaseHelper.H_BANK)));supplys.setBank_account(c.getString(c.getColumnIndex(DatabaseHelper.H_BANKACCOUNT)));supplys.setProduct(c.getString(c.getColumnIndex(DatabaseHelper.H_PRODUCT)));supplys.setAddress(c.getString(c.getColumnIndex(DatabaseHelper.H_ADDRESS)));list.add(supplys);}return list;}//通过id删除指定数据public boolean deleteUserData5(int id) {return mSQLiteDatabase.delete(DatabaseHelper.TABLE_NAME5, DatabaseHelper.ID + "=" + id, null) > 0;}//修改知道id行的数据信息public boolean updataUserDataById5(int id,String name,String call,String tel,String bank,String count,String product,String address){ContentValues values = new ContentValues();values.put(DatabaseHelper.H_NAME, name);values.put(DatabaseHelper.H_CALL, call);values.put(DatabaseHelper.H_TEL, tel);values.put(DatabaseHelper.H_BANK, bank);values.put(DatabaseHelper.H_BANKACCOUNT, count);values.put(DatabaseHelper.H_PRODUCT, product);values.put(DatabaseHelper.H_ADDRESS, address);return mSQLiteDatabase.update(DatabaseHelper.TABLE_NAME5, values, DatabaseHelper.ID + "=" + id, null) > 0;// UPDATE table_anem SET column_name1 = value1, column_name2 = value2, ...WHERE ... ;}//修改知道id行的数据信息public boolean updataUserDataById5(int id,SupplyRecord data){ContentValues values = new ContentValues();values.put(DatabaseHelper.H_NAME, data.getName());values.put(DatabaseHelper.H_CALL, data.getCall());values.put(DatabaseHelper.H_TEL, data.getTel());values.put(DatabaseHelper.H_BANK, data.getBank());values.put(DatabaseHelper.H_BANKACCOUNT, data.getBank_account());values.put(DatabaseHelper.H_PRODUCT, data.getProduct());values.put(DatabaseHelper.H_ADDRESS, data.getAddress());return mSQLiteDatabase.update(DatabaseHelper.TABLE_NAME5, values, DatabaseHelper.ID + "=" + id, null) > 0;// UPDATE table_anem SET column_name1 = value1, column_name2 = value2, ...WHERE ... ;}}
这篇关于非常好的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!