python
cmd输入pip install pymssql安装mysql-connector-python模块
Java
从mysql官网下载mysql-connector-java.jar包到本地,打开自己的java文件,在源文件夹下创建lib包
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class sql {
public static void main(String[] args) throws Exception {
Statement state = null;
Connection conn = null;
try {
//2.注册驱动
Class.forName("com.mysql.cj.jdbc.Driver");
//3.获取数据库连接对象
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/数据库名?serverTimezone=GMT%2B8", "root", "数据库密码");
//4.定义sql语句
String sql = "update student set ClsNo='GL01' where ClsNo in(select ClsNo from (select ClsNo from student group by ClsNo order by AVG(sage) limit 1)as temp)";
//5.获取执行sql的对象 Statement
state = conn.createStatement();
//执行sql
int count = state.executeUpdate(sql);
//7.处理结果
System.out.println(count);
} catch (SQLException e) {
e.printStackTrace();
}finally {
try {
if (state!=null){
//8.释放资源
state.close();
}
} catch (SQLException throwables) {
throwables.printStackTrace();
}
try {
if (conn!=null){
conn.close();
}
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}