Java的JDBC的练习一（insert）

Java的JDBC的练习一

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

/*
insert练习:
    account表添加一条记录insert语句
 */
public class JDBC03 {
    public static void main(String[] args) throws SQLException {
        Statement stm=null;
        Connection con=null;
        //1.驱动jar包
        //2.注册驱动
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
        //3.定义sql
            String sql="insert into account values(3,'王五',3000)";
            //4.获取Connection对象
        con=DriverManager.getConnection("jdbc:mysql:///hsp_db02","root","011012");
        //5.获取执行sql的对象
        stm=con.createStatement();
            //6.执行sql
        int count=stm.executeUpdate(sql);//影响的行数
            //7.处理结果
            System.out.println(count);
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }finally {
            //stm.close();
            //避免空指针
            if(stm!=null){
                try{
                    stm.close();
                }catch (SQLException e){
                    e.printStackTrace();
                }
            }
            //con.close();
            if(con!=null){
                try{
                    con.close();
                }catch (SQLException e){
                    e.printStackTrace();
                }
            }
        }

    }
}