链接数据库总结

odbc方法链接数据库

             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

             Connection conn = DriverManager.getConnection("JDBC:ODBC:MMC");//MMC是系统中odbc中的名

 

jdbc方法链接sql Server数据库

              Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

               Connection con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=shop","sa","123456");

            

              在SQL Server 2000 中加载驱动和URL路径的语句是

                               String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

                              String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=sample";

 

             sql server 2005 中加载驱动和url的语句则为

                              String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

                              String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=sample";

 

jdbc方法链接Oracle数据库      

              Class.forName( "oracle.jdbc.driver.OracleDriver" );

             Connection conn = DriverManager.getConnection( "jdbc:oracle:thin:@127.0.0.1:1521:ORCL", userName, password );

 

jdbc方法链接MySql数据库 

             Class.forName( "org.gjt.mm.mysql.Driver" );

             Connection conn= = DriverManager.getConnection( "jdbc:mysql://localhost/mydb?user=root&password=123456&useUnicode=true&characterEncoding=gb2312);

 

jdbc方法链接DB2数据库 

             Class.forName( "com.ibm.db2.jcc.DB2Driver" );

             Connection conn= = DriverManager.getConnection( "jdbc:db2://localhost:50000/pca:progressiveStreaming=2,db2admin,db2admin);

 

jdbc方法链接Derby数据库 

             Class.forName( "org.apache.derby.jdbc.EmbeddedDriver" );

             Connection conn= = DriverManager.getConnection( "jdbc:derby:f:/fri;certer = true");

 在spring.xml中配置链接数据库

在beans节点下添加如下代码

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName">
<value>oracle.jdbc.driver.OracleDriver</value>
</property>
<property name="url">
<value>jdbc:oracle:thin:@192.168.2.102:1521:orcl</value>
</property>
<property name="username">
<value>smydsource</value>
</property>
<property name="password">
<value>xkj19a</value>
</property>
</bean> 

      

如果是在spring配置文件中配置数据库连接池

<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName" value="java:comp/env/jdbc/OracleDS"/>
</bean>
对应的tomcat context.xml配置
<Resource type="javax.sql.DataSource" name="jdbc/OracleDS" 
url="jdbc:oracle:thin:@192.168.2.102:1521:orcl" 
driverClassName="oracle.jdbc.driver.OracleDriver" 
password="123456" username="name" maxWait="10000" maxIdle="30" maxActive="100" auth="Container"/>

数据库连接池更详细介绍