Javatpoint Logo

How to create auto increment numbers code in jsp

By: go4nik*** On: Fri Nov 06 00:00:49 IST 2015     Question Reputation0 Answer Reputation0 Quiz Belt Series Points0  0Blank User
How to create auto increment numbers code in jsp??
want to create a account num for a bank project in colg.!
it should be automatically generated or incremented. CODE PLEASE
Up0Down

 
Hi,

This is the code to auto increment the the account number..


<%@page import="java.sql.*"%>
<%
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
Statement st = conn.createStatement();
ResultSet rs=st.executeQuery("SELECT id FROM bank");
int id=0;
if(rs.last()){
id=rs.getInt("accnum")+1;
}
st.executeUpdate("insert into user(accnum,name,address) values("+id+",'rose','delhi')");
out.println("Data is inserted successfully");
}
catch(Exception e){}
%>




-----------------------------------


Regards

Kamala Arumugakani
Image Created0Down

By: [email protected] On: Fri Nov 06 10:56:15 IST 2015 Question Reputation0 Answer Reputation0 Belt Series Points0 0User Image
Are You Satisfied :0Yes0No