这是我的C3p0配置:
C3p0Plugin cp = new C3p0Plugin("jdbc:sqlserver://localhost:1433;datebaseName=Test","sa","12345","com.microsoft.sqlserver.jdbc.SQLServerDriver");
me.add(cp);
ActiveRecordPlugin arp = new ActiveRecordPlugin(cp);
me.add(arp);
arp.addMapping("Test", Test.class);
这是唯一一条sql语句:
List list = Test.dao.find("select * from Test");
到底那边错了呢,程序中没有[ ` ]这个符号呀。大家有知道该怎么做吗?
我的完整程序是这样的,比较简单,就是测试连接的:
package jfinal;
import com.jfinal.config.Constants;
import com.jfinal.config.Handlers;
import com.jfinal.config.Interceptors;
import com.jfinal.config.JFinalConfig;
import com.jfinal.config.Plugins;
import com.jfinal.config.Routes;
import com.jfinal.plugin.activerecord.ActiveRecordPlugin;
import com.jfinal.plugin.c3p0.C3p0Plugin;
public class jfinalConfig extends JFinalConfig {
@Override
public void configConstant(Constants me) {
me.setDevMode(true);
}
@Override
public void configRoute(Routes me) {
me.add("/Test", indexController.class);
}
@Override
public void configPlugin(Plugins me) {
C3p0Plugin cp = new C3p0Plugin("jdbc:sqlserver://localhost:1433;datebaseName=Test","sa","12345","com.microsoft.sqlserver.jdbc.SQLServerDriver");
me.add(cp);
ActiveRecordPlugin arp = new ActiveRecordPlugin(cp);
me.add(arp);
arp.addMapping("Test", Test.class);
}
@Override
public void configInterceptor(Interceptors me) {
}
@Override
public void configHandler(Handlers me) {
}
}
package jfinal;
import java.util.List;
import com.jfinal.core.Controller;
public class indexController extends Controller {
public void index(){
List list = Test.dao.find("select * from Test");
renderJson(list);
}
}
package jfinal;
import com.jfinal.plugin.activerecord.Model;
public final class Test extends Model {
public static final Test dao = new Test();
}
实在是不懂为什么会错。
这是错误log
严重: Plugin start error: com.jfinal.plugin.activerecord.ActiveRecordPlugin.
com.microsoft.sqlserver.jdbc.SQLServerException: '' 附近有语法错误。
' 附近有语法错误
com.jfinal.plugin.activerecord.ActiveRecordException: com.microsoft.sqlserver.jdbc.SQLServerException: '