2023/12/4
更新操作(insert、update、delete)

封装

sql脚本
USE [test_system]
GO
/****** Object:  Table [dbo].[tb_user]    Script Date: 2023/12/4 15:08:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tb_user](
	[id] [varchar](24) NOT NULL,
	[user_name] [varchar](24) NOT NULL,
	[password] [varchar](128) NOT NULL,
 CONSTRAINT [PK_tb_user] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO

查询操作(select)

标记
2023/12/5
\
2023/12/12