How can I get the total row count in a mysql table.

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());
		}
	}