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中配置链接数据库
<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>
<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"/>