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();
//增
String insert="insert into student(stu_name,sex,age)values('旺财',1,23)";
//改
String update ="update student set age=20 where stu_name='李四'";
//删
String delete="delete from student where stu_name='李四'";
//state.execute(insert);增删改//查
String select="select *from student";
//ResultSet 对象具有指向其当前数据行的光标。最初,//光标被置于第一行之前。next 方法将光标移动到下一行;//因为该方法在 ResultSet 对象没有下一行时返回 false,//所以可以在 while 循环中使用它来迭代结果集。
ResultSet set=state.executeQuery(select);
set.first();
while(!set.isAfterLast()){
String name =set.getString("stu_name");
System.out.println(name);
set.next();
}
}else{
}