MySQL 数据库查不出数据
笑魂小生 2009-12-10 11:14:02 数据库
create table cod_doctor
(
docID int not null,
docTitle varchar(50),
docCateID int,
docCreationTime datetime,
docSmallPicture varchar(100),
docBigPicture varchar(100),
docAuditionURL varchar(200),
docDownloadURL varchar(200),
docContentText varchar(200),
docJudge enum('y','n'),
docDescription varchar(200),
ordering int,
primary key (docID)
);
我使用的是hibernate
核心代码
try {
String s="棘刺刻猴11";
//String strSQL="FROM DocDoctor where docTitle like '"+s+"'";
//String strSQL="FROM DocDoctor as d WHERE d.docTitle like '"+s+"%'";
String sql="SELECT d.docID FROM doc_doctor d WHERE d.docTitle like '棘刺刻猴11' ; ";
// query.setString("name", s+"%");
List list = getSession().createSQLQuery(sql).list();
//List list=query.list();
System.out.println("dddddddddddddddddddd"+list.size());
//List list=getSession().createQuery(s).list();
log.debug("attach successful");
return list;
} catch (RuntimeException re) {
log.error("attach failed", re);
throw re;
}
上面注释掉的都试了,还是查不出来