金融信贷风控中的机器学习,课程下载:百度网盘 提取码:5w6e
如何搭建金融信贷风控中的机器学习模型,课程下载:百度网盘 提取码: 4eh9
java
import java.sql.*;
public class Demo02 {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//1注册驱动
Class.forName("com.mysql.jdbc.Driver");
//2建立连接
String url = "jdbc:mysql://localhost:3306/mydb01";
String usernName = "xxx"; //登录数据库的账号
String password = "xxxx"; //登录数据库的密码
Connection conn = DriverManager.getConnection(url, usernName, password);
//3获取执行sQL语句的对象
Statement statement = conn.createStatement();
//4获取数据库返回的结果
String sql = "delete from emp where empno = " +"7499";
String sqlUpdate = "update emp set sal = "+10000+" where empno = " +"7369";
String sqlInsert = "INSERT INTO emp VALUES(2018,\"boss\",\"king\",NULL,\"2018-8-
8\",15000,10000,10);";
//5处理数据集
int i = statement.executeUpdate(sql);
int s = statement.executeUpdate(sqlUpdate);
int ins = statement.executeUpdate(sqlInsert);
System.out.println(i + "行受到影响----删除");
System.out.println(s + "行受到影响----更新");
System.out.println(ins + "行受到影响----插入");
//6关闭连接
statement.close();
conn.close();
}
}