MYSQL, Oracle, and sqldatabase driver in JSP _ MySQL

MYSQLdatasource. urljdbc: mysql: localhost: 3306bbscs6? UseUnicodetruecharacterEncodingUTF-8datasource.usernamerootdatasource.passwordrootOracledatasource.driverClassNameoracle.jdbc.driver.OracleDriverdatasource.urljdbc: oracle: thin :@ 192.1

MYSQL

Datasource. url = jdbc: mysql: /localhost: 3306/bbscs6? UseUnicode = true & characterEncoding = UTF-8

Datasource. username = root

Datasource. password = root

Oracle

Datasource. driverClassName = oracle. jdbc. driver. OracleDriver

Datasource. url = jdbc: oracle: thin: @ 192.168.0.1: 1521: SID

Datasource. username = bbscs

Datasource. password = bbscs

Datasource. defaultAutoCommit = true

Hibernate. dialect = net. sf. hibernate. dialect. OracleDialect

For Oracle9, write

Hibernate. dialect = net. sf. hibernate. dialect. Oracle9Dialect

SQL Server

Datasource. driverClassName = com. microsoft. jdbc. sqlserver. SQLServerDriver

Datasource. url = jdbc: microsoft: sqlserver: // localhost: 1433; DatabaseName = bbscs

Datasource. username = bbscs

Datasource. password = bbscs

Datasource. defaultAutoCommit = true

Hibernate. dialect = net. sf. hibernate. dialect. SQLServerDialect

Datasource. username indicates the database ID, and datasource. password indicates the database password. IDs are generally set to sa and passwords. The driver includes the database name, ID, password, computer name, and port number (not in sequence. The JSP database must respond to the database driver for connection operations, or use JDBC and ODBC.

If any of the above errors or deficiencies are found, please submit them with eggs or tomatoes ~ I am responsible for cleaning up the site. Don't forget to leave your comments and suggestions !!!