httpclient + TestNG 接口自动测试第四章

浏览数：31 / 时间：2015年06月09日

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);
    }