Saving Integer value into database

Question

How do I save an Integer type (not int) into Database?

Whats the issue? Autoboxing happens in Java so what different does it make? — Subir Kumar Sao
– Subir Kumar Sao, Commented Jun 12, 2012 at 7:28
Im new to database. Im using 'Integer' and 'Number' type. If I rmmber correctly, I'd have to specify the table column what is the type of data that it will hold, am I right? — Fadhlie Ikram
– Fadhlie Ikram, Commented Jun 12, 2012 at 7:39

beny23 · Accepted Answer · 2012-06-12 07:42:16Z

3

Using plain JDBC, I'd use the following:

 Integer myInteger = ...;
 PreparedStatement ps = ...;
 if (myInteger == null) {
     ps.setNull(1, Types.INTEGER);
 } else {
     ps.setInt(1, myInteger); // will be autounboxed
 }

answered Jun 12, 2012 at 7:42

beny23

35.1k6 gold badges84 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

plucury · Accepted Answer · 2012-06-12 07:28:47Z

0

I think just use Integer is OK.Or use intValue() to convert it.

answered Jun 12, 2012 at 7:28

plucury

1,1201 gold badge8 silver badges16 bronze badges

Comments

Philippe Marschall · Accepted Answer · 2012-06-12 07:37:23Z

0

http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setInt(int, int)

answered Jun 12, 2012 at 7:37

Philippe Marschall

4,6041 gold badge38 silver badges56 bronze badges

Comments

Gabriel Theron · Accepted Answer · 2012-06-12 07:45:33Z

-2

Depending on your database system (mysql, postgre, ...), the integer type will or won't exist in your database. It is then better to use java Integer functions to make an Integer from your database value, which will probably be int or even bigint, depending on what's needed.

As I said in my comment, something like Integer myinteger = new Integer(yourdatabasevalue) should work fine.

edited Jun 12, 2012 at 7:45

answered Jun 12, 2012 at 7:33

Gabriel Theron

1,3764 gold badges21 silver badges53 bronze badges

2 Comments

Fadhlie Ikram Over a year ago

Im using sqlite, as embedded database.

Gabriel Theron Over a year ago

I don't know sqlite very well, but from what I can see of the docs, it only has the integer type. Then you can store it as Integer in sqlite and make an Integer in java like Integer myinteger = new Integer(here you retrieve your value) (don't really do the request in there though ^^ this is just an example)

Collectives™ on Stack Overflow

Saving Integer value into database

4 Answers 4

Comments

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related