**nb**/for insert Image,date and timestamp must be use prepared statement not other way
Date bookingDate = DateFormate.getFormattedDate(insetStartTimeFullcalendar, "dd/MM/yyyy");
Date startTime = DateFormate.getFormattedDate(soneDateTime, "dd/MM/yyyy HH:mm");
Date endTime = DateFormate.getFormattedDate(stwoDateTime, "dd/MM/yyyy HH:mm");
pStmt.setDate(4, new java.sql.Date(bookingDate.getTime()));
pStmt.setTimestamp(5, new java.sql.Timestamp(startTime.getTime()));
pStmt.setTimestamp(6, new java.sql.Timestamp(endTime.getTime()));
java Mysql image insert 2 way :
1.Direct form submit
2.Form submit by jquery
N.B: Database img coloumn data type is blob support for oracle
But
if Database img coloumn data type is blob use for mySql then show error
here : img coloumn data type is longblob
1.Direct form submit :
jsp page :
<form id="myForm" action="insertMeetingRoomCloseRI.do" class="form-horizontal" method="post" enctype="multipart/form-data">
<div class="modal-body">
<!-- START PAGE CONTENT-->
<!-- BEGIN EXAMPLE TABLE widget-->
<div class="widget red">
<div class="widget-title">
<!--h4><i class="icon-reorder"></i> Data Table</h4-->
<!--span class="tools">
<a href="javascript:;" class="icon-chevron-down"></a>
<a href="javascript:;" class="icon-remove"></a>
</span-->
</div>
<div class="widget-body">
<div>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="31%" style="text-align:right;font-family:Arial;font-size:12px;font-weight:bold;color:#000;">Search : </td>
<td width="17%"><input type="text" class="form-control" id="usr"></td>
<td width="7%"> <button type="submit" class="btn ">SEARCH</button></td>
<td width="45%"> </td>
</tr>
</table>
</div>
<div style="padding-top:5px;">
<table width="100%" class="" id="">
<tr>
<td style="text-align:right;">Room Type :</td>
<td>
<select id="roomtypeAddmroom" name="roomtypeAddmroom" class="span3 " tabindex="1" data-placeholder="Choose a Category" onchange="roomTypesPARENTIDneed(this);">
<option value="">Select</option>
<s:iterator value="roomTypeList" status="rowstatus">
<option value="<s:property value='lookup_id'/>"><s:property value='dtl_name'/></option>
</s:iterator>
</select> </td>
<td> </td>
<td style="text-align:right;"> </td>
</tr>
<tr>
<td width="35%" style="text-align:right;">UD Room Id :</td>
<td width="20%" style="text-align:left;"><input id="udefineAddmroom" name="udefineAddmroom" type="text" class="form-control" ></td>
<td width="9%" style="text-align:center;"> </td>
<td width="36%" style="text-align:right;"> </td>
</tr>
<tr >
<td style="text-align:right;">Room Name : </td>
<td><input id="rnameAddmroom" name="rnameAddmroom" type="text" class="form-control" ></td>
<td> </td>
<td style="text-align:right;"> </td>
</tr>
<tr >
<td style="text-align:right;">Parent Id :</td>
<td id="roomTypesPARENTIDneed_div">
<select id="parentidAddmroom" name="parentidAddmroom" class="span3 " tabindex="1" data-placeholder="Choose a Category">
<option value="">Select</option>
</select> </td>
<td> </td>
<td style="text-align:right;"> </td>
</tr>
<tr>
<td style="text-align:right;">Size :</td>
<td><input id="sizeAddmroom" name="sizeAddmroom" type="text" class="form-control" ></td>
<td> </td>
<td> </td>
</tr>
<tr >
<td style="text-align:right;">Capacity : </td>
<td><input id="capacityAddmroom" name="capacityAddmroom" type="text" class="form-control" ></td>
<td> </td>
<td> </td>
</tr>
<tr >
<td style="text-align:right;">Device : </td>
<td><input id="deviceAddmroom" name="deviceAddmroom" type="text" class="form-control" ></td>
<td> </td>
<td> </td>
</tr>
<tr >
<td style="text-align:right;">Room Image </td>
<td colspan="3">
<input id="userImage" name="userImage" class="" type="file" > </td>
</tr>
<tr >
<td style="text-align:right;">Colour :</td>
<td><input id="colorAddmroom" name="colorAddmroom" type="text" class="form-control"></td>
<td> </td>
<td> </td>
</tr>
<tr >
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</div>
<!--a href="#" onclick="appCanPOPFunction();">second POPUP</i></a-->
</div>
</div>
<!-- END EXAMPLE TABLE widget-->
<!-- END PAGE CONTENT-->
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
<!-- <button type="submit" class="btn btn-primary" >Save changes</button> -->
<button type="submit" class="btn btn-primary">Save changes</button>
</div>
</form>
Struts configure :
<action name="*RI" class="action.MeetingRoomAction" method="{1}">
<interceptor-ref name="fileUpload">
<param name="maximumSize">2097152</param>
<param name="allowedTypes">
image/png,image/gif,image/jpeg,image/pjpeg
</param>
<param name="contentType">text/html</param>
</interceptor-ref>
<interceptor-ref name="defaultStack"></interceptor-ref>
<result name="insertMeetingRoomClose">ManageOrSetupPage/meetingRoom.jsp</result>
</action>
MeetingRoomAction.java :
public class MeetingRoomAction extends ActionSupport implements ServletRequestAware{
public String insertMeetingRoomClose(){
MeetingRoomSQL meetingRoomSQL = new MeetingRoomSQL();
System.out.println("Meeting Room info and image save");
try {
String filePath = servletRequest.getRealPath("/");
System.out.println("Server path:" + filePath);
File fileToCreate = new File(filePath, this.userImageFileName);
FileUtils.copyFile(this.userImage, fileToCreate);
filePath += userImageFileName;
File image = new File(filePath);
System.out.println(image);
FileInputStream fis = new FileInputStream(image);
meetingRoomSQL.insertMeetingRoomCloseData(udefineAddmroom,rnameAddmroom,parentidAddmroom,roomtypeAddmroom,sizeAddmroom,capacityAddmroom,deviceAddmroom,image,fis);
// meetingRoomSQL.insertMeetingRoomCloseData(udefineAddmroom,rnameAddmroom,parentidAddmroom,roomtypeAddmroom,sizeAddmroom,capacityAddmroom,deviceAddmroom,null,null);
} catch (Exception e) { //catch (IOException e)
e.printStackTrace();
}
meetingRoomList = meetingRoomSQL.selectMeetingRoomData();
return "insertMeetingRoomClose";
}
image code from above:
/*
System.out.println("Server path:" + filePath);
File fileToCreate = new File(filePath, this.userImageFileName);
FileUtils.copyFile(this.userImage, fileToCreate);
filePath += userImageFileName;
File image = new File(filePath);
System.out.println(image);
FileInputStream fis = new FileInputStream(image);
*/
//variable part
private File userImage;
private String userImageContentType;
private String userImageFileName;
private HttpServletRequest servletRequest;
//set get part
public File getUserImage() {
return userImage;
}
public void setUserImage(File userImage) {
this.userImage = userImage;
}
public String getUserImageContentType() {
return userImageContentType;
}
public void setUserImageContentType(String userImageContentType) {
this.userImageContentType = userImageContentType;
}
public String getUserImageFileName() {
return userImageFileName;
}
public void setUserImageFileName(String userImageFileName) {
this.userImageFileName = userImageFileName;
}
@Override
public void setServletRequest(HttpServletRequest servletRequest) {
this.servletRequest = servletRequest;
}
}
MeetingRoomSQL.java :
//FROM KYAMC image insert Prepared Statement
//*********************** Start user registration
// public void insertMeetingRoomCloseData(String udefineAddmroom,String rnameAddmroom,String parentidAddmroom,String roomtypeAddmroom,String sizeAddmroom,String capacityAddmroom,String deviceAddmroom,File image,FileInputStream fis){
public void insertMeetingRoomCloseData(String udefineAddmroom,String rnameAddmroom,String parentidAddmroom,String roomtypeAddmroom,String sizeAddmroom,String capacityAddmroom,String deviceAddmroom,File image,FileInputStream fis){
int userid = (Integer) ActionContext.getContext().getSession().get("userId");
int orgid = (Integer)ActionContext.getContext().getSession().get("orgid");
//String collegeid;
System.out.println("kaniz");
boolean fg = true;
con = dbc.connectDB();
if (con == null) {
fg = false;
}
if (fg) {
try {
/* String sql="call PRC_BUILD_PK(?, ?,?,?,?,?)";
cs = con.prepareCall(sql);
cs.setString(1, "USER");
cs.setString(2, "SEQ_COLLEGEINFO_ID");
cs.setString(3, "P");
cs.setString(4, "1");
cs.registerOutParameter(5, java.sql.Types.VARCHAR);
cs.setString(6, "Y");
cs.execute();
collegeid = cs.getString(5);
System.out.println(collegeid);*/
st = con.createStatement();
//String fullName = firstName + lastName; // It is call concatenation
//System.out.println(fullName);
Date today = new Date();
// query = "insert into kyamc_user_type(ID,USER_FULL_NAME,USER_ID,USER_EMAIL,GROUP_ID,USER_PASS,USER_MOBILE,GENDER,ENTRY_TIMESTAMP,COLLEGE_NO ) values (SEQ_COLLEGEINFO_ID.nextval,'"+fullName+"','"+userName+"','"+userEmail+"','"+roleIdA+"','"+userPassword+"','"+mobNumber+"','"+gender +"',sysdate,'1')";
// System.out.println("Query" + query);
query = "insert into rbs_room(ud_room_id,room_name,parent_id,room_type,size,capacity,device,room_image,entered_by,entry_timestamp) values (?,?,?,?,?,?,?,?,?,?)";
pre = con.prepareStatement(query);
pre.setString(1, udefineAddmroom);
pre.setString(2, rnameAddmroom);
pre.setString(3, parentidAddmroom);
pre.setString(4, roomtypeAddmroom);
pre.setString(5, sizeAddmroom);
pre.setString(6, capacityAddmroom);
pre.setString(7, deviceAddmroom);
pre.setBinaryStream(8, fis, (int) image.length());
pre.setInt(9, userid);
pre.setTimestamp(10, new java.sql.Timestamp(today.getTime()));//db coloumn name timestamp
pre.execute();
fis.close();
//use 4 image
// st.execute(query);
} catch (SQLException sq) {
sq.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}finally {
try {
if (rs != null) {
rs.close();
fis.close();
//use 4 image
}
fis.close();
//use 4 image con.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
// return "subBankInformation";// As void, so not return String
}
