The downward transformation is so troublesome. ((MysqlDataSource)dataSource).setPassword(" ") ((MysqlDataSource)dataSource).setUser("root") Create datasource instanceĭataSource dataSource = new MysqlDataSource() When we create a datasource instance according to our URL, account name and password, we make a step of preparation for connecting to the database. You also need to turn the datasource back to mysqldatasource to set the URL, user name and password.Īs the name suggests, datasource describes the source of data. Here, a downward transformation is used to point the parent class instance to a subclass reference. At the same time, set parameters for this datascure, namely URL, user and password. In this file, first create the main function.
Mysql jdbc catalog driver#
In this way, the driver package is completed.Ĭreate a new Java Class file. Then right-click the current package and find add as a library at the bottom. Then click refactor to see your driver package under the package. Create a package in the project directory, which I call JDBC test5, and drag the downloaded driver package directly under the package.
Mysql jdbc catalog download#
A link is attached here.ĭriver package download link 3、 JDBC five poison God palm 3.1 import driver package and create database instanceġ. X version, the corresponding driver package should also be 5 x.x。 I’m here for 8 XX version. Before starting MySQL JDBC programming, we should make some preparations.ĭatabase driver package: different databases need to import different data packages, and the version of the database should be the same as that of the driver package under the large version, and the small version can be ignored. If you want to do a good job, you must first sharpen your tools.
Mysql jdbc catalog portable#
JDBC is a specification, which provides a complete set of interfaces, allowing portable access to the underlying database, so different types of executable files can be written in Java Is an API that can execute SQL statements.
That is, Java database connectivity, Java and database link.
3: Encapsulate the addition, deletion, query and modification operations for the user table.2: Encapsulate the addition, deletion, query and modification operation for the book table.1: Encapsulate the operation of establishing links with the database.4.4 related operations of encapsulated database.4.3 construct entity classes related to database.3.1 import driver package and create database instance.
0 kommentar(er)
