|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.vrforcad.ConnectToMySQL
public class ConnectToMySQL
This class perform the Mysql Connection.
Constructor Summary | |
---|---|
ConnectToMySQL()
|
Method Summary | |
---|---|
void |
connect(java.lang.String fileFormat,
java.lang.String typeQuery)
Connect to MySQL database. |
void |
getFile(int id)
Get the file from id. |
void |
queryGetFile(java.lang.String table,
int id)
Get the selected file and download it local in temp folder. |
void |
queryUploadFile(java.lang.String table)
Upload the file to database. |
static long |
readFromBlob(java.sql.Blob blob,
java.io.OutputStream out)
Read from BLOB file type in database |
void |
writeToDatabase(java.lang.String fileFormat,
java.lang.String fileName,
java.lang.String userName,
java.lang.String description)
Upload the file to database. |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public ConnectToMySQL()
Method Detail |
---|
public void connect(java.lang.String fileFormat, java.lang.String typeQuery)
fileFormat
- file extensiontypeQuery
- select, dFile (download file), uFile (upload file)public void getFile(int id)
id
- id numberpublic void queryGetFile(java.lang.String table, int id)
table
- id
- public static long readFromBlob(java.sql.Blob blob, java.io.OutputStream out) throws java.sql.SQLException, java.io.IOException
java.sql.SQLException
java.io.IOException
public void writeToDatabase(java.lang.String fileFormat, java.lang.String fileName, java.lang.String userName, java.lang.String description)
fileFormat
- the file extensionfileName
- the file nameuserName
- the user name who send the file tot databasedescription
- few words about the file (description)public void queryUploadFile(java.lang.String table)
table
- in which table must upload the file
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |