常见读取excel一般使用POI和JExcelAPI这两个库。 POI: POI 下载处 http://poi.apache.org/ 创建工作簿 // 07之前版本 Workbook wb = new HSSFWorkbook(); FileOutputStream fileOut = new F Read More
posted @ 2016-08-15 18:24 Ron_ask Views(1786) Comments(0) Diggs(0)
1.以id分组,把name字段的值打印在一行,逗号分隔(默认) select id,group_concat(name) from aa group by id; 2.多表多行多列合并。 SELECT cg.`ID`,cg.`Name`,cg.`Notes`,cg.`AddDate`,GROUP_C Read More
posted @ 2016-08-09 15:13 Ron_ask Views(5448) Comments(0) Diggs(0)
1. 下载Mysql驱动。 Link:http://dev.mysql.com/downloads/connector/j/ 2.加载JDBC 在Eclipse中,选中相应的工程,Properties->Java Build path->add external jars->ok. 3.JDBC操作 Read More
posted @ 2016-06-02 18:56 Ron_ask Views(5441) Comments(0) Diggs(0)
在装完Wampserver2.5后点击phpMyadmin我发现网页显示:#1045 - Access denied for user 'root'@'localhost' (using password: NO)意思是我没有设置数据库密码。解决办法:找到wamp的安装路径,打开wamp——>app... Read More
posted @ 2015-11-24 18:23 Ron_ask Views(852) Comments(0) Diggs(0)
#获取table的行数rowCount = len(driver.find_elements_by_xpath('//*[@id="list-table"]/tbody/tr'))#获取第三列的每一行的值for i in range(2,rowCount): print driver.find... Read More
posted @ 2015-10-14 17:40 Ron_ask Views(5051) Comments(0) Diggs(0)
第一种 :impoort MySQLdbdef mysql_connect(host,user,passwd,db,sql): conn=MySQLdb.connect(host=host,user=user,passwd=passwd,db=db,charset="utf8") cur... Read More
posted @ 2015-10-14 17:19 Ron_ask Views(274) Comments(0) Diggs(0)
获取当前时间import timeimport datetime所用的方法:strftime(format[, tuple]) -> string获取当前日期time.strftime('%Y-%m-%d-%H:%M:%S',time.localtime(time.time()))或者datetim... Read More
posted @ 2015-10-12 16:12 Ron_ask Views(152) Comments(0) Diggs(0)
点击右上角即可分享
微信分享提示