httpclient + TestNG 介面自動化的測試 第四章

標籤：

1.用戶端向伺服器傳遞參數中有的需要傳遞Json格式資料，現提供個HashMap轉json格式資料方法

 public static String hashjson(HashMap<String, String> map) {          String string = "[{";          for (Iterator<Entry<String, String>> it = map.entrySet().iterator(); it.hasNext();) {              Entry<String, String> e = (Entry<String, String>) it.next();              string += "‘" + e.getKey() + "‘:";              string += "‘" + e.getValue() + "‘,";          }          string = string.substring(0, string.lastIndexOf(","));          string += "}]";          return string;      }  

2.擷取特定日期格式方法

public class TimeSimple {        public static String getTimeSimple() {        SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmssSSS");        return sdf.format(new Date());    }        public static String getDataSimple() {        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");        return sdf.format(new Date());     }}

3. 串連資料庫方法

    public static String query(String database, String tablename, String coulmn) {        Connection conn = null;        String sql;        int cinemaid = 0;        try {            Class.forName("com.mysql.jdbc.Driver");            System.out.println("成功載入MySQL驅動程式");            conn = (Connection) DriverManager.getConnection(url);            Statement stmt = (Statement) conn.createStatement();            sql = "select * from " + database + " where " + tablename + "= ‘" + coulmn + "‘";            System.out.println(sql);            ResultSet rs = (ResultSet) stmt.executeQuery(sql);            if(rs.next()) {                cinemaid = rs.getInt("id");            }    else {                System.out.println("未查詢到影院Id");            }                    } catch (Exception e) {            System.out.println("MySQL操作錯誤");            e.printStackTrace();        }finally {            try {                conn.close();            } catch (SQLException e) {                e.printStackTrace();            }        }        System.out.println(cinemaid + "");        return String.valueOf(cinemaid);    }    

 

httpclient + TestNG 介面自動化的測試 第四章