test.jsp

一个真实项目的源代码。有一个比较优秀的时间类

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.io.*,java.sql.*,javax.sql.DataSource,javax.naming.InitialContext,java.util.Properties,java.util.Hashtable" %> 
<%@ page import="com.work.db.DbConnection" %>
<%
		Connection conn = null;
		Statement stmt = null;
		ResultSet rst = null;
		conn = DbConnection.getConn();
		try {
			stmt = conn.createStatement();
			rst = stmt.executeQuery("SELECT GETDATE() AS [date] ");
			while(rst.next()){
				System.out.println(rst.getString("date"));
				out.println("数据库测试jsp。 "+rst.getString(1));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				if (rst != null)
					rst.close();
			} catch (SQLException e) {
			}
			try {
				if (stmt != null)
					stmt.close();
			} catch (SQLException e) {
			}

			try {
				if (conn != null)
					conn.close();
			} catch (SQLException e) {
			}
		}
%>