jdbc入门 连接mysql执行简单语句详解编程语言

package cn.itcast.jdbc; 
 
import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.Statement; 
 
/** 
 * @Author: Zhang 
 * @Description:JDBC快速入门 
 * @Date: Created in 15:18 2020/12/27 
 * @Modified By: 
 */ 
public class JdbcDemo1 {
    
    public static void main(String[] args) throws Exception {
    
        //1.导入jar包 
        //2.注册驱动 
        Class.forName("com.mysql.jdbc.Driver"); 
        //3.获取数据库的连接对象 
        Connection conn = DriverManager.getConnection("jdbc:mysql://doitedu01:3306/test","root","ABC123abc.123"); 
        //4.定义sql语句 
        String sql = "update student set  gender = 'w' where id = '201901' "; 
        //5.获取执行sql的对象Statement 
        Statement statement = conn.createStatement(); 
        //6.执行sql 
        int count = statement.executeUpdate(sql); 
        //7.处理结果 
        System.out.println(count); 
        //8.释放资源 
        statement.close(); 
        conn.close(); 
 
 
 
    } 
}