是SQL Server吗?ResultSet rs = DBconn.u_select("select count(*) as bb from hwt_o_ckwork WHERE left(w_id,6) = '101078'");其他 ResultSet rs = DBconn.u_select("select count(*) as bb from hwt_o_ckwork WHERE w_id like '101078%'");看看有结果没?
那?会不会是列类型不同,字符型与数值型的差别啊??ResultSet rs = DBconn.u_select("select count(*) as bb from hwt_o_ckwork WHERE w_id = '101078'"); 改为 ResultSet rs = DBconn.u_select("select count(*) as bb from hwt_o_ckwork WHERE w_id = 101078"); 试试
不能运行,因为w_id是char类型。
发表结构来研究研究?你的char几位宽的啊??
CREATE TABLE [dbo].[hri_perbas] ( [w_id] [char] (7) COLLATE Chinese_PRC_CI_AS NOT NULL , [per_na] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [sex] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL , [proce] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [a_user] [t_guser] NOT NULL , [a_dt] [datetime] NULL )
ResultSet rs = DBconn.u_select("select count(*) as bb from hwt_o_ckwork WHERE w_id like '101078%'");看看有结果没?
改为
ResultSet rs = DBconn.u_select("select count(*) as bb from hwt_o_ckwork WHERE w_id = 101078");
试试
[w_id] [char] (7) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[per_na] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sex] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[proce] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[a_user] [t_guser] NOT NULL ,
[a_dt] [datetime] NULL
)