Hi,
U can insert null values........
public ExPK insert(ExTB rcd) {
Connection con=null;
PreparedStatement ps=null;
String strQry=null;
try {
con = getConnection();
strQry = "INSERT INTO SEA_FILE (USERNAME,PASSWROD,MAILID,USERID..... "+
" VALUES (?, ?, ?,?.... )";
ps = dbConnection.prepareStatement(strQry);
ps.setString(1, rcd.getUserName());
ps.setString(2, rcd.getPassword());
if(rcd.getEmailId()==null){
// MAILID IS VARCHAR TYPE IN USER TABLE
// SET NULL VALUE FOR MAILID
ps.setNull(3, java.sql.Types.VARCHAR);
}else{
ps.setString(3,rcd.getEmailId());
}
if ( rcd.getUserId()!=0 ){
//USERID IS INTEGER TYPE IN USER TABLE
// SET NULL(0) VALUE FOR USERID
ps.setNull(4, java.sql.Types.INTEGER);
}else{
ps.setInt(4, rcd.getUserId());
}
}//EOF INSERT
If I'm wrong .. Correct me