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 | 0 |
By: [email protected] On: Fri Nov 06 10:56:15 IST 2015 0 0 0 | 0 |
Are You Satisfied :0Yes0No |