[MySQL 03] Jar packages, driver class names and URL formats corresponding to various databases-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

[MySQL 03] Jar packages, driver class names and URL formats corresponding to various databases

黄舟

Feb 04, 2017 am 11:43 AM

1. Jar packages corresponding to various databases

Database type	Corresponding Jar files
Oracle 8i	classes12.zip or ojdbc14.jar
Sybase	jconn2.jar or jconn3.jar
Mysql	mysql-connector-java-3.1.1-alpha-bin.jar or mysql-connector-java-5.0.2-beta-bin.jar
SQLServer 2000	msbase.jar, msutil.jar, mssqlserver.jar
SQLServer 2005	sqljdbc.jar
SQLServer 7.0	jtds-1.2.2.jar
Informix	ifxjdbc.jar
DB2	db2jcc.jar, db2jcc_license_cu.jar

2. Driver class names and URL formats corresponding to various databases

##DB2 com.ibm.db2.jcc.DB2Driverjdbc:db2://hostip:50000/dbnameInformixcom.informix.jdbc .IfxDriverjdbc:informix-sqli://hostip:port/dbname:informixserver=

Database	Drive class name	URL format
Oracle	oracle.jdbc.driver.OracleDriver	jdbc:oracle:thin:@hostip:1521:dbname
Sybase	com.sybase.jdbc2.jdbc.SybDriver	jdbc:sybase:Tds:hostip:4100/dbname
Mysql	com.mysql.jdbc.Driver	jdbc:mysql://hostip:3306/dbname?useUnicode=true&characterEncoding=GB
SQLServer 2000	com.microsoft.jdbc.sqlserver.SQLServerDriver	jdbc:microsoft:sqlserver://hostip:1433;Databas
SQLServer 2005	com.microsoft.sqlserver.jdbc.SQLServerDriver	jdbc:sqlserver://hostip:1433;DatabaseName=d
SQLServer 7.0	net.sourceforge.jtds.jdbc.Driver	jdbc:jtds:sqlserver://hostip:1433/dbname

The above is [MySQL 03] various The contents of the jar package, driver class name and URL format corresponding to the database. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

MySQL String Types: Storage, Performance, and Best PracticesMay 10, 2025 am 12:02 AM

MySQLstringtypesimpactstorageandperformanceasfollows:1)CHARisfixed-length,alwaysusingthesamestoragespace,whichcanbefasterbutlessspace-efficient.2)VARCHARisvariable-length,morespace-efficientbutpotentiallyslower.3)TEXTisforlargetext,storedoutsiderows,

Understanding MySQL String Types: VARCHAR, TEXT, CHAR, and MoreMay 10, 2025 am 12:02 AM

MySQLstringtypesincludeVARCHAR,TEXT,CHAR,ENUM,andSET.1)VARCHARisversatileforvariable-lengthstringsuptoaspecifiedlimit.2)TEXTisidealforlargetextstoragewithoutadefinedlength.3)CHARisfixed-length,suitableforconsistentdatalikecodes.4)ENUMenforcesdatainte

What are the String Data Types in MySQL?May 10, 2025 am 12:01 AM

MySQLoffersvariousstringdatatypes:1)CHARforfixed-lengthstrings,2)VARCHARforvariable-lengthtext,3)BINARYandVARBINARYforbinarydata,4)BLOBandTEXTforlargedata,and5)ENUMandSETforcontrolledinput.Eachtypehasspecificusesandperformancecharacteristics,sochoose

How to Grant Permissions to New MySQL UsersMay 09, 2025 am 12:16 AM

TograntpermissionstonewMySQLusers,followthesesteps:1)AccessMySQLasauserwithsufficientprivileges,2)CreateanewuserwiththeCREATEUSERcommand,3)UsetheGRANTcommandtospecifypermissionslikeSELECT,INSERT,UPDATE,orALLPRIVILEGESonspecificdatabasesortables,and4)

How to Add Users in MySQL: A Step-by-Step GuideMay 09, 2025 am 12:14 AM

ToaddusersinMySQLeffectivelyandsecurely,followthesesteps:1)UsetheCREATEUSERstatementtoaddanewuser,specifyingthehostandastrongpassword.2)GrantnecessaryprivilegesusingtheGRANTstatement,adheringtotheprincipleofleastprivilege.3)Implementsecuritymeasuresl

MySQL: Adding a new user with complex permissionsMay 09, 2025 am 12:09 AM

ToaddanewuserwithcomplexpermissionsinMySQL,followthesesteps:1)CreatetheuserwithCREATEUSER'newuser'@'localhost'IDENTIFIEDBY'password';.2)Grantreadaccesstoalltablesin'mydatabase'withGRANTSELECTONmydatabase.TO'newuser'@'localhost';.3)Grantwriteaccessto'

MySQL: String Data Types and CollationsMay 09, 2025 am 12:08 AM

The string data types in MySQL include CHAR, VARCHAR, BINARY, VARBINARY, BLOB, and TEXT. The collations determine the comparison and sorting of strings. 1.CHAR is suitable for fixed-length strings, VARCHAR is suitable for variable-length strings. 2.BINARY and VARBINARY are used for binary data, and BLOB and TEXT are used for large object data. 3. Sorting rules such as utf8mb4_unicode_ci ignores upper and lower case and is suitable for user names; utf8mb4_bin is case sensitive and is suitable for fields that require precise comparison.

MySQL: What length should I use for VARCHARs?May 09, 2025 am 12:06 AM

The best MySQLVARCHAR column length selection should be based on data analysis, consider future growth, evaluate performance impacts, and character set requirements. 1) Analyze the data to determine typical lengths; 2) Reserve future expansion space; 3) Pay attention to the impact of large lengths on performance; 4) Consider the impact of character sets on storage. Through these steps, the efficiency and scalability of the database can be optimized.

See all articles