如何获取mysql表中的总行数。 [英] How can I get the total row count in a mysql table.

问题描述

如何获取表格的总行数。我正在尝试ResultSetMetaData的方法，但它只有getColumnCount（）。有没有其他方法可以获得总行数。

我正在尝试使用代码，

How can I get the total row count of the table. I'm trying methods of ResultSetMetaData, but it only have getColumnCount(). Is there any other way of getting total count of rows.
I'm trying following code,

public void Save()
	{
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			Connection con = DriverManager.getConnection("jdbc:mysql://localhost/shri","root","");
			
			//Getting next ID

			int id=1;
			Statement st = con.createStatement();
			ResultSet rs = st.executeQuery("select id from mydb");
while(rs.next()!=false)
			{
				id++;
			} // I tried this another method but doesn't worked

			ResultSetMetaData rsmd = rs.getMetaData();
			id=rsmd.getColumnCount(); // Here it is

			//Saving Data
			PreparedStatement ps = con.prepareStatement("Insert into mydb(id,fname,mname,lname,nickname,email)values(?,?,?,?,?,?)");
			ps.setInt(1,id);
			ps.setString(2,txtFirstName.getText());
			ps.setString(3,txtMiddleName.getText());
			ps.setString(4,txtLastName.getText());
			ps.setString(5,txtNickname.getText());
			ps.setString(6,txtEmail.getText());
			ps.execute();		
			lblStatus.setText("Saved.......");
			clear();
		}
		catch(Exception e)
		{
			System.out.println (e);
			lblStatus.setText(e.toString());
		}
	}

推荐答案

检查下面类似的问题和答案：

如何获得java的大小。 sql.ResultSet？ [ ^ ]

如何使用Java中的ResultSet获取行计数？ [ ^ ]

check below similar questions and the answers:
How do I get the size of a java.sql.ResultSet?[^]
How to get row count using ResultSet in Java?[^]

mysql_insert_id（）



http://dev.mysql.com/ doc / refman / 5.7 / en / mysql-insert-id.html [ ^ ]

mysql_insert_id()

http://dev.mysql.com/doc/refman/5.7/en/mysql-insert-id.html[^]

参考：最后插入的id mysql [ ^ ]

这篇关于如何获取mysql表中的总行数。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！