How to add an auto increment column in java?

java mysql database jform
Ankush Tyagi picture Ankush Tyagi · Jul 9, 2015 · Viewed 15.3k times · Source

I want to add the database from my jform and there's a column which will be auto incremented, like when i click done, the data will be inserted and a column receipt_no will have a value 1. Next time I click done then this value should be 2 and so on.

So the problem is, i have created a table with receipt_no as the primary key and auto increment, so what should be my query in java, to add the data correctly in the table. 

String sql = "insert into table_name values('"++"',...)";

Can you help me in this query?

Answer

Vicky Thakor picture Vicky Thakor · Jul 9, 2015

Step 1: Creating table in MySQL

CREATE TABLE `user_master` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Firstname` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Step 2: Insert record

INSERT INTO user_master (`Firstname`) values('Vicky');

Step 3: Fetch record

SELECT * FROM user_master;

Related questions

How do I find out my MySQL URL, host, port and username?

I need to find my MySQL username. When I open the MySQL command line client, it only asks me for my password. I don't remember my username. And for connectivity with JDBC, I need the URL, host and port number. …

Read More
Query a MySQL db using java

Guys, simply put, I have a java application with a text output box. I'd like to query a Db and display the output into a text box. Example I have a Db with two columns food and color I'd like …

Read More
Simple Backup and Restore for mysql Database from Java

How to backup a mysql database from a java code such that: It's saving path is dynamically allocated. Spaces in Path do not create problems. Path is generated using the executing jar file. DBname,DBusername or DBpass are dynamically allotted. …

Read More