、、、
package com.bupt.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class jdbc_test {

public static void main(String[] args) {
    //创建连接对象
    Connection con = null;
    //创建查询对象
    PreparedStatement ps=null;  
    //创建结果集
    ResultSet rs = null;
    try {
            //加载数据库驱动
        Class.forName("com.mysql.jdbc.Driver");
            //获取链接
        con = DriverManager.getConnection("jdbc:mysql://localhost:3306/ssm_mybatis?useUnicode=true&characterEncoding=UTF8&useSSL=false","root", "root");
        
        String sql="SELECT * FROM user WHERE u_sex = ?";
        
        //获取statement
        ps= con.prepareStatement(sql);
        ps.setString(1, "0");
        //执行查询并返回结果集
        rs = ps.executeQuery();
        //遍历结果集。输出性别为0的元祖
        while(rs.next()) {
            System.out.println(rs.getString("u_id")+","+rs.getString("u_username")+","+rs.getString("u_sex"));
        }
        
    } catch (Exception e) {
        
        e.printStackTrace();
    }finally {
        //关闭三个对象，先打开的后关闭、
        if(rs!=null) {
            try {
                rs.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        if(ps!=null) {
            try {
                ps.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        if(con!=null) {
            try {
                con.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }
}

}

、、、