平常在做AndroID数据库 *** 作时,都是用的execsql之个方法. 今天偶然发现了sqliteStatement这个类.让我想起了在做Java Web开发写JDBC的代码时Prestatement这个类.Prestatement不仅提高了效率,也解决了sql注入的问题.那在AndroID中的sqliteStatement,是否也会提高一些效率呢?
于是写了一个简单的测试,比较execsql和sqliteStatement的executeInsert方法插入1000条数据所需要的时间.都没有使用事物.
新建一个数据库和users表:
| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | public class DBHelper extends sqliteOpenHelper { private static final String DB_name = "userdb" ; final int DB_VERSION = 1 ; public DBHelper(Context context) { super (context,DB_name, null ,DB_VERSION); } @OverrIDe voID onCreate(sqliteDatabase db) { StringBuffer sql = new StringBuffer(); sql.append( "create table users" ); "(_ID int PRIMARY KEY,name varchar,gender int,age int,phoneNumber varchar,address varchar)" ); db.execsql(sql.toString()); } @OverrIDe onUpgrade(sqliteDatabase db,153)!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; wIDth:auto!important; Font-weight:bold!important; Font-size:1em!important; min-height:inherit!important">int oldVersion,monospace!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; wIDth:auto!important; Font-size:1em!important; min-height:inherit!important"> newVersion) { } } |
?
UserDao { private DBHelper dbHelper; sqliteDatabase db; StringBuffer sql_insert; List<User> users; UserDao(Context context){ this .dbHelper = DBHelper(context); .db = dbHelper.getWritableDatabase(); sql_insert = StringBuffer(); sql_insert.append( "INSERT INTO users(name,gender,age,phoneNumber,address) " " VALUES( ?,?,?)" ); users = ArrayList<User>(); //测试数据 for ( i = 0 ;i< 1000 ;i++){ User user = User(); user.setID(i); user.setname( "name" +i); user.setGender( ); user.setAge(user.getRandomAge()); user.setPhoneNumber( "13800138000" ); user.setAddress( "GuangDong ShenZhen No." +i); users.add(user); } } /** * 使用sqliteDatabase 的execsql方法插入数据 * @return 返回执行所需要的时间 */ long insertexecsql() { long start=System.currentTimeMillis(); (User user:users){ Object[] bindArgs = {user.getname(),user.getGender(),user.getAge(),user.getPhoneNumber(),user.getAddress()}; db.execsql(sql_insert.toString(),bindArgs); } end = System.currentTimeMillis(); return end - start; } /** * 使用sqliteStatement的executeInsert方法插入数据 * @return 返回执行所需要的时间 */ insertStatement() { start = System.currentTimeMillis(); (User user:users){ sqliteStatement statement= db.compileStatement(sql_insert.toString()); statement.bindString( statement.bindLong( 2 3 4 5 statement.executeInsert(); } end = System.currentTimeMillis(); end - start; } } |
界面方面就两个按钮,分别调用不同的插入方法,并将执行所需的时间显示在button上.
? MainActivity Activity { button btn1; button btn2; @OverrIDe protected onCreate(Bundle savedInstanceState) { .onCreate(savedInstanceState); setContentVIEw(R.layout.activity_main); final UserDao dao = UserDao( ); btn1 = (button) findVIEwByID(R.ID.btn1); btn2 = (button) findVIEwByID(R.ID.btn2); btn1.setonClickListener( OnClickListener() { @OverrIDe onClick(VIEw v) { btn1.setText(String.valueOf(dao.insertexecsql())); } }); btn2.setonClickListener( OnClickListener() { @OverrIDe onClick(VIEw v) { btn2.setText(String.valueOf(dao.insertStatement())); } }); } |
微信扫一扫
支付宝扫一扫
评论列表（0条）