JDBC Select Max Example


 

JDBC Select Max Example

In this tutorial we will learn how use MAX ()  in query with mysql JDBC driver.

In this tutorial we will learn how use MAX ()  in query with mysql JDBC driver.

JDBC Select Max Example

In this tutorial we will learn how use  MAX ()  in query with mysql JDBC driver. This  tutorial  use the MAX  mysql  function that fetch the maximum value of column values   that  pass in Max function  i.e  "SELECT MAX(user_id) FROM user" . Table user as:

 

    Mysql query "SELECT MAX(user_id) FROM user"  fetch the  maximum user_id  is 5 and if insert another row data  in table user then increase user_id  so  query  fetch  result   maximum  user_id  6. This type  query use if need max salary , max user_id etc. The code  of  "SelectMax.java" as:

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;
import java.sql.ResultSet;
  
public class SelectMax{
 // JDBC driver name and database URL
 static String driverName = "com.mysql.jdbc.Driver";
 static String url = "jdbc:mysql://localhost:3306/";

 // defined and set value in  dbName, userName and password variables
 static String dbName = "testjdbc";
 static String userName = "root";
 static String password = "";
	
 public static void main(String[] args){
	// create Connection con, and Statement stmt 
	Connection con=null;
	Statement stmt=null;
	try{
		Class.forName(driverName).newInstance();
		con = DriverManager.getConnection(url+dbName, userName, password);
		try{
			stmt = con.createStatement();
			String query = "SELECT MAX(user_id) FROM user";
			ResultSet rs=stmt.executeQuery(query);			
			//Extact result from ResultSet rs
			while(rs.next()){
			    System.out.println("MAX(user_id)="+rs.getInt("MAX(user_id)"));				
			  }
			// close ResultSet rs
			rs.close();
		   } catch(SQLException s){						
				s.printStackTrace();
			 }
		// close Connection and Statement
		con.close();
		stmt.close();
		}catch (Exception e){
			e.printStackTrace();
		 }
  }
}

Program Output  :

F:\jdbc>javac SelectMax.java

F:\jdbc>java SelectMax
MAX(user_id)=5

F:\jdbc>

Download Code

Ads