JDBC

1. 概念：

   

    

2. 

    

3. 代码实现：

   package JDbc;
   
   import java.sql.Connection;
   import java.sql.DriverManager;
   import java.sql.SQLException;
   import java.sql.Statement;
   
   public class jabcdome {
       public static void main(String[] args) throws ClassNotFoundException, SQLException {
           //注册驱动
           Class.forName("com.mysql.jdbc.Driver");
           //获取连接
           String url="jdbc:mysql://127.0.0.1:3306/homework";
           String user="root";
           String password="1234";
           Connection conn = DriverManager.getConnection(url, user, password);
           //定义sql语句
           String sql="UPDATE lyj SET credit=999 WHERE id=3";
           //获取执行对象 Statement
           Statement statement=conn.createStatement();
           //执行sql
           int i = statement.executeUpdate(sql);//返回值为受影响的行数
           //处理结果
           System.out.println(i);
           //释放资源
           conn.close();
           statement.close();
   
   
       }
   }