JDBC快速入门及使用步骤

package ml.css.iterater.jdbc;

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

public class jdbc {
    public static void main(String[] args) throws Exception {
        //的导入驱动jar包 1，复制到一个目录下，2，add as library
       
       
       
        
       

        Class.forName("com.mysql.jdbc.Driver"); //注册驱动
        Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/emp","root","jbw5p2"); //获得数据库连接对象
        String sql="update emp set SAL =801.10 where EMPNO= 7369"; //定义sql语句
        Statement statement=conn.createStatement();//获得执行sql的对象statement
        int count=statement.executeUpdate(sql); //执行sql
        System.out.println(count);//        释放资源
        conn.close();
        statement.close();
    }
}