package jdbcStudy;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
/**
* JDBC快速入门
* @author KuKaFei.Hai
* @date 2020/4/26 : 17:38
*/
public class JDBCDemoA {
/**
* JDBC 连接数据库的8个步骤
*/
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//1.导入jar包
//复制 mysql-connector-java-5.1.48-bin.jar 到项目的libs目录下
//右键 --> Add As Library 将jar 包注册到项目中去
//2.注册类 加载进内存
Class.forName("com.mysql.jdbc.Driver");
//3.获取数据库的连接对象
//3.1 ?verifyServerCertificate=false&useSSL=false :设置USESL= false来显式禁用SSL,或者设置USELS=真,并为服务器证书验证提供信任存储。
String urlStr="jdbc:mysql://172.16.1.9:3306/enterpriseinfomation?verifyServerCertificate=false&useSSL=false";
String userName="root";
String password="*************";
//Connection conn = DriverManager.getConnection("", "root", "*************");
Connection conn = DriverManager.getConnection(urlStr, userName, password);
//4.定义SQL语句
String sql="update salarygrade set hisalary = 99999 where grade =5";
//5.申请名执行sql的对象
Statement statment = conn.createStatement();
//6.执行SQl
int i = statment.executeUpdate(sql);
//7.处理结果
if(i>0){
System.out.println("成功更新"+i+"行数据");
}else {
System.out.println("执行更新语句失败。");
}
//8.释放失败
statment.close();
conn.close();
}
}