DB数据库操作

//打开数据库链接

sqlConnection=sqlite("\db.db") //没有就创建
if(not sqlConnection.existsTable("file")){        
            sqlConnection.exec("CREATE TABLE file( 
                     id INTEGER PRIMARY KEY AUTOINCREMENT,  
                     name,
                     age,
                     kg,
                     love
                    );"
            )
            win.msgbox("创建表成功","AAuto")
           
 //创建索引利于查询
            sqlConnection.exec("create index 索引名字 on 表名字(索引字段名字)")
            
  //添加数据
add_db =function(name,age,kg,love){

                var add=sqlConnection.exec("insert into file (name,age,kg,love) values('"+name+"','"+age+"','"+kg+"','"+love+"')")
                
                win.msgbox("添加成功","系统提示")
                Refresh_main();        
                
}

//删除所选数据
delete_db = function(){
        
for(i=1;winform.listview.count;1){        

                if(winform.listview.getChecked(i)){
                
                        var id=winform.listview.getItemText(i,1)
                        sqlConnection.exec("DELETE FROM file WHERE id="+id+"")
                }
}
 win.msgbox("删除成功","系统提示")
 Refresh_main()        
}

//查询表中相同的并删除
delete_thesame = function(name){

        sqlConnection.exec("DELETE FROM file where name not in(select max(id) from file group by name)")
        
}

//查询表中相同姓名
select_db = function(name){

        return sqlConnection.getTable("select name from file where name='"+name+"'"); 
        
}

//查询表中有相同数据的便覆盖掉
the_same = function(name,age,kg,love){
        
        var num = sqlConnection.exec("insert into file(name,age,kg,love) select '"+name+"','"+age+"','"+kg+"','"+love+"' where not exists(select * from file where name='"+name+"');")
        win.msgbox("添加成功","系统提示")
        Refresh_main()
        
}

//修改表中数据
update_db = function(id,name,age,kg,love){
        var doubt=win.msgboxTest("确定修改并且更新到数据库？","系统提示"); //返回布尔值
        if(doubt){
         
         sqlConnection.exec("UPDATE file SET name='"+name+"',age='"+age+"',kg='"+kg+"',love='"+love+"' WHERE id ='"+id+"'");
         
        }
        
}

// 模糊查询
inQuiry = function(db,re){
    var tab = db.getTable("select rowid,* from [tl] where ifnull(name,'') || ifnull(tel,'') || ifnull(QQ,'') like '%"+ re+ "%'")
    return  tab
}