This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Inserting nulls

 
Gayathri Neti
Greenhorn
Posts: 25
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hai Java Gurus,
The question may soud dumb but ...let me ask. I have a varchar column and in my program I have a string variable that take sdata from thr textbox in the gui and inserts it into database. My problem is if th evalue in text box is empty then it is entering empty string into database. I want it to enter nothing.....I canno tchange any database setting and database I am using is Sql server.
Thanks,
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Gayathri,
If you are using a "java.sql.PreparedStatement" to insert the data into your database, then you can use the "setNull()" method to set a column value to null -- assuming that you want to set the column to null if nothing has been entered into the "textbox".
I suggest you read the javadoc for the "setNull()" method.
Hope this helps.
Good Luck,
Avi.
 
Suresh Selvaraj
Ranch Hand
Posts: 104
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you are using PreparedStatement then you may try this.
PreparedStatement ps=null;
...
...
if(textString == null)
{
ps.setNull(1, java.sql.Types.VARCHAR);
}
else
{
ps.setString(1,textString);
}
Suresh Selvaraj
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic