配置环境
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class JDBC {
public static void main(String[] args) throws Exception{
//注册驱动
Class.forName("com.mysql.jdbc.Driver");
//获取链接
String url ="jdbc:mysql://localhost:3306/350?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false";
String username="root";
String password="root";
Connection connection = DriverManager.getConnection(url,username,password);
if(connection!=null){
System.out.println("连接到数据库啦!");
}else{
System.out.println("没有连接到数据库");
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class JDBC {
public static void main(String[] args) throws Exception{
//注册驱动
Class.forName("com.mysql.jdbc.Driver");
//获取链接
String url ="jdbc:mysql://localhost:3306/350?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false";
String username="root";
String password="root";
Connection connection = DriverManager.getConnection(url,username,password);
if(connection!=null){
System.out.println("连接到数据库啦!");
}else{
System.out.println("没有连接到数据库");
}
//定义sql
String sql = "update student set age = 99 where age = 20";
//获取sql的对象Statement
Statement statement = connection.createStatement();
//执行sql
int count = statement.executeUpdate(sql);//返回影响行数
//处理结果
System.out.println(count);
//释放资源
statement.close();
connection.close();
}
}