MySQL-JDBC-链接复习day4

获取数据库链接：

语法：

jdbc:mysql://ip地址（域名）:端口/数据库名称

方法：

static Connection getConnection(String url, String user, String password)

import java.sql.Statement;
public class JDBCdemo {
    public static void main(String[] args) {
        Statement stmt = null;
        Connection conn = null;
        try {
        //1. 注册驱动
        Class.forName("com.mysql.jdbc.Driver");
        //2. 定义sql
        String sql = "insert into account values(null, 'people', 3000)";
        //3. 获取Connection对象
        conn = DriverManager.getConnection( url: "jdbc:mysql:///db", user:"root", password:"root");
        //4. 获取执行sql的对象Statement
        stmt = conn.createStatement();
        //5. 执行sql
        int count = stmt.executeUpdate(sql);//影响的行数
        //6. 处理结果
        System.out.printIn(count);
        }
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        if(stmt != null) {
            stmt.close;
        }
    }
}