JDBC

public static void test(){

                        try{

                                    StringdriverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

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

                                    StringuserName = "bsnpbog";   //

                                    StringuserPwd = "0410ahou";

                                    Class.forName(driverName);     

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

                                    Stringsql=" 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) " 

                                                  + "   fromtfvp_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 )  ";

                                    PreparedStatementstmt = conn.prepareStatement(sql);

                                    stmt.setString(1,"08020");

                                    stmt.setString(2,"2015");

                                    stmt.setString(3,"G01003241");

                                    ResultSetrs=stmt.executeQuery();

                                    while(rs.next()){

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

                                    }

                                    rs.close();

                                    stmt.close();

                                    conn.close();

                        }catch(Exception e){

                                    e.printStackTrace();

                        }

            }