JDBC interview questions
- Image upload from JSP to DataBase ? view answer
- How to Upload Image into Data Base ? view answer
- Q. What is Rowset ? CachedRowSet,JDBCRowSet and WebRowSet ? view answer
- Q. What is Batch Updates Using Statements in JDBC ? view answer
- Q.Handling Blob and CLOB data using JDBC ? Insert CLOB and Retrive CLOB , Convert into String ? view answer
- Q. Calling Stored procedures with Callable Statement ? view answer
- Q.What is JDBC ? Explain Types Of Drivers with Advantage and Disadvantage ? view answer
- Q. How java retrive the result returns from stored procedure ? view answer
- Q.How to retrive the results in java returned by refcursor in Stored procedure ? view answer
- Q.Reading an Oracle ARRAY from a stored procedure as an out ? view answer
- What is Metadata and why should I use it? view answer
- How Class.forName() load the Driver and DriverManager.getConnection() return connection? view answer
- What will Class.forName do while loading drivers? view answer
- How to Determining If a Result Set Is Scrollable? view answer
- How Getting the Number of Rows in a Table Using a Scrollable Result Set? view answer
- What is Scrollable Result Set ?
view answer
- What does setAutoCommit do?
view answer
- What is the difference between TYPE_SCROLL_INSENSITIVE , and TYPE_SCROLL_SENSITIVE?
view answer
- How to Make Updates to Updatable Result Sets?
view answer
- How can you move the cursor in scrollable result sets?
view answer
- What are the different types of Statements with Example?
view answer
- How can you retrieve data from the ResultSet?
view answer
- How can you create JDBC statements and what are they?
view answer
- How can you make the connection? view answer
- What will Class.forName do while loading drivers? view answer
- How can you load the drivers?
view answer
- What is PreparedStatement ? view answer
- what is rowset? and how does it differ from resultset ? view answer
- How to find total column from a resultset? view answer
- What is the fastest type of JDBC driver? view answer
- What are the different JDB drivers available? view answer
- Q.What are collection pools? What are the advantages? view answer
- Q.What are different types of Transaction Isolation Levels? view answer
- Q. What is Dirty read? view answer
- Q.Difference between Statement , PreparedStatement and CallableStatement ? view answer
- Q.What is the advantage of using PreparedStatement? view answer
- Q.What is Single-Phase Commit ? view answer
- Q.What is two-phase commit? view answer
- Q. How JDBC work with REF CURSOR returned by stored procedure and retrive results? view answer
- Q. How do i get result return from stored procedure in JDBC? view answer
- Q.How do you call a Stored Procedure from JDBC? view answer
- Q.How do you handle your own transaction ? view answer
- Q.What are the steps in the JDBC connection?
view answer
|
!!! JDBC interview questions !!!
Image upload from JSP to DataBase ?
Image upload from JSP to Data Base step by step :
step 1 :
In the JSP
<form name="regform2" method="post" enctype="multipart/form-data">
<input type="file" name="ImageFile" id="ImageFile" onChange="uploadImage()"/>
</form>
java script :
function uploadImage(){
document.regform.action ="<%=request.getContextPath()%>/dfdmin?cmd=uploadimage";
document.regform.submit();
}
Step 2.
In the servlet - add the below code.
String rtempfile = File.createTempFile("temp","1").getParent();
MultipartRequest multi = new MultipartRequest(request, rtempfile, 500000 * 1024);
File rnewfile=null;
rnewfile = new File(CommonArt.IMAGE_PATH+"jsp"+File.separator+"images"+File.separator+"uploadImage"+File.separator);
if(rnewfile.exists()){
}else{
rnewfile.mkdirs();
}
File f = multi.getFile("ImageFile");
System.out.println(f.getName());
FileInputStream fin =new FileInputStream(f);
RandomAccessFile r = new RandomAccessFile(rnewfile+File.separator+f.getName(),"rw");
filename = f.getName();
// FileOutputStream fos =new FileOutputStream(rnewfile);
byte sizefile[] = new byte[5000000];
fin.read(sizefile);
// fos.write(sizefile);
r.write(sizefile);
//fos.close();
r.close();
fin.close();
Step 3.
Insert into Database
InputStream is = new FileInputStream(f);
String sql = " INSERT INTO image_upload (IMAGE) VALUES (?) ";
pStmt = conn.prepareStatement(sql);
pStmt.setBinaryStream(1, is, (int)(f.length()));
pStmt.execute();
conn.commit();
This will upload multipart file to your data base.
Note : get cos.jar from oreilly website
|
