JSP database connection

1. SQL Server 2000 database connection

Driver: String driverclass = "com. Microsoft. JDBC. sqlserver. sqlserverdriver ";

Required packages: msbase. jar, MSSQLServer. jar, and msutil. Jar

URL: String url = "JDBC: Microsoft: sqlserver: // 127.0.0.1: 1433; databasename = db_jsdq10 ";

2. SQL Server 2005 database connection

Driver: String driverclass = "com. Microsoft. JDBC. sqlserver. sqlserverdriver ";

Required packages: msbase. jar, MSSQLServer. jar, and msutil. Jar

URL: String url = "JDBC: Microsoft: sqlserver: // 127.0.0.1: 1433; databasename = db_jsdq10 ";

3. Access Database Connection

Driver: String driverclass = "Sun. JDBC. ODBC. jdbcodbcdriver ";

No package is required

URL: String url = "JDBC. ODBC: Driver = {Microsoft Access Driver (*. mdb)}; DBQ = D:/db_jsdq10.mdb ";

Iv. MySQL database connection

Driver: String driverclass = "com. MySQL. JDBC. Driver ";

Need to use the package: mysql-connector-java-3.0.16-ga-bin.jar

URL: String url = "JDBC: mysql: // 127.0.0.1: 3306/db_jsdq10 ";

V. Oracle Database Connection

Driver: String driverclass = "oracle. JDBC. Driver. oracledriver ";

Required package: classes12.jar

URL: String url = "JDBC: oracle: thin: @ FIG: 1521: mrsoft1";