JDBC(Java连接数据库)
package ff;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class pg1 {
public static void main(String[] args) throws Exception{
//1.导进jar包
// 2.注册驱动
Class.forName("com.mysql.cj.jdbc.Driver");
// 3.获取数据库连接对象
Connection con=DriverManager.getConnection
("jdbc:mysql://localhost:3366/mysql?serverTimezone=GMT%2B8\n&useSSL=false", "root","F7847870");
// 4.定义sql语句
String sql="update account set money=999 where name='zs'";
// 5.获取执行sql的对象Statament
Statement statement=con.createStatement();
// 6.执行sql
int count=statement.executeUpdate(sql);
// 7.处理结果
System.out.println(count);
// 8.释放资源
con.close();
statement.close();
}
}