Copy Code code as follows:
' Converts a string into a database SQL statement format
'-------------------------------------------------
Function Allstr2database (Str,strtype)
Dim Strtemp:strtemp=str
Select Case Strtype
Case ""
Case "Num"
strtemp = CLNG (strtemp)
Case "string" without trim
strtemp = Replace (strtemp, "'", "")
Case "STR_BR" "no trim, convert carriage return to strtemp = replace
connector/j DriverDriver package Name: Mysql-connector-java-x.x.xx-bin.jarDriver class Name: com.mysql.jdbc.DriverJDBC URL: jdbc:mysql://Default Port 3306, port can be omitted if the server uses the default portMySQL connector/j Driver allows additional connection properties to be added to the URL jdbc:mysql://Informixinformix JDBC DriverDriver package Name:Ifxjdbc.jarDriver class Name: com.informix.jdbc.IfxDriverJDBC URL: jdbc:informix-sqli://{Sybasesybase Adaptive Server Enterprise JDBC Drive
Recently been busy in the laboratory, did not properly update the blog, in the process of grasping the package, encountered a lot of problems.Because I often use Wireshark to export the capture information to a CSV file, here's a simple mark about 2 ways to import/export a CSV file to a database:A. Simple, but slightly slower way to use Navicat for MySQLto import the database:The process is as follows:The installation is complete and the connection interface is configured as follows:New Database
Label:Error_reporting (E_all | | ~e_notice);Header ("access-control-allow-origin:*");//This allows Web sites to be accessed across domainsHeader ("Content-type:application/json;charset=utf-8");//This declaration returns a JSON type and a character set of Utf-8$link =mysql_connect (' localhost ', ' root ', ');if (! $link) {echo "fail";}mysql_select_db ("test");$result =mysql_query ("SELECT * from Artitle");$json = "";$data =array (); Defines the good one array. The array in PHP is equivalent to a
1 sqlite Driver package Name: Sqlitejdbc-v056.jar Driver class Name: Org.sqlite.JDBCJDBC url:jdbc:sqlite:c:\*.db default Port no 2 Microsoft SQL Servermicrosoft SQL Server JDBC Driver (typically used to connect to SQL Server) driver package name: Msbase.jar Mssqlserver.jar Msutil.jar Driver class Name: Com.microsoft.jdbc.sqlserver.SQLServerDriverJDBC url:jdbc:microsoft:sqlserver://Common database JDBC URL format
Label:
The principle is to take the middle of the number of milliseconds, and then converted to JS date type Function Changedateformat (val) { if (val! = null) { var date = new Date (parseint ("Val.replace" ("/date", "" "). Replace (")/"," "), 10)); //month 0-11, so +1, month less than 10 o'clock complement 0 var month = Date.getmonth () + 1
JSON returns the time format of the
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.