Database
Mysql Tutorial
[MySQL 03] Jar packages, driver class names and URL formats corresponding to various databases
[MySQL 03] Jar packages, driver class names and URL formats corresponding to various databases
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
| 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 |
| com.ibm.db2.jcc.DB2Driver | jdbc:db2://hostip:50000/dbname | |
| com.informix.jdbc .IfxDriver | jdbc:informix-sqli://hostip:port/dbname:informixserver= |
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1389
52
How to import jar package in eclipse
Jan 12, 2024 pm 03:45 PM
How to import jar packages in eclipse: 1. Create a new Java project; 2. Create a library folder; 3. Copy the jar package to the library folder; 4. Configure the project build path; 5. Add the jar package to the build path. ; 6. Configure the project build path; 7. Verify the import results; 8. Precautions; 9. Other import methods; 10. Clean and update; 11. Maintain and update the library. Detailed introduction: 1. Create a new Java project, start Eclipse IDE, select the "File" menu in the top menu bar, etc.
How to verify URL address format with PHP regular expression
Jun 24, 2023 am 09:51 AM
With the rapid development of the Internet, URL addresses have become an indispensable part of people's daily lives. In web development, in order to ensure that the URL address entered by the user can be correctly recognized and used by the system, we need to perform format verification on it. This article will introduce how to use PHP regular expressions to verify URL address format. 1. Basic components of URL addresses Before understanding how to verify the URL address format, we first need to understand the basic components of URL addresses. Usually, a standard URL address consists of
How to import jar package in maven
Jan 08, 2024 pm 01:59 PM
The steps for maven to import a jar package: 1. Download the jar package; 2. Create a Maven project; 3. Add dependencies; 4. Add dependency elements; 5. Save the pom.xml file; 6. Build the project; 7. Verify the import. Detailed introduction: 1. Download the jar package. First download the required jar package from the relevant website or source code warehouse. Make sure that the downloaded jar package is compatible with your project and meets the required version requirements; 2. Create a Maven project. If There is no Maven project yet, you need to create one first and so on.
Maven Advanced Tutorial: In-depth exploration of various methods of Jar package import
Feb 23, 2024 pm 02:57 PM
Title: Maven Advanced Tutorial: In-depth exploration of various methods of Jar package import. As a Java project management tool, Maven is widely used in project construction, dependency management, etc. In the actual development process, we often use Jar packages of various third-party libraries, and how to effectively import Jar packages has become a skill that must be mastered. This article will delve into the methods of importing Jar packages in Maven, including using local Jar packages, remote warehouse Jar packages, and custom Jar packages, and give specific details.
MySQL Jar package usage guide and precautions
Mar 01, 2024 pm 04:21 PM
MySQL Jar package usage guide and precautions MySQL is a commonly used relational database management system. Many Java projects use MySQL as the backend for data storage. In a Java project, to interact with the MySQL database, you need to use the Java driver (i.e. Jar package) provided by MySQL. This article will introduce the usage guidelines and precautions for the MySQL Jar package, and provide specific code examples to help readers better use the MySQL driver. 1. M
Guide on how to correctly import Jar packages into Maven projects
Feb 19, 2024 pm 12:00 PM
Maven Getting Started Guide: How to correctly import Jar packages? Maven is a powerful project management tool that can help developers manage project dependencies, build projects, etc. During project development, we often need to import external Jar packages to implement some functions. This article will introduce how to use Maven to correctly import Jar packages and provide specific code examples. First, we need to add dependencies on the required Jar packages in Maven's pom.xml file. In pom.xml, there is a
What is the Jar package of MySQL? Detailed analysis
Mar 01, 2024 pm 06:33 PM
The Jar package of MySQL refers to the Java driver package used to connect and operate the MySQL database. In Java development, the interaction function with the MySQL database needs to be implemented through the Jar package. MySQL's Jar package provides a series of classes and methods that allow developers to easily connect to the MySQL database, execute SQL statements, obtain query results, and other operations. Under normal circumstances, developers can download the MySQL Jar package through the official website or Maven repository and other channels, and then
Example analysis of remote code execution caused by uploading any jar package in apache flink
May 15, 2023 pm 01:01 PM
Vulnerability description: On November 11, 2019, security engineer Henry Chen disclosed a vulnerability that allows Apache Flink to upload jar packages without authorization, leading to remote code execution. Since Apache Flink Dashboard can be accessed without authentication by default, a shell can be obtained by uploading a malicious jar package and triggering the execution of malicious code. Scope of influence Export (export) b. Then select java-->RunnableJARfilec. Then select the corresponding java project, export path and export file name image. This will generate a rebound shell jar package msf to generate jar horse: (1) Use msfvenom afterlife
