查看一个表中总共有多少条记录

最新推荐文章于 2022-01-05 19:00:00 发布

刘利新西安

最新推荐文章于 2022-01-05 19:00:00 发布

阅读量1.8k

点赞数

分类专栏： JDBC

本文链接：https://blog.csdn.net/weiyanghuadi/article/details/8936470

版权

JDBC 专栏收录该内容

46 篇文章 0 订阅

订阅专栏

CREATE TABLE liuyan_temp(
  id int(6) NOT NULL auto_increment,
  url varchar(100) default '#',
  ip varchar(20) default NULL,
  email varchar(50) default '#',
  qq varchar(20) default NULL,
  sj varchar(30) default NULL,
  content text,
  xm varchar(20) default '没有姓名',
  KEY id (id)
) default charset=utf8;

<%@ 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>西安Java培训西安小升初</title>
</head>
<body>
	<%
		String driver = "com.mysql.jdbc.Driver";
		Class.forName(driver).newInstance();
		Connection con = null;
		ResultSet rst = null;
		Statement stmt = null;
		try {
			String sql;
			int i = 0;
			String url = "jdbc:mysql://localhost/liu_yan_ban2?user=root&password=HuaDi5";
			con = DriverManager.getConnection(url);
			stmt = con.createStatement();
			sql = "select count(*) from liuyan_temp";
			rst = stmt.executeQuery(sql);
			while (rst.next())
				i = rst.getInt(1);
			out.println("总共有"+i+"条记录");
		} 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>