时间字段的读取

来源：互联网发布：circrna数据库编辑：程序博客网时间：2024/04/30 08:41

CREATE TABLE test (`id` INT (3) UNSIGNED AUTO_INCREMENT, `date1` TIMESTAMP , PRIMARY KEY(`id`));

<%@ page language="java" contentType="text/html; charset=utf-8"pageEncoding="utf-8"%><%@ page language="java" import="java.sql.*"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>Insert title here</title></head><body><%String driver = "com.mysql.jdbc.Driver";Class.forName(driver).newInstance();Connection con = null;ResultSet rst = null;Statement stmt = null;try {String url = "jdbc:mysql://localhost/tutorial?user=root&password=HuaDi5";con = DriverManager.getConnection(url);stmt = con.createStatement();stmt.executeUpdate("INSERT INTO test SET id = 1");rst=stmt.executeQuery("select * from test");rst.next();out.println(rst.getDate("date1"));} catch (Exception e) {out.print("<h3>数据库系统出错</h3>");System.out.println(e.getMessage());} finally {if (rst != null)try {rst.close();} catch (Exception e) {}if (stmt != null)try {stmt.close();} catch (Exception e) {}if (con != null)try {con.close();} catch (Exception e) {}}%></body></html>