步骤:
1.加载驱动
2.创建连接
3.写sql
4.得到statement对象
5.执行sql
6.处理结果集
7.关闭资源
创建数据库和表
连接mysql数据库,创建数据库和表,将数据库命名为zjgm,按图设置
创建表按图设置
并加入数据得到数据库
导入包
将jar包复制黏贴入字典,右键点出add as library对jar包进行解压
在java中对数据库进行修改
如图为查询
查询为:
String sql=“select * from stu”;
PreparedStatement statement = connection.prepareStatement(sql);
ResultSet resultSet = statement.executeQuery();
while (resultSet.next()) {
int id = resultSet.getInt(1);
String name=resultSet.getString( 2);
int age = resultSet.getInt(3);
System.out.println(id+name+age);
}
增:
String sql= “INSERT INTO stu values (‘3’,‘thh’,‘20’)”;
PreparedStatement statement=connection.prepareStatement(sql);
statement.executeUpdate();
改:
String sql= “UPDATE stu set name=‘二哈’ WHERE id=‘3’”;
PreparedStatement statement=connection.prepareStatement(sql);
statement.executeUpdate();
删:
String sql= “DELETE from stu WHERE id=‘3’”;
PreparedStatement statement=connection.prepareStatement(sql);
statement.executeUpdate();