How to save excel sheet into mysql database using blob or clob
Hi All,
I am new to java and i need to upload excel sheet to mysql,
please suggest me the steps to do this, i am able to connect to the database, from there i don't know to go further, which one should i use BLOB or CLOB ?
I have tried using CLOB and created a table like this,
create table document
( name varchar(30),
description varchar(30),
contents LONGTEXT,
primary key(name) );
Please help me with the code or steps to insert a large xlsx sheet.
waiting for your assistance friends,
Thank you
View Answers
Ads
Related Tutorials/Questions & Answers:
Advertisements
HOW TO SAVE XML INTO MYSQL AND RETRIEVE IT USING JAVA
HOW TO
SAVE XML INTO
MYSQL AND RETRIEVE IT
USING JAVA H ello, i have an xml code, i need to
save it into
mysql 5.5 server
database using java. i also want to be able to retrieve it as well. please note that i want it saved
update excel sheet using jsp::
update
excel sheet using jsp:: Hi Sir,...
I have a
excel sheet for employee details
"i retrieve particular datas from given
excel sheet and display it into
another
excel sheet using jsp
How to Create New Excel Sheet Using JSP
How to create new
excel sheet using jsp
 ... a new
excel
sheet using
java .You can create any number of new
excel sheets in a
excel file.
To create a
excel sheet we can use third party APIs
how to display data in excel sheet?
how to display data in
excel sheet? According to the user Id,some... will be displayed in
excel sheet.can you people please help me
how to create the button and to display the data in
excel sheet
excel sheet reading and using that data - JSP-Servlet
excel sheet reading and
using that data i have to do a read a
excel sheet file of a employee record and then i have to use a employee details to send mail to those employees
how to do in jsp sir please help me sir..
Thanks
export data from database to excel sheet - JDBC
export data from
database to
excel sheet I am facing a problem about exporting required data from
database table to ms-
excel sheet.i mean whenever I execute a query then result will be display in MS-
EXCEL sheet.
please give me