随笔分类 -  数据库

摘要：package com.zhao;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class TestJDBC {public static void main(String[] args) {String url = "jdbc:sqlserver://127.0.0.1:1433;databaseName=zhao";String 阅读全文

摘要：use studentmanagerselect * from carddrop table cardcreate table card (cid int identity primary key,cpassword varchar(20))insert into card values('idfjfdi234')insert into card values('dfiejf245j')insert into card values('diodkj0w3d')insert into card values('23redfdgfo' 阅读全文

摘要：/*例3-1　创建数据库表。*//*程序清单如下：*//*下面的例子将创建表S。*/CREATE TABLE S( sno char(10) NOT NULL /*学号字段*/ CONSTRAINT PK_sno PRIMARY KEY CLUSTERED/*主键约束*/ CHECK (sno like '31300501[0-9][0-9]')/*检查约束*/, sname char(8) NULL, /*姓名字段*/ sex char(2) NULL, /*性别字段*/ age int NULL, /*年龄字段*/ dept varchar(20) NULL/*系别字段*/ 阅读全文