Java help.......

[lakindu93]

yaluwane.... help ekak oni........

JLable ekaka thiyena image (image icon) ekak database eke BLOB vidihata store karanne kohomada....?
(database eka hadala tiyenne....)

System eke path ekak na image ekata... Jlable eke tiyenne....

puluwannam java codings tika ewannakoo.....

 

[rcccc]

bump

 

[Gayan_BC]

macahn blob widihata daaganna epa data base eka struk wenwa tikakin.. bump..

 

[DJvodka]

Image ekak thiyenawanam path ekak nethi wenna be!

 

[lakindu93]

macahn blob widihata daaganna epa data base eka struk wenwa tikakin.. bump..

ehenam kohomada save katanne DB eke?

 

[lakindu93]

Image ekak thiyenawanam path ekak nethi wenna be!

mam web cam eken ganna 4to eke kelinma lable ekakata yanne.... pc eke save wenne na a JLable eke thiyena eka thama DB ekata danna oni...

 

[lakindu93]

Image ekak thiyenawanam path ekak nethi wenna be!

mam web cam eken ganna 4to eke kelinma JLable ekakata yanne.... pc eke save wenne na a JLable eke thiyena eka thama DB ekata danna oni...

 

[DJvodka]

mam web cam eken ganna 4to eke kelinma JLable ekakata yanne.... pc eke save wenne na a JLable eke thiyena eka thama DB ekata danna oni...

Mulinma webcam eken ganna pic eka I/O walin disk ekata save kara ganna. Ita passe disk eke image eka JLable ekata denna. Pic eka disk ekata save karapu location eke path eka DB ekata dunna nam hari neda?

 

[lakindu93]

Mulinma webcam eken ganna pic eka I/O walin disk ekata save kara ganna. Ita passe disk eke image eka JLable ekata denna. Pic eka disk ekata save karapu location eke path eka DB ekata dunna nam hari neda?

ow machan ehema kala nam hari..... man eka kala... eth pc ekata save wenne nathiwa karanna baluwe.....

 

[DJvodka]

ow machan ehema kala nam hari..... man eka kala... eth pc ekata save wenne nathiwa karanna baluwe.....

Podi search ekak daala beluawa. test kare nam ne code eka.

1. DB table eka mehema hadanna

[CODE]CREATE TABLE MyPictures (
   photo  BLOB
);

[/CODE]

2. Den web cam eken gatta pic eka InputStream ekakin mysql walin dunnama hari. Eg: Pic eka temp file ekak widiyata disk ekata write karala query eka execute karaata passe delete karanna puluwan. Ethakota DB eke pic eka save wenawa.

Manual way:

INSERT INTO MyPictures (photo) VALUES(LOAD_FILE('/tmp/photo.png'));

Java way:

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class InsertPictureToMySql {
  public static void main(String[] args) throws Exception, IOException, SQLException {
    Class.forName("org.gjt.mm.mysql.Driver");
    Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/databaseName", "root", "root");
    String INSERT_PICTURE = "INSERT INTO MyPictures (photo) VALUES (?)";

    FileInputStream fis = null;
    PreparedStatement ps = null;
    File file = null;
    try {
      conn.setAutoCommit(false);
      file = new File("/tmp/photo.png");
      fis = new FileInputStream(file);
      ps = conn.prepareStatement(INSERT_PICTURE);
      ps.setBinaryStream(1, fis, (int) file.length());
      ps.executeUpdate();
      conn.commit();
    } finally {
      ps.close();
      fis.close();
/////////////////////////Now photo can be safely deleted/////////////////

file.delete();
    }
  }
}

 

[lakindu93]

Podi search ekak daala beluawa. test kare nam ne code eka.

1. DB table eka mehema hadanna

[CODE]CREATE TABLE MyPictures (
   photo  BLOB
);

[/CODE]

2. Den web cam eken gatta pic eka InputStream ekakin mysql walin dunnama hari. Eg: Pic eka temp file ekak widiyata disk ekata write karala query eka execute karaata passe delete karanna puluwan. Ethakota DB eke pic eka save wenawa.

Manual way:

INSERT INTO MyPictures (photo) VALUES(LOAD_FILE('/tmp/photo.png'));

Java way:

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class InsertPictureToMySql {
  public static void main(String[] args) throws Exception, IOException, SQLException {
    Class.forName("org.gjt.mm.mysql.Driver");
    Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/databaseName", "root", "root");
    String INSERT_PICTURE = "INSERT INTO MyPictures (photo) VALUES (?)";

    FileInputStream fis = null;
    PreparedStatement ps = null;
    File file = null;
    try {
      conn.setAutoCommit(false);
      file = new File("/tmp/photo.png");
      fis = new FileInputStream(file);
      ps = conn.prepareStatement(INSERT_PICTURE);
      ps.setBinaryStream(1, fis, (int) file.length());
      ps.executeUpdate();
      conn.commit();
    } finally {
      ps.close();
      fis.close();
/////////////////////////Now photo can be safely deleted/////////////////

file.delete();
    }
  }
}

thanks... try karala balala kiyannam....