the Excel file correspond to the columns in the column one by one.
Use xml configuration to read data and use config to write data to a new Excel file:
@ Testpublic void testmap2 () {inputstream is = xls2listtest. class. getresourceasstream ("2.xls"); try {string xmlpath = xls2listtest. class. getresource ("/chargesmap. XML "). getpath (); List list = easyxls.xls 2 List (xmlpath, is); map = new hashmap (); map. put ("year", 2013); map. put ("ownersname", "test owner"); list. add (MAP); easyxls
DescriptionTo get this thing, I experimented on two operating systems for the win8.1 system and one ubuntu14.04lts, and the data was imported successfully.The win8.1 is postgresql9.3+postgis2.1+the latest version of osmosis. Under the win8.1: ubuntu14.04 is postgresql9.4+postgis2.1: (Back up)Reference:http://blog.csdn.net/bobantangzlt/article/details/17091625Http://wiki.openstreetmap.org/wiki/OsmosisHttp://wiki.openstreetmap.org/wiki/Osmosis/PostGIS_Setuphttp://www.v5cn.cn/?p=167First, install
You can use the BCP tool to export objects in the database as data files. The specific operations are as follows:
1. Contains query statements
Exec master .. xp_mongoshell 'bcp "select * from database. DBO. tablename" queryout "C: \ a.txt "-S"Databaseserver"-c-T'
2. query statements not included
Exec master .. xp_mongoshell 'bcp "database. DBO. tablename" out "C: \ a.txt "-S"Databaseserver"-c-T'
---------------------------------
Seve
Tags: body appears unicode how blog nbsp span style My ComputerPlsql import Chinese, will appear garbled, how to solve?Open PL/SQL, help---support information under character sets under Nls_lang, whether there is configuration information, if not, go to the environment variable configuration to add the corresponding configurationCharacter SetsCharacter Size:4 Byte (s)charsetid:873ncharsetid:2000Unicode Support:truenls_lang:simplified Chinese_china. ZH
,--port=port_num TCP used when connecting to a single host/IP port number. (This is used to connect to a host other than localhost because it uses a UNIX socket.) )-Q,--quick does not buffer queries, export directly to stdout; use Mysql_use_result () to do it. -s/path/to/socket,--socket=/path/to/Socket file used by the socket when connected to localhost (it is the default host). -T,--tab=path-to-some-directory for each given table, create a Table_name.sql file that contains the SQL create comman
Import MySQL Data to the SQLite database, but the SQL file exported by MySQL cannot be directly imported to SQLite, and you are too lazy to write code,
So I searched the internet, and there was such a tool to implement CYQ. DBImort.
Http://www.cyqdata.com/download/article-detail-42517
It is easy to use. You only need to enter the link string of from to. The string format is described as follows:
Sqlite:
/garvin/log.txt -Dflume.root.logger=INFO,consoleRecommend a few useful things:An example of a code implementation: Https://github.com/waqulianjie/odps_sinkDeveloper Document:http://flume.apache.org/flumeuserguide.htmlA more complete introduction: http://www.aboutyun.com/thread-8917-1-1.html
This article comes from the blog "Bo Li Garvin"Reprint please indicate source: Http://blog.csdn.net/buptgshengod]
Copyright NOTICE: This article for Bo Master original article, without Bo Maste
Export the Mysqldump tool that you want to use with MySQL, basic usage: Shell> mysqldump [OPTIONS] database [tables] If you do not give any tables, the entire database will be exported. By executing mysqldump--help, you can get the options table supported by your mysqldump version. Note that if you run mysqldump without--quick or--opt option, mysqldump will load the entire result set into memory before exporting the results, if you are exporting a lar
After another year, I finally updated the version. However, this version only advances to a small bit, from 3.0 to 3.1.
The version number is small, which indicates that this change is not big, but let's talk about it:1: The latest CYQ. Data V5 series with better performance have been replaced, and the Data batch insertion speed has been improved.
2: Modify the image type and time type conversion of MySql.
3: Modify the table structure of Txt and Xml.
4: The error output is automatically record
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.