MySQL数据库与登录注册

数据库

数据库中增删改查

CREATE DATABASE clazz

CREATE TABLE  student(id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,stu_name varchar(30) NOT NULL,sex  int(1),age int(3))

insert into student(stu_name,sex,age)value('张三',1,0)
insert into student(stu_name,sex,age)value('李四',1,22)
insert into student(stu_name,sex,age)value('王五',0,23)

update  student set age=20,sex=0 where stu_name='张三'

select stu_name from student where age>20
select * from student

delete from student  where stu_name ='李四'
delete from student  where stu_name ='褚文斌'

insert into student(stu_name,sex,age)value('李海猛',0,23)

java连接数据库实现增删改查

   try {
            Class.forName(driver);//加载驱动
            //与数据库建立连接
            Connection conn=DriverManager.getConnection(url, user, password);
            if(!conn.isClosed()){
                //创建statement对象
                Statement state=conn.createStatement();
                //增