Java，

Java，

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;public class Test {
 static String sql = "jdbc:mysql://localhost:3306/mysql";
 static String root;
 static String pwd; public static void User()
 {
  Connection con = null;
  PreparedStatement ps = null;
  ResultSet rs = null;
  try {
   Class.forName("com.mysql.jdbc.Driver");
   try {
    con = DriverManager.getConnection(sql, "root", "123456");
    ps = con.prepareStatement("select id,name,age,gender from t_user where id=?");
    ps.setInt(1, 1);
    rs = ps.executeQuery();
    while (rs.next()) {
    System.out.println("id=" + rs.getInt(1) + ",name=" + rs.getString(2)+",年龄"+rs.getInt(3)+",性别"+rs.getString(4));
    }
       } catch (SQLException e) {    e.printStackTrace();
       }    } catch (ClassNotFoundException e) {
     e.printStackTrace();
    } finally {
     try{
    
     if (rs != null) {
     rs.close();}
     if (ps != null) {
     ps.close();}
      if (con != null) {
      con.close();
      }
     }
     
    catch (SQLException e) {
       e.printStackTrace();
      
     
    }
     
   }
  
 }
 public static void main(String[] args) {
  Test.User();
  }
 }