import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class my_update{
private String str_return;	
String my_db_update(String str1, String str2,String str3,String str4) {
		try{  
	Class.forName("com.mysql.jdbc.Driver");  
	Connection con=DriverManager.getConnection(  
	"jdbc:mysql://localhost:3306/my_tutorial","root","password");  
	Statement st=con.createStatement();  
	int mark = Integer.parseInt(str3); // Mark is an integer
	// Adding record 
	String query1="INSERT INTO `my_tutorial`.`student`"
	 + " (`name`, `class`, `mark`, `sex`)"
	 + "VALUES('" +str1+"','"+str2+"',"+mark+",'"+str4+"')";
	st.executeUpdate(query1); // record added. 
	
	ResultSet rs=null;
	rs=st.getGeneratedKeys();
	rs.next();
	int new_id=rs.getInt(1); // id of the inserted record
	// Collect the record using the new_id
	rs=st.executeQuery("SELECT * from STUDENT where id="+new_id);
	rs.next();
	str_return="ID:" + rs.getInt(1) + ", Name :" + rs.getString("name");
	con.close();  
	
	}catch(Exception e){ System.out.println(e);} 
	//////////////////////////////
	return str_return;	
}
}