时间字段的读取

最新推荐文章于 2024-05-26 10:09:31 发布

刘利新西安

最新推荐文章于 2024-05-26 10:09:31 发布

阅读量614

点赞数

CC 4.0 BY-SA版权

分类专栏： JDBC

本文链接：https://blog.youkuaiyun.com/weiyanghuadi/article/details/8893259

JDBC 专栏收录该内容

46 篇文章

订阅专栏

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>