一、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();
}
}