一,创建数据库
#建库
CREATE DATABASE sys;
#判读若有student的表则删除表
drop table if exists student
#建表
CREATE table student(
stuId int PRIMARY KEY auto_increment,
stuName VARCHAR(20),
stuSex VARCHAR(2),
stuAge int,
stuAddr VARCHAR(50)
);
#插入数据
INSERT INTO student(stuName,stuSex,stuAge,stuAddr) VALUES('张三','男',18,'北京');
INSERT INTO student(stuName,stuSex,stuAge,stuAddr) VALUES('李四','男',18,'重庆');
INSERT INTO student(stuName,stuSex,stuAge,stuAddr) VALUES('王五','男',18,'深圳');
二,JDBC内容
1,创建实体类
public class Student {
public int stuId;
public String stuName;
public String stuSex;
public int stuAge;
public String stuAddr;
public Student() {
}
public Student(int stuId, String stuName, String stuSex, int stuAge, String stuAddr) {
this.stuId = stuId;
this.stuName = stuName;
this.stuSex = stuSex;
this.stuAge = stuAge;
this.stuAddr = stuAddr;
}
/**
* 获取
* @return stuId
*/
public int getStuId() {
return stuId;
}
/**
* 设置
* @param stuId
*/
public void setStuId(int stuId) {
this.stuId = stuId;
}
/**
* 获取
* @return stuName
*/
public String getStuName() {
return stuName;
}
/**
* 设置
* @param stuName
*/
public void setStuName(String stuName) {
this.stuName = st