Shulou(Shulou.com)05/31 Report--

This article mainly explains "what are the link strings commonly used in JDBC database connections". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "what are the link strings commonly used in JDBC database connections?"

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 of the database

String user= "test"

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)

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)

At this point, I believe that everyone on the "JDBC database commonly used to connect which link strings" have a deeper understanding, might as well to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.