class xxx{

    private static String port = "1433";

    private static String ip = "192.168.2.163";

    //mysql : jdbc:mysql://

    //sqlserver : jdbc:sqlserver//  或者   jdbc:microsoft:sqlserver://

    private static String driverType = "jdbc:sqlserver://";

    private static String DatabaseName = "test";

    private static String username = "sa";

    private static String password = "123456";

    //sqlerver数据库 com.microsoft.sqlserver.jdbc.SQLServerDriver驱动

    //mysql 数据库 com.mysql.jdbc.Driver 驱动

    private static String Drivermanager = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

    //取得本地保存的自定义标识

    private static Map<String,String> localMap = new HashMap<>();

    //接收到数据库返回的自定义标识

    private static Map<String,Member> databaseMap = new HashMap<>();

    //本地保存拼接标识文件

    private static String FileSavePath = "E:/check/ckeckMemberInfoforJZ/member001.data";

    private static String catchMemberSql = "select * from memberUpdate";

    private static String catchCardNotSql = "";//获取数据库连接，执行目的语句

    private static ResultSet getJdbcConnet(String directSql){

        Connection connection;

        Statement statement;

        ResultSet resultSet = null;

        //拼接成稳定的URL

        try {

        String basicUrl = driverType+ip+":"+port+";DatabaseName="+DatabaseName;

            Class.forName(Drivermanager).newInstance();

            connection = DriverManager.getConnection( basicUrl,

                    username, password);

            System.out.println("jdbc connect success");

            statement = connection.createStatement();
            resultSet = statement.excute(directSql);

        }catch (ClassNotFoundException e){

            e.printStackTrace();

        }catch (SQLException e){

            e.printStackTrace();

        }catch (IllegalAccessException e){

            e.printStackTrace();

        }catch (InstantiationException e){

            e.printStackTrace();

        }

            return resultSet;

    }