# jdbctest

**Repository Path**: DerekAndroid/jdbctest

## Basic Information

- **Project Name**: jdbctest
- **Description**: jdbc练习
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2019-11-23
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

###创建分类表
CREATE TABLE category(
cid INT PRIMARY KEY AUTO_INCREMENT  ,
  cname VARCHAR(100)
);
 
INSERT INTO category (cid,cname) VALUES('1','agen');
INSERT INTO category (cid,cname) VALUES('2','nice');
INSERT INTO category (cid,cname) VALUES('3','good');
 
###创建用户表
CREATE TABLE users(
uid INT PRIMARY KEY AUTO_INCREMENT  ,
  username VARCHAR(100),
  PASSWORD VARCHAR(100)
);
INSERT INTO users (username,PASSWORD) VALUES('agen','123');