USE [Account] GO /****** 对象: Table [dbo].[Account] 脚本日期: 10/18/2010 15:42:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Account]( [sNum] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [sName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [Smajor] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [Sgrade] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [Sbirth] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED ( [sNum] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]
不好意思,刚才没看仔细,应该是stuSearch方法的SQL有问题: sql = "select * from Account where snum = "+(sNum)+""; 有问题,忘记单引号了: sql = "select * from Account where snum = '"+(sNum)+"'";
GO
/****** 对象: Table [dbo].[Account] 脚本日期: 10/18/2010 15:42:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Account](
[sNum] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[sName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Smajor] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Sgrade] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Sbirth] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL,
CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED
(
[sNum] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
sql = "select * from Account where snum = "+(sNum)+"";
有问题,忘记单引号了:
sql = "select * from Account where snum = '"+(sNum)+"'";
executeUpdate执行的执行结果都是有返回值的:
失败的话会返回错误信息,成功则返回影响的行数;
一般可以用个ResultSet接收一下返回来判断执行结果,当然,如果没有必要的话不接收也行。