JDBC连接MySql

public static void main(String[] args) { String Driver ="com.mysql.jdbc.Driver"; String url = "jdbc:mysql://localhost:3306/text?useUnicode=true&characterEncoding=utf-8&useSSL=false"; String user = "root"; String password = "root"; Connection conn = null; try { //1.加载驱动 Class.forName(Driver); //2.连接数据库 conn = DriverManager.getConnection(url,user,password); //3.执行sql语句 PreparedStatement ps = conn.prepareStatement("SELECT * FROM user WHERE age=?");// ?用于防止sql注入 ps.setString(1, "30"); /** * executeUpdate() 执行增删改操作 返回影响的行数 * ps.executeQuery() 用于查询 需ResultSet接收查询结果 */ ResultSet res=ps.executeQuery(); while (res.next()){ String name= res.getString("name"); int age = res.getInt("age"); System.out.println("姓名："+name+"年龄："+age); } } catch (Exception e) { e.printStackTrace(); }finally { try { //4.关闭连接 conn.close(); } catch (SQLException e) { e.printStackTrace(); } } }