package cn.itcast.jdbc;
import java.sql.*;
public class jdbc{
public static void main(String[] args) throws SQLException {
Statement stmt = null;
Connection conn = null;
try {
// 1. 注册驱动
Class.forName("com.mysql.cj.jdbc.Driver");
// 2. 定义sql
String sql = "insert into account values(null,'王五',3000)";
// 3. 获取Connection对象
conn = DriverManager.getConnection("jdbc:mysql:///db3?serverTimezone=GMT%2B8","root","123456");
// 4. 获取执行sql的对象 statement
stmt = conn.createStatement();
// 5. 执行sql
int count = stmt.executeUpdate(sql); //影响的行数
// 6. 处理结果
System.out.println(count);
if(count > 0){
System.out.println("添加成功!");
}else{
System.out.println("添加失败!");
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException throwables) {
throwables.printStackTrace();
}finally {
//stmt.close();
// 7. 释放资源
// 避免空指针异常
if(stmt != null){
try {
stmt.close();
} catch (SQLException e){
e.printStackTrace();
}
}
if(conn != null){
try {
conn.close();
} catch (SQLException e){
e.printStackTrace();
}
}
}
}
}
修改和删除基本上完全相同
// 3. 定义sql
String sql = "update account set balance = 1500 where id = 3";
String sql = "delete from account where id = 3";
String sql = "create table student (id int, name varchar(20))"; //执行之后没有返回值
练习1.account表 添加一条记录
最新推荐文章于 2023-03-14 13:30:56 发布