请问，模糊删除里，怎么将%和参数拼起来啊

leihenyx

请问，模糊删除里，怎么将%和参数拼起来啊，我这么写，没有用。。。。。

1. 
   
2.         var sqlConn = sqlite("/test.db");
   
3. 
   
4.         var command = sqlConn.prepare("delete from fileinfo where name like '%' +@keyw + '%';");
   
5.         command.bind.parameterByNamesAt(
   
6.             keyw = "I'm Jack.doc";
   
7.         ).step();
   
8. 
   
9.         command.finalize() ;
   
10.         sqlConn.close();
    

复制代码

1. 
   
2. import win.ui;
   
3. import sqlite;
   
4. /*DSG{{*/
   
5. mainForm = ..win.form(text="aardio Form";right=599;bottom=399)
   
6. mainForm.add(
   
7. button={cls="button";text="Insert";left=68;top=44;right=210;bottom=80;z=2};
   
8. button2={cls="button";text="select";left=234;top=44;right=375;bottom=80;z=3};
   
9. button3={cls="button";text="delete";left=67;top=97;right=208;bottom=137;z=4};
   
10. edit={cls="edit";left=14;top=172;right=585;bottom=383;db=1;dl=1;dr=1;dt=1;edge=1;multiline=1;z=1}
    
11. )
    
12. /*}}*/
    
13. 
    
14. var sqlConn = sqlite("/test.db");
    
15. 
    
16.     if(!sqlConn.existsTable("fileinfo"))
    
17.     {       
    
18.         sqlConn.exec( "create table fileinfo(id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT , path TEXT);");//创建表           
    
19.     } else {
    
20.         sqlConn.exec("delete from fileinfo;DELETE FROM sqlite_sequence;");               
    
21.     }
    
22.     sqlConn.close();
    
23. 
    
24. 
    
25. mainForm.button.oncommand = function(id,event){
    
26.         //mainForm.msgbox( mainForm.button.text );
    
27.         var sqlConn = sqlite("/test.db");
    
28.         var command = sqlConn.prepare("insert into fileinfo values (null ,@name,@path);" );
    
29.        
    
30.         //绑定命名参数
    
31.         command.bind.parameterByNamesAt(
    
32.             name = "I'm Jack.doc";
    
33.             path = "E:\Computer\Desktop\Publish";
    
34.         ).step();
    
35. 
    
36.         //释放命令对象
    
37.         command.finalize() ;
    
38.         command = sqlConn.prepare("insert into fileinfo values (null ,@name,@path);" );
    
39.        
    
40.         //绑定命名参数
    
41.         command.bind.parameterByNamesAt(
    
42.             name = "I am Tom.doc";
    
43.             path = "E:\Computer\Desktop\Publish";
    
44.         ).step();
    
45. 
    
46.         //释放命令对象
    
47.         command.finalize() ;
    
48.        
    
49.         sqlConn.close();
    
50. }
    
51. 
    
52. 
    
53. mainForm.button3.oncommand = function(id,event){
    
54.         var sqlConn = sqlite("/test.db");
    
55. 
    
56.         var command = sqlConn.prepare("delete from fileinfo where name like '%' +@keyw + '%';");
    
57.         command.bind.parameterByNamesAt(
    
58.             keyw = "I'm Jack.doc";
    
59.         ).step();
    
60. 
    
61.         command.finalize() ;
    
62.         sqlConn.close();
    
63. }
    
64. 
    
65. mainForm.button2.oncommand = function(id,event){
    
66.         //mainForm.msgbox( mainForm.button2.text );
    
67.         var sqlConn = sqlite("/test.db");
    
68.         for id,name,path in sqlConn.each("SELECT * from fileinfo") {
    
69.                  mainForm.edit.print(id, path ,name);
    
70.         }
    
71.         sqlConn.close();
    
72. }
    
73. 
    
74. mainForm.show()
    
75. return win.loopMessage();
    

复制代码

roger

参数化就是为了不用拼接，拼接还用参数干什么，

leihenyx

roger 发表于 2014-11-18 19:24
参数化就是为了不用拼接，拼接还用参数干什么，

原来是把%写在参数里，好神奇的sqlite............