数据库
1.代码优化
1.查询一个(不通用)
public static void queryOne(String sql) throws Exception {
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bailiban", "root", "123456");
Statement stat = conn.createStatement();
ResultSet query = stat.executeQuery(sql);
if (query.next()){
String id = query.getString("id");
String name = query.getString("name");
String sex = query.getString(