https://dev.mysql.com/downloads/j/下载
选择 (注:select Operating System这里一定要修改!!!)
解压后将jar包复制
在idea新建包lib,粘贴jar包,将新建包lib设为库
实现代码
public class demo1 {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//一方式
DataSource dataSource = new MysqlDataSource();
((MysqlDataSource) dataSource).setUrl("jdbc:mysql://localhost:3306/db2?characterEncoding=utf8&useSSL=false");//注册驱动
((MysqlDataSource) dataSource).setUser("root");//用户名
((MysqlDataSource) dataSource).setPassword("290015");//密码
String sql = "update dept set loc='江西1' where id=10";//mysql语句
Connection connection1 = ((MysqlDataSource) dataSource).getConnection();//获得连接对象
PreparedStatement statement1 = connection1.prepareStatement(sql);//执行对象
statement1.close();//关闭资源
connection1.close();//关闭资源
//二方式
Class.forName("com.mysql.cj.jdbc.Driver");//注册驱动
Connection connection = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/db2", "root", "******");
String sql1 = "update dept set loc='江西1' where id=10";//mysql语句
PreparedStatement statement = connection.prepareStatement(sql1);//执行对象
statement.execute(sql1);
statement.close();//关闭资源
connection.close();//关闭资源
}
}
注意若你出现红色警告,
将Class.forName("com.mysql.jdbc.Driver");改为
Class.forName("com.mysql.cj.jdbc.Driver");