10.21

合集 - Java(6)

1.10.162024-10-162.10.172024-10-173.10.182024-10-204.10.202024-10-20

5.10.212024-10-21

6.jsp+Mybatis+Mysql web开发制作模板02-20

收起

已经完成数据库的连接

点击查看代码

package qixun;

import com.mysql.jdbc.Driver;

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

public class jdbcDemo {
    public static void main(String[] args) throws Exception{
        //注册驱动
        Class.forName("com.mysql.jdbc.Driver");
        //获取连接
        String url = "jdbc:mysql://localhost:3306/qiii?useSSL=false&serverTimezone=UTC";
        String username = "root";
        String password = "1234";
        Connection conn=DriverManager.getConnection(url,username,password);
        //定义
        String sql="UPDATE ceeee set money = 6000 where id =2";
        //获取执行
        Statement stmt= conn.createStatement();

        //执行
        int count =stmt.executeUpdate(sql);//受影响的行数

        //处理结果
        System.out.println(count);

        //释放
        stmt.close();
        conn.close();
    }
}