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 !!!