3445

select score  from (select score  from lujinsuo order by id desc ) where rownum <=3

8efa33e5caf1f9a63f893015de52bc22d5f0cdb6

(description =(address = (protocol = tcp)(host = 10.59.33.203)(port = 1521))(connect_data = (sid = t3pay)))

-------------STG3----------------
pub_test/pub_test@(description =(address = (protocol = tcp)(host = 10.59.33.203)(port = 1521))

void testRandom() {

        String userName = "testUser" + RandomStringUtils.randomNumeric(6);

}

http://172.20.249.7:58080/merchant/merchant.html?env=prod

http://test5-bx-fncp-fm-web.stg.1qianbao.com/fncp-fm-web/cashier/payPriority/toPayPriorityConfig--金融管控-stg5

http://192.168.0.77:8080/job/restart_fncp-fm-web_stg5/--jenkins

http://10.59.33.63/testlink/index.php---testlink

http://badao.pinganfu.net/issues/36395---霸道

http://10.59.32.199:9080/---自动化

http://10.59.32.147:8080/paffmqweb/signin--MQ

http://10.59.32.200:30001/---STG3DUBBO

http://21.68.19.37:30001/---STG5DUBBO

http://21.68.0.138/login.html---STG5自动化

Lipanpan934

#@!321zhiwan

https://test5-bx-paffpassportweb.stg.1qianbao.com/paffpassportweb/login?src=http://test5-bx-omsweb.stg.1qianbao.com/omsweb/index/index----宝信stg5OMS

 

https://test2-paffpassportweb.stg.1qianbao.com/paffpassportweb/login?src=http://10.189.6.144/omsweb/index/index

 

】oms 2

 

 

http://paymain3.test.swiftpass.cn/pay/gateway

 

 

 

https://test5-h5.stg.1qianbao.com/cashier/zhiwan/index.html#/index?transId=8F01E99FF5AA4D12FC2585D6D8C943EBADD116C285ACF2B9C669B412D3AB244CD0F254C616B372B7

 

[{
    "accessProductId": "",
    "appId": "",
    "bankCode": "CCB",
    "cardType": "D",
    "casherType": "",
    "deviceMessage": "",
    "loginIP": "",
    "loginTerminal": "",
    "merchantNo": "",
    "plugInId": "",
    "scene": "",
    "signSource": "",
    "signSourceChannel": "",
    "signSupport": "2"
}]

 

[{
    "businessId": "APPYHKJQ2",
    "cardName": "曹六八",
    "cardNo": "",
    "cardSeqNo": "BDDAC947523AAA3C2806FA6FB22509EF",
    "cardType": "D",
    "cvv2": "112",
    "identityCode": "15260119870721365X",
    "identityType": "I",
    "mobile": "13800138123",
    "month": "",
    "params": {
        "KEY2": "壹钱包",
        "KEY1": "壹钱包"
    },
    "phase": "1",
    "signTransNo": "00000000000000000000000000744320",
    "templateId": "otp_template_yqb_mtp_bind_bankcard_three2",
    "year": ""
}]

 

 

[{
    "contractSignTime": 1487210998077,
    "contractTerminateTime": 1487210998077,
    "cvv2": "",
    "fastPayType": "",
    "merchantCustNo": "",
    "merchantNo": "",
    "month": "",
    "signTransNo": "00000000000000000000000000744319",
    "smsCode": "921312",
    "userId": "",
    "year": ""
}]

 

 

http://192.168.0.77:8080/view/20170907/job/----jenkins

http://10.59.2.151/deploy_apps/---部署

b4e187917808ed94c81a69f125e67b139f2db079

http://10.189.6.190:8080/PAFTestPlatform/msg.jsp---短信验证码平台

 

1）如何定位元素（id, xpath, css selector） 学习途径：w3c;

xpath的学习,用相对路径，不用绝对路径；能参数化，就参数化；

http://www.w3school.com.cn/xpath/index.asp

CSS：

http://www.w3school.com.cn/css/index.asp

 

定位元素的工具（FireFox, Chrome插件，按F12）；XPather;

前端三大利器，熟悉dom结构；

 

2）如何选择不同的浏览器；

3）安放我们脚本的文件目录 - 移动UI组；SVN的使用 (github, gitlab)；

 

4）如何等待：sleep（不推荐使用），使用selenium的explicitWait（selenium官网）

https://www.seleniumhq.org/

 

implicitWait和explicitWait的区别：

https://stackoverflow.com/questions/22656615/what-is-difference-between-implicit-wait-vs-explicit-wait-in-selenium-webdriver#

http://toolsqa.com/selenium-webdriver/implicit-explicit-n-fluent-wait/

 

5）哪些selenium的API，我们是需要熟悉的；（WebDriver, WebElement, RemoteWebDriver, By, CaptureSnapshot，DesiredCapabilities, ）；

如何快速地学习selenium的常用API？ - seleniumIDE;

 

6）用例如何跑起来（selenium hub, selenium node）

 

7）函数调用，封装；组合函数；用函数的思维抽象出公共的操作；

 

8）debug的时候出错了，怎么办？stackoverflow - Q&A;

https://stackoverflow.com/ 

 

9）如何在浏览器模拟H5的UI自动化测试；UserAgent;

 

10）稳定性、代码可维护性考虑；高于测试脚本的代码质量；

 

11）版本匹配的问题, webdriver jar的版本，和chromedriver，FF，IE浏览器版本，dirver版本的匹配问题；

 

12) 如何下载selenium的jar包，阅读源代码；

mvn clean test-compile -U;

https://mvnrepository.com/artifact/org.seleniumhq.selenium/selenium-java/3.11.0

 

<dependency>

    <groupId>org.seleniumhq.selenium</groupId>

    <artifactId>selenium-java</artifactId>

    <version>3.11.0</version>

</dependency>

转载于:https://my.oschina.net/u/3572890/blog/1057670