改动如下:
String sql = "Select Contents.*,ContentClass.Program_ID from Contents2Mood,Contents,ContentClass Where ContentClass.Program_ID = "+ProgramID+" and Contents2Mood.Contents_ID = Contents.Contents_ID and Contents.Content_Class_ID = ContentClass.Content_Class_ID and Contents.Contents_Title like '%"+ContentTitle+"%' order by Contents.Create_Date desc";
String sql = "Select Contents.*,ContentClass.Program_ID from Contents2Mood,Contents,ContentClass Where ContentClass.Program_ID = "+ProgramID+" and Contents2Mood.Contents_ID = Contents.Contents_ID and Contents.Content_Class_ID = ContentClass.Content_Class_ID and Contents.Contents_Title like '%"+ContentTitle+"%' order by Contents.Create_Date desc";
程序中通配符应该用 '%'-代表多个任意字符。
或者 '?'-代表一个任意字符。在ACCESS内部做查询呢,你得用 * .