toSql主要实现字符格式的转换,刚才根据你的意见,去掉了这个方法,仍然不行。另外我的sql脚本是:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[users]
GO
CREATE TABLE [dbo].[users] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[UserName] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[PassWord] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
public class login {
private String username="";
private String passwd="";
private boolean isadmin=false; //是否管理员登录
private int userid=0;
public String sqlStr="";
public login() {
username="";
passwd="";
isadmin=false;
userid=0;
}
public void setUsername(String name){
this.username=name;
}
public String getUsername(){
return this.username;
}
public void setPasswd(String psw){
this.passwd=psw;
}
public String getPasswd(){
return this.passwd;
}
public void setIsadmin(boolean Isadmin){
this.isadmin=Isadmin;
}
public boolean getIsadmin(){
return this.isadmin;
}
public void setUserid(int nid){
this.userid=nid;
}
public int getUserid(){
return this.userid;
}
/**
*获得查询用户信息的SQL语句
*/
public String getSql(){
if(isadmin){
sqlStr="select * from admin where adminuser=? and adminpass=?";
}else{
sqlStr="select * from users where username=?and password=?";
}