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","");
int id=1;
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select id from mydb");
while(rs.next()!=false)
{
id++;
}
ResultSetMetaData rsmd = rs.getMetaData();
id=rsmd.getColumnCount();
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());
}
}