select maximum from table and hoe to store it in any variable

Home Answers Viewqa JDBC select maximum from table and hoe to store it in any variable

shiv vaishnav

select maximum from table and hoe to store it in any variable
2 Answer(s) a year and 10 months ago
Posted in : JDBC

public class signup extends HttpServlet {

/** 
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
@Override

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); String u=request.getParameter("user"); String p=request.getParameter("password"); String c=request.getParameter("city"); String m=request.getParameter("mobile"); String s=request.getParameter("salary");

    try{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection cn=DriverManager.getConnection("jdbc:odbc:student");
    Statement st=cn.createStatement();
            ResultSet i=st.executeQuery("select MAX(sn) from detail");
            int x=i.getInt(1);
            x=x+1;
            st.executeUpdate("insert into detail values(3,'"+u+"','"+p+"','"+c+"','"+m+"','"+s+"')");
    ResultSet rs=st.executeQuery("select * from detail");    //" & ' me space ni dena h
    while(rs.next()){

            out.println("login success"+"<br>");
                        out.println("ur details are:<br>");

                        out.println("user name : "+rs.getString(2)+"<br>");
                        out.println("city : "+rs.getString(4)+"<br>");
                        out.println("mobile : "+rs.getString(5)+"<br>");
                        out.println("salary : "+rs.getString(6)+"<br>");
            }

    cn.close();
}
catch(ClassNotFoundException e){
    out.print("class not found");
    }
catch(SQLException e){
    out.print("sql error");
    }
         }

}

i want to select max(sn) from table then insert into table as(max+1,user,password,city,mobile,salary).. help me pls

View Answers

July 13, 2011 at 2:52 PM

Try this:

public class signup extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    response.setContentType("text/html;charset=UTF-8");
    PrintWriter out = response.getWriter();
    String u=request.getParameter("user"); 
    String p=request.getParameter("password"); 
    String c=request.getParameter("city");
    String m=request.getParameter("mobile");
    String s=request.getParameter("salary");

    try{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection cn=DriverManager.getConnection("jdbc:odbc:student");
    Statement st=cn.createStatement();
            ResultSet rs=st.executeQuery("select MAX(sn) from detail");
            int x=0;
            while(rs.next()){
             x=rs.getInt(1);
            }
            int y=x+1;
            st.executeUpdate("insert into detail values("+y+",'"+u+"','"+p+"','"+c+"','"+m+"','"+s+"')");
            ResultSet rst=st.executeQuery("select * from detail");    
            if(rst.last()){
            out.println("login success"+"<br>");
                        out.println("ur details are:<br>");
                        out.println("user name : "+rst.getString(2)+"<br>");
                        out.println("city : "+rst.getString(4)+"<br>");
                        out.println("mobile : "+rst.getString(5)+"<br>");
                        out.println("salary : "+rst.getString(6)+"<br>");
            }

     cn.close();
    }
    catch(ClassNotFoundException e){
    out.print("class not found");
    }
    catch(SQLException e){
    out.print("sql error");
    }
         }

}

July 13, 2011 at 2:52 PM

Try this:

public class signup extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    response.setContentType("text/html;charset=UTF-8");
    PrintWriter out = response.getWriter();
    String u=request.getParameter("user"); 
    String p=request.getParameter("password"); 
    String c=request.getParameter("city");
    String m=request.getParameter("mobile");
    String s=request.getParameter("salary");

    try{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection cn=DriverManager.getConnection("jdbc:odbc:student");
    Statement st=cn.createStatement();
            ResultSet rs=st.executeQuery("select MAX(sn) from detail");
            int x=0;
            while(rs.next()){
             x=rs.getInt(1);
            }
            int y=x+1;
            st.executeUpdate("insert into detail values("+y+",'"+u+"','"+p+"','"+c+"','"+m+"','"+s+"')");
            ResultSet rst=st.executeQuery("select * from detail");    
            if(rst.last()){
            out.println("login success"+"<br>");
                        out.println("ur details are:<br>");
                        out.println("user name : "+rst.getString(2)+"<br>");
                        out.println("city : "+rst.getString(4)+"<br>");
                        out.println("mobile : "+rst.getString(5)+"<br>");
                        out.println("salary : "+rst.getString(6)+"<br>");
            }

     cn.close();
    }
    catch(ClassNotFoundException e){
    out.print("class not found");
    }
    catch(SQLException e){
    out.print("sql error");
    }
         }

}

select maximum from table and hoe to store it in any variable
select maximum from table and hoe to store it in any variable public..."); } } } i want to select max(sn) from table then insert into table...+"','"+s+"')"); ResultSet rs=st.executeQuery("select * from detail"); //" &

store data from a variable in mysql?
store data from a variable in mysql? sir last time asked you tell me how to retrieve data from a database mysql and store it in an int variable... of the calculation from an int variable into mysql in a new table of database. how

Table maximum Row count - JDBC
Table maximum Row count Dear friends I want to select maximum time entry Status from db. for example : Status : 3 4 6 8 3 5 7 5..., Sql Query for select maximum value max() function use. "select max

retrieve data from mysql database and store it in a variable ?
retrieve data from mysql database and store it in a variable ? sir... to store that data in int variable. how to do this ? Here is an example...=conn.createStatement(); ResultSet rs=st.executeQuery("select * from numbers

select maximum time entry row - JDBC
select maximum time entry row Hi fried you given ans this Sql Query for select maximum value max() function use. "select max(fieldname... is maximum time entry in column Status please if you have any other query

Hoe to refresh a table row dynamically
Hoe to refresh a table row dynamically Want to refresh a table data... Friend, Is there a link attribute with every row of a table through which we will able to refresh a particular table row? Please clarify this. Thanks

MySQL Select Statement
clause. The SELECT statement is used to retrieve the records from the table... of Emp table. mysql> SELECT * FROM Emp; If you want... fields from the Emp table. mysql> SELECT Name, City, Age from EMP

store value in checkbox from gridview
store value in checkbox from gridview Please check the error... = con.createStatement(); rst=st.executeQuery("select * from books...; <table bgcolor="pink" border="1" cellspacing="0" cellpadding="0">

store pagination form fields - Struts
store pagination form fields hi,iam working online exams project... table. here iam using pagination for questions to be displayed to client. starting from first he asnwers and after ending the test he submits to action. i need

Select from select list + display
Select from select list + display i have a select list containing... select EmpCode from the select list, the corresponding EmpName and DeptName should...=con.createStatement(); ResultSet rs=st.executeQuery("select * from emp

Select data from Table in Database
Select data from Table in Database ... the selected data from table in database. The select query in the database retrieve...; in simple select statement is given below select column name from table

Using Select Statements in JDBC
; The SELECT statement is used to select data from a table. For terminating a statement, semicolon is used. When we want to fetch the data from any table... to retrieve the data from any table with the JDBC. Employee is the name of a table

Jsp-delete checked checkboxes and display UNCHECKED checkboxes in table as well as in store that unchecked checkboxes in ARRAYLIST
as in store that unchecked checkboxes in ARRAYLIST I have a table... are to be deleted from the table after clicking the DELETE button. If this is your... values from the table. Use form tag and checkbox input. In in each checkbox

SQL Select From
SQL Select From SQL Select From keyword show you the records from a specified table. Understand... keyword in SQL is used to show the records from table 'Stu'. select

select query using hibernate
select query using hibernate Hi, can any one tell me to select records from table using hibernate. Thanks Please visit the following link: Hibernate Tutorials The above link will provide you different

store html value in the sqllite 3 php
tell db to store html content from $articles $result = $db->query('SELECT bar...store html value in the sqllite 3 php i have a php script that will parse html page content link and view but i need to know how to store

JDBC Select Statement Example
= con.createStatement(); // creating Query String String query = "SELECT * FROM... .style1 { text-align: center; } JDBC Select Statement Example Select Statement retieves the data from single or multiple tables from a database

Store Variable in Java
Store Variable in Java How to store Variables in Java? public class DoubleTest { public static void main(String[] args) { double...(aDouble); // Outputs 7.21 } } Variable in Java

Assigning variable in mysql - SQL
on salesdetails for each row set @d=(select productCode from serialTable where serialNumber...Assigning variable in mysql i have tables purchase, serialtable... to update my purchase.quantityInstock column by selecting a productcode from

where clause in select statement
where clause in select statement In Mysql,I write the following query: select * from emp where designation = "MANAGER" But the actual value in the table is "manager" Will the above query retrieve any records? According to me

select option value
select option value if i select a value of any drop down then that value should be used in a select query of the next dropdown in jsp???? ...("Select * from country"); while(rs.next()){ %> <option value

select option value
select option value if i select a value of any drop down... = stmt.executeQuery("Select * from country"); while(rs.next()){ %> <... = stmt.executeQuery("Select * from state where countryid='"+country+"' "); while(rs.next

How to find maximum value in ArrayList
How to find maximum value in ArrayList **Sir i am writing below code... requirement is find maximum value in userdefined objects and dispaly that object values only.This object store in another collection object(list,set) MY sample code

select query
select query how to retrieve a single image from mysql table using $row[] value

Table Maintenance Statements
] ... This syntax is used to analyze and store the key distribution to a table. During... other than a constant. For using ANALYZE TABLE syntax you must have the SELECT... checks each table for determining whether there have been any incompatible

JDBC Select All Records Example
records from the table use mysql JDBC driver. This tutorial example for select all records from table if exist and defined how the records fetch and store. This example applied mysql query "SELECT * FROM user"

select query
select query how to write select query with where clause having multiple variables. example: i want to select the data from DB in which i want to check againest two variable in where cluase. String sql = "select * from

Select data from diplicated data
Select data from diplicated data hello i have table location...++) { $SQL = "SELECT duration FROM core_network WHERE location=('".$location_c[$k... = mysql_select_db($database, $db_handle); if ($db_found) { $SQL = "SELECT

Column select
or no. Then using the query select * from resumes where experience='yes', fetch all the data...("jdbc:mysql://localhost:3306/test", "root", "root"); String query = "select * from... years of experience does candidate have. Then using the query Select * from

Use of Select Box to show the data from database
select any other item from select box then it will reflect to the text box as well... Use of Select Box to show the data from database ... from database This example will describe you the use of Select Box in a JSP

What?s the maximum size of a row in SQL table?
What?s the maximum size of a row in SQL table? What?s the maximum size of a row in SQL table? Hi, The maximum Row Size is 8060 Bytes in a sql table. Thanks

Maximum Solutions - Specialists in Object Orientation
This material from The Java(tm) Specialists' Newsletter by Maximum... If we look at the table below, we see that for JDK 1.4.x, SB3... Singleton3() {} } The table below contains the relative

Using Unicode Variable Names - Java Tutorials
members are currently subscribed from 56 countries Using Unicode Variable... This material from The Java(tm) Specialists' Newsletter by Maximum...Using Unicode Variable Names 2001-11-23 The Java Specialists' Newsletter

data type used to store name.(getting an error)
data type used to store name.(getting an error) Statement stm=con.createStatement(); String query="select * from employee where ename... getting an error like dis: "ename cannot be resolved to a variable" whats

Mysql PHP Select
in table: mysql> select * from mytable; +-------+---------+--------+ | Empid.... Understand with Example The Tutorial illustrate an example from 'Mysql PHP Select... php select: To view the table data using php, you need to connect

How to find maximum value for userdefined objects in ArrayList
How to find maximum value for userdefined objects in ArrayList Hi sir,I have requirement i.e finding maximum value in userdefined objects and display that object only and store another collecton object.For example i taken

read from file and store using hash map
read from file and store using hash map I was stuck with a java project where I have to read a file with two different concepts and store them... different maps. Any help will be appreciated. Thanks in advance

I want to store the value of local variable into Global variable
I want to store the value of local variable into Global variable <%=cnt%>=x; is it a valid Statement

Mysql Date Max
; Mysql Date return you the maximum rows or records value from a table. Understand...) Query for finding maximum date from the table:- The below Syntax return the maximum value of date field name 'date' as Max Date from table employee1

send multiple textbox vaues in to an jsp form to store them in a DB table
values in to an jsp file with additional values to store those values in to an database table. Please help me...... looking forward to hear from you...send multiple textbox vaues in to an jsp form to store them in a DB table

Mysql Min Max
; Mysql Min Max is useful to find the minimum and maximum records from a table... the records from table 'employee'. mysql> select... from the table employee. mysql> select min(salary)as MinSalary

how to store and retrieve image from database
how to store and retrieve image from database how to store and retrieve images into database(oracle) and how to retrive images from database using...(); ResultSet rs=st.executeQuery("select images from image"); if(rs.last()){ byte

Hibernate Select Clause
from Insurance table using Hibernate Select Clause. The select clause picks up..., insurance.investementDate) from Insurance table. Hibernate generates the necessary sql query and selects all the records from Insurance table. Here

Select string from array in objective c
Select string from array in objective c Hi, I wanted to select a string from the database table in objective c. But somehow it is not working..can...:@"SELECT ic, district, age, race, referralSource, DMRelatedAdmin, postalCode FROM

Android mobile store
Android mobile store Hi, How to create Android mobile store application? Is there any free code that can be used for creating the applications? I want to distribute my application from my website. I don't what to distribute

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics