JDBC

public static void test(){

                        try{

                                    String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

                                    String dbURL= "jdbc:sqlserver://10.69.4.53:2245;instanceName=ebenefitdev;databaseName=eCompassHKFVP114Dev";  

                                    String userName = "bsnpbog";   //

                                    String userPwd = "0410ahou";

                                    Class.forName(driverName);     

                                    Connection  conn = DriverManager.getConnection(dbURL, userName, userPwd);

                                    String sql=" select *  from  tfvp_mem_enrollment_mst st where st.clntcode = ? and st.FVP_Year= ? and st.CERTNO = ? "

                                                   + "    and st.enroll_status = ( select max(st1.enroll_status) " 

                                                   + "   from tfvp_mem_enrollment_mst st1 where st1.clntcode =st.clntcode  and st1.fvp_year=st.fvp_year and st1.certno = st.certno "

                                                   + "    and st1.enroll_status > 0 )  ";

                                    PreparedStatement stmt = conn.prepareStatement(sql);

                                    stmt.setString(1, "08020");

                                    stmt.setString(2, "2015");

                                    stmt.setString(3, "G01003241");

                                    ResultSet rs=stmt.executeQuery();

                                    while(rs.next()){

                                                System.out.println(rs.getString("memberid"));

                                    }

                                    rs.close();

                                    stmt.close();

                                    conn.close();

                        }catch(Exception e){

                                    e.printStackTrace();

                        }

            }