spring中配置dataSource的写法（jdbc和jndi）

一、spring中配置dataSource的写法（JNDI）

<bean id="dataSource">
 <property name="jndiName">
   <value>java:comp/env/jdbc/jndName</value>
 </property>
</bean>

 

二、spring中配置dataSource的写法（JDBC）

<bean id="dataSource">
 <property name="driverClassName"><value>com.mysql.jdbc.Driver</value></property>
 <property name="url"><value>jdbc:mysql://localhost:3306/databaseName</value></property>
 <property name="username"><value>crazyiter</value></property>
 <property name="password"><value>crazyiter</value></property>
</bean>

 

这两个可能在笔试的时候叫你写出来。

 

三、数据库连接过程（JDBC）

 

package com.crazyiter.app;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class JDBCTest1 {

	public static final String DRIVER = "oracle.jdbc.driver.OracleDriver";
	public static final String URL = "jdbc:oracle:thin:@localhost:1521:XE";
	public static final String USERNAME = "crazyiter";
	public static final String PASSWORD = "crazyiter";

	public static void main(String[] args) throws Exception {
		Connection conn = null;
		Class.forName(DRIVER);
		conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
		Statement sta = null;
		sta = conn.createStatement();

		String sql = "select x,info from test order by x asc";
		ResultSet rs = sta.executeQuery(sql);
		while (rs.next()) {
			System.out.println(rs.getInt("x") + "-" + rs.getString("info"));
		}

		rs.close();
		sta.close();
		conn.close();
	}

}