Shulou(Shulou.com)06/02 Report--

Today, I will talk to you about the various writing methods of JDBC connection database in J2EE technology, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

The following is how to write JDBC to connect to various databases, dedicated to Java beginners, give some suggestions, remember to import the corresponding driver jar package.

1. Oracle8/8i/9i database (thin mode)

Class.forName ("oracle.jdbc.driver.OracleDriver") .newInstance (); String url= "jdbc:oracle:thin:@localhost:1521:orcl"; / / orcl is the SID String user= "test" of the database; String password= "test"; Connection conn= DriverManager.getConnection (url,user,password)

2. DB2 database

Class.forName ("com.ibm.db2.jdbc.app.DB2Driver"). NewInstance (); String url= "jdbc:db2://localhost:5000/sample"; / / sample is your database name String user= "admin"; String password= ""; Connection conn= DriverManager.getConnection (url,user,password)

3. Sql Server7.0/2000 database

Class.forName ("com.microsoft.jdbc.sqlserver.SQLServerDriver") .newInstance (); String url= "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb"; / / mydb is the database String user= "sa"; String password= ""; Connection conn= DriverManager.getConnection (url,user,password)

4. Sybase database

Class.forName ("com.sybase.jdbc.SybDriver"). NewInstance (); String url = "jdbc:sybase:Tds:localhost:5007/myDB"; / / myDB is your database name Properties sysProps = System.getProperties (); SysProps.put ("user", "userid"); SysProps.put ("password", "user_password"); Connection conn= DriverManager.getConnection (url, SysProps)

5. Informix database

Class.forName ("com.informix.jdbc.IfxDriver") .newInstance (); String url = "jdbc:informix-sqli://123.45.67.89:1533/myDB:INFORMIXSERVER=myserver; user=testuser;password=testpassword"; / / myDB is the database name Connection conn= DriverManager.getConnection (url)

6. MySQL database

Class.forName ("org.gjt.mm.mysql.Driver") .newInstance (); String url = "jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1" / / myDB is the database name Connection conn= DriverManager.getConnection (url)

Or

Class.forName ("com.mysql.jdbc.Driver"); String url= "jdbc:mysql://localhost/myDB? ser=root&password=system"; conn = DriverManager.getConnection (url)

7. PostgreSQL database

Class.forName ("org.postgresql.Driver") .newInstance (); String url = "jdbc:postgresql://localhost/myDB" / / myDB is the database name String user= "myuser"; String password= "mypassword"; Connection conn= DriverManager.getConnection (url,user,password)

Supplement: Sql Server2005 database

Class.forName ("com.microsoft.jdbc.sqlserver.SQLServerDriver") .newInstance (); String url= "jdbc:sqlserver://localhost:1433;DatabaseName=mydb"; / / mydb is the database String user= "sa"; String password= ""; Connection conn= DriverManager.getConnection (url,user,password)

It is a little different from the connection url of sql2000. These are the basic ways for JDBC to connect to the database.

After reading the above, do you have any further understanding of the various ways of writing JDBC connection database in J2EE technology? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.