Why the result is Ljava.lang.string after i select multiple images & store the to MySql?

Question

Alvindra Pratama 2016-5-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/286031-why-the-result-is-ljava-lang-string-after-i-select-multiple-images-store-the-to-mysql

评论： Alvindra Pratama 2016-5-30

I have chosen several images from a one folder, after i select 3 images & displayed them into edit text.

 Edit text displayed like this :
D:/1.jpg
D:/2.jpg
D:/3.jpg

But at the table in gui which displayed that data after i save them to MySql, the data become Ljava.lang.string, not like edit text displayed above. How can i displayed the data like edit text above again?

2 个评论
显示无隐藏无

Geoff Hayes 2016-5-27

Alvindra - please show the code that you are using to extract the text from your control and the SQL statement that you have written to save the data to your database. Also, please confirm that the correct filenames (those from above) are being written to the database. If they are, then perhaps it is your SQL statement to get the data from your database that has been incorrectly formed. In either case, you need to show some of the code that you have written.

Alvindra Pratama 2016-5-27

编辑：Alvindra Pratama 2016-5-27

在 MATLAB Online 中打开

For additional information, Ljava.lang.string only happens if I choose more than one image.

Here the picture before i insert all data to the database :

And here the picture after i insert all data to the database & display data from the database to a table in the GUI and then show them back to Their edit text using CellSelectionCallback at that table :

For the code, here the code i used to select multiple images :

%if true
  [filename,pathname,filterindex]=uigetfile({'*.jpg';'*.bmp';'*.png';'*.tif'}, 'MultiSelect', 'on', 'Buka Gambar', 'H:\SKRIPSI\Citra Latih\');
if ~isequal(filename,0)
switch(class(filename))
 case 'double'
    disp('Selection aborted')
 case 'char'
    %disp('Only one image has been selected')
    h = msgbox('Citra Yang Terpilih Hanya Satu');
    ChosenImages = strcat(pathname,filename)
    set(handles.txtketfoto,'String',ChosenImages);
 case 'cell'
numberOfFiles = length(filename);
 q = msgbox([num2str(numberOfFiles) ' Citra Telah Terpilih']);
 selectedFiles = cell(1,numberOfFiles);
 for i = 1:numberOfFiles
     selectedFiles{1,i} = fullfile(pathname, filename{1,i});
     disp(selectedFiles{1,i})
     set(handles.txtketfoto,'String', fullfile(pathname, filename), 'Max', 2)
 end
 otherwise
    disp('Unexpected output')
end
else
  return
%end

Here is the code to save all data to the database :

%if true
  conn=database('pca','root','','com.mysql.jdbc.Driver','jdbc:mysql://localhost:3306/');
id = get(handles.txtid, 'String');
nama = get(handles.txtnama, 'String');
alamat = get(handles.txtalamat, 'String');
foto = get(handles.txtketfoto, 'String');
datainsert(conn,'tbl_pca',{'id','nama','alamat','foto'},{id,nama,alamat,foto});
close(conn);  
%end

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Geoff Hayes 2016-5-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/286031-why-the-result-is-ljava-lang-string-after-i-select-multiple-images-store-the-to-mysql#answer_223758

在 MATLAB Online 中打开

Alvindra - unfortunately, I can't run your code (I observe errors as soon as I run launch the GUI). I think the problem is that when you try to save the files to the database, you extract the filenames as

foto = get(handles.txtketfoto, 'String');

foto is most likely a cell array of strings and so you will have to treat it differently. How should this be written to your database? If you have n files, should you insert n records in to the database, one for each file? Or should you convert this cell array of strings to a single string where each filename is separated by a (for example) semi-colon?

5 个评论
显示 3更早的评论隐藏 3更早的评论

Geoff Hayes 2016-5-29

在 MATLAB Online 中打开

Do this after you have gotten the list of photos:

 foto = get(handles.txtketfoto, 'String');
 if strcmpi(class(foto),'cell')
     myFilesAsString = '';
     % etc.
 else
     myFilesAsString = foto;
 end
 datainsert(conn,'tbl_pca',{'id','nama','alamat','foto'},{id,nama,alamat,myFilesAsString});