How to Insert or Get Back Image File with DataBase in using Java Programs
import java.sql.*;
import java.util.*;
import java.io.*;
public class InsertBlob
{
public static void main(String ar[])
{
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/college","root","me");
String qry = "insert into imagee values(?,?,?)";
PreparedStatement ps=con.prepareStatement(qry);
ps.setString(1,"Chetan");
ps.setString(2,"Chauhan");
File f = new File("Butterfly.jpg");
FileInputStream fis = new FileInputStream(f);
System.out.println((int)f.length());
ps.setBinaryStream(3,fis,(int)f.length());
int i = ps.executeUpdate();
System.out.println(i+ " Record inserted successfully");
}
catch(Exception e)
{
System.out.println(e);
}
}
}
...........................
To Get Image From DataBase
<%@page import="java.sql.*,java.io.*"%>
<% InputStream sImage; response.setContentType("image/jpeg"); try { Class.forName("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/college","root","me"); Statement stmt = con.createStatement(); String qry="select * from imagee"; ResultSet rs=stmt.executeQuery(qry); if(rs.next()) { byte[] bytearray = new byte[1048576]; response.setContentLength(bytearray.length); int size=0; sImage = rs.getBinaryStream(3); //response.reset(); while((size=sImage.read(bytearray))!= -1) { response.getOutputStream().write(bytearray,0,size); } } } catch(Exception e) { System.out.println(e); } %>
import java.util.*;
import java.io.*;
public class InsertBlob
{
public static void main(String ar[])
{
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/college","root","me");
String qry = "insert into imagee values(?,?,?)";
PreparedStatement ps=con.prepareStatement(qry);
ps.setString(1,"Chetan");
ps.setString(2,"Chauhan");
File f = new File("Butterfly.jpg");
FileInputStream fis = new FileInputStream(f);
System.out.println((int)f.length());
ps.setBinaryStream(3,fis,(int)f.length());
int i = ps.executeUpdate();
System.out.println(i+ " Record inserted successfully");
}
catch(Exception e)
{
System.out.println(e);
}
}
}
...........................
To Get Image From DataBase
<%@page import="java.sql.*,java.io.*"%>
<% InputStream sImage; response.setContentType("image/jpeg"); try { Class.forName("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/college","root","me"); Statement stmt = con.createStatement(); String qry="select * from imagee"; ResultSet rs=stmt.executeQuery(qry); if(rs.next()) { byte[] bytearray = new byte[1048576]; response.setContentLength(bytearray.length); int size=0; sImage = rs.getBinaryStream(3); //response.reset(); while((size=sImage.read(bytearray))!= -1) { response.getOutputStream().write(bytearray,0,size); } } } catch(Exception e) { System.out.println(e); } %>
FrameWork Program Collection in Java
DemoAL.java
import java.util.ArrayList;
import java.util.Iterator;
public class DemoAL {
public static void main(String[] args)
{
ArrayList al=new ArrayList();
al.add("JAVA");
al.add("PHP");
al.add("ORACLE");
al.add("ASP.NET");
System.out.println(al);
System.out.println("-------------------------------------");
/*for(String s:al)
{
System.out.println(s);
}*/
Iterator itr=al.iterator();
while(itr.hasNext())
{
System.out.println(itr.next());
}
}
}
-----------------------
DemoALDataBase
import java.util.ArrayList;
import java.sql.*;
class DemoDB
{
String user,pass;
int sno;
DemoDB(String user,String pass,int sno)
{
this.user=user;
this.pass=pass;
this.sno=sno;
}
}
public class DemoALDataBase {
public ArrayList showResultAL()
{
ArrayList al=new ArrayList();
try
{
Class.forName("com.mysql.jdbc.Driver"); //type 4 driver
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/college","root","rat");//connection
System.out.println("Connection successful:"+con);
Statement stmt=con.createStatement();//creating statement for the further
ResultSet res=stmt.executeQuery("select * from login");
while(res.next())
{
String u=res.getString(1);
String p=res.getString(2);
int sno=res.getInt(3);
al.add(new DemoDB(u,p,sno));
}
}
catch(Exception e )
{
}
System.out.println("size is :"+al.size());
return al;
}
public static void main(String args[])
{
DemoALDataBase ob=new DemoALDataBase();
ArrayList al=ob.showResultAL();
DemoDB obj=al.get(2);
System.out.println(obj.user+","+obj.pass+","+obj.sno);
/* for(DemoDB obj:al)
{
System.out.println(obj.user+","+obj.pass+","+obj.sno);
}*/
}
}
-----------------------------
DemoHashMap.java
import java.util.Collection;
import java.util.HashMap;
import java.util.Iterator;
public class DemoHashMap {
public static void main(String[] args) {
//create HashMap object
HashMap hMap = new HashMap();
//add key value pairs to HashMap
hMap.put("1","ram");
hMap.put("2","shyam");
hMap.put("3","mohan");
/*
get Collection of values contained in HashMap using
Collection values() method of HashMap class
*/
Collection c = hMap.values();
//obtain an Iterator for Collection
Iterator itr = c.iterator();
//iterate through HashMap values iterator
while(itr.hasNext())
System.out.println(itr.next());
}
}
----------------------------
DemoHashMap1.java
import java.util.Collection;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Set;
public class DemoHashMap1 {
public static void main(String[] args) {
//create HashMap object
HashMap hMap = new HashMap();
//add key value pairs to HashMap
hMap.put("1","java");
hMap.put("2","php");
hMap.put("3","oracle");
Set s=hMap.keySet();
System.out.println("size is :"+s.size());
String arr[]=new String[s.size()];
Iterator itr=s.iterator();
for(int i=0;i
{
arr[i]=itr.next();
System.out.println(arr[i]+":"+hMap.get(arr[i]));
}
// System.out.println(hMap.get("3"));
}
}
import java.util.ArrayList;
import java.util.Iterator;
public class DemoAL {
public static void main(String[] args)
{
ArrayList al=new ArrayList();
al.add("JAVA");
al.add("PHP");
al.add("ORACLE");
al.add("ASP.NET");
System.out.println(al);
System.out.println("-------------------------------------");
/*for(String s:al)
{
System.out.println(s);
}*/
Iterator itr=al.iterator();
while(itr.hasNext())
{
System.out.println(itr.next());
}
}
}
-----------------------
DemoALDataBase
import java.util.ArrayList;
import java.sql.*;
class DemoDB
{
String user,pass;
int sno;
DemoDB(String user,String pass,int sno)
{
this.user=user;
this.pass=pass;
this.sno=sno;
}
}
public class DemoALDataBase {
public ArrayList showResultAL()
{
ArrayList al=new ArrayList();
try
{
Class.forName("com.mysql.jdbc.Driver"); //type 4 driver
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/college","root","rat");//connection
System.out.println("Connection successful:"+con);
Statement stmt=con.createStatement();//creating statement for the further
ResultSet res=stmt.executeQuery("select * from login");
while(res.next())
{
String u=res.getString(1);
String p=res.getString(2);
int sno=res.getInt(3);
al.add(new DemoDB(u,p,sno));
}
}
catch(Exception e )
{
}
System.out.println("size is :"+al.size());
return al;
}
public static void main(String args[])
{
DemoALDataBase ob=new DemoALDataBase();
ArrayList al=ob.showResultAL();
DemoDB obj=al.get(2);
System.out.println(obj.user+","+obj.pass+","+obj.sno);
/* for(DemoDB obj:al)
{
System.out.println(obj.user+","+obj.pass+","+obj.sno);
}*/
}
}
-----------------------------
DemoHashMap.java
import java.util.Collection;
import java.util.HashMap;
import java.util.Iterator;
public class DemoHashMap {
public static void main(String[] args) {
//create HashMap object
HashMap hMap = new HashMap();
//add key value pairs to HashMap
hMap.put("1","ram");
hMap.put("2","shyam");
hMap.put("3","mohan");
/*
get Collection of values contained in HashMap using
Collection values() method of HashMap class
*/
Collection c = hMap.values();
//obtain an Iterator for Collection
Iterator itr = c.iterator();
//iterate through HashMap values iterator
while(itr.hasNext())
System.out.println(itr.next());
}
}
----------------------------
DemoHashMap1.java
import java.util.Collection;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Set;
public class DemoHashMap1 {
public static void main(String[] args) {
//create HashMap object
HashMap hMap = new HashMap();
//add key value pairs to HashMap
hMap.put("1","java");
hMap.put("2","php");
hMap.put("3","oracle");
Set s=hMap.keySet();
System.out.println("size is :"+s.size());
String arr[]=new String[s.size()];
Iterator itr=s.iterator();
for(int i=0;i
{
arr[i]=itr.next();
System.out.println(arr[i]+":"+hMap.get(arr[i]));
}
// System.out.println(hMap.get("3"));
}
}
A Simple Struts Program to Verify User Name or Password
DemoAction.java
package com.rat.action;
import java.sql.*;
import java.util.ArrayList;
import java.util.Map;
import org.apache.struts2.interceptor.ApplicationAware;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;
import com.opensymphony.xwork2.Preparable;
public class DemoAction extends ActionSupport implements Preparable,ModelDriven
{
DemoBean obj;
Connection con;
Statement stmt;
PreparedStatement ps;
public void prepare() throws Exception
{
obj=new DemoBean();
try
{
Class.forName("com.mysql.jdbc.Driver"); //type 4 driver
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/college","root","rat");//connection
System.out.println("Connection successful:"+con);
stmt=con.createStatement();
}
catch(Exception e)
{
e.printStackTrace();
}
}
_________________________________________________
DemoBean.java
package com.rat.action;
public class DemoBean
{
private String uname="",pass="";
public void setUname(String uname)
{
this.uname=uname;
}
public void setPass(String pass)
{
this.pass=pass;
}
public String getUname()
{
return uname;
}
public String getPass()
{
return pass;
}
}
_________________________________________________
ViewAllAction.java
package com.rat.action;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Map;
import org.apache.struts2.interceptor.ApplicationAware;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;
import com.opensymphony.xwork2.Preparable;
public class ViewAllAction extends ActionSupport implements Preparable,ApplicationAware
{
Connection con;
Statement stmt;
DemoBean obj;
Map application;
public void setApplication(Map application)
{
this.application=application;
}
public void prepare()
{
try
{
Class.forName("com.mysql.jdbc.Driver"); //type 4 driver
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/college","root","rat");//connection
System.out.println("Connection successful:"+con);
stmt=con.createStatement();
}
catch(Exception e)
{
e.printStackTrace();
}
}
Retrieving blob values from database in string format Java Program
import java.sql.*;
public class DemoBlob
{
public static void main(String args[])throws Exception
{
Class.forName("com.mysql.jdbc.Driver"); //type 4 driver
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/college","root","rat");//connection
System.out.println("Connection successful:"+con);
PreparedStatement ps=con.prepareStatement("select * from login");
ResultSet res=ps.executeQuery();
res.next();
Blob b= res.getBlob(1);
long len=b.length();
byte value[]=b.getBytes(1, (int)(len));
String str=new String(value);
System.out.println(str);
}
}
public class DemoBlob
{
public static void main(String args[])throws Exception
{
Class.forName("com.mysql.jdbc.Driver"); //type 4 driver
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/college","root","rat");//connection
System.out.println("Connection successful:"+con);
PreparedStatement ps=con.prepareStatement("select * from login");
ResultSet res=ps.executeQuery();
res.next();
Blob b= res.getBlob(1);
long len=b.length();
byte value[]=b.getBytes(1, (int)(len));
String str=new String(value);
System.out.println(str);
}
}
A Simple Java Program to Insert Value in DataBase
import java.util.Date;
import java.sql.*;
public class DemoDate
{
public static void main(String args[])throws Exception
{
Date d=new Date();
long l=d.getTime();
System.out.println(l);
java.sql.Date obj=new java.sql.Date(l);
Class.forName("com.mysql.jdbc.Driver"); //type 4 driver
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/college","root","rat");//connection
System.out.println("Connection successful:"+con);
PreparedStatement ps=con.prepareStatement("insert into demo values(?)");
ps.setDate(1, obj);
ps.executeUpdate();
System.out.println("operation successful");
ps=con.prepareStatement("select * from demo");
ResultSet res=ps.executeQuery();
res.next();
d=res.getDate(1);
System.out.println(d);
}
}
import java.sql.*;
public class DemoDate
{
public static void main(String args[])throws Exception
{
Date d=new Date();
long l=d.getTime();
System.out.println(l);
java.sql.Date obj=new java.sql.Date(l);
Class.forName("com.mysql.jdbc.Driver"); //type 4 driver
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/college","root","rat");//connection
System.out.println("Connection successful:"+con);
PreparedStatement ps=con.prepareStatement("insert into demo values(?)");
ps.setDate(1, obj);
ps.executeUpdate();
System.out.println("operation successful");
ps=con.prepareStatement("select * from demo");
ResultSet res=ps.executeQuery();
res.next();
d=res.getDate(1);
System.out.println(d);
}
}
Create A Media Player in Java Or Play Files
import java.awt.*;
import java.awt.event.*;
import java.io.*;
import javax.swing.*;
import javax.media.*;
public class MediaPlayerDemo extends JFrame
{
private Player player;
private File file;
public MediaPlayerDemo()
{
super( "Java Media Player" );
JButton openFile = new JButton( "Open file (Browse) to play" );
openFile.addActionListener( new ActionListener()
{
public void actionPerformed( ActionEvent e )
{
openFile();
createPlayer();
}
});
getContentPane().add( openFile, BorderLayout.NORTH );
setSize( 100, 200 );
show();
}
private void openFile()
{
JFileChooser fileChooser = new JFileChooser();
fileChooser.setFileSelectionMode( JFileChooser.FILES_ONLY );
int result = fileChooser.showOpenDialog( this );
if ( result == JFileChooser.CANCEL_OPTION )
file = null;
else
file = fileChooser.getSelectedFile();
}
private void createPlayer()
{
if ( file == null )
return;
removePreviousPlayer();
try
{
player = Manager.createPlayer( file.toURL() );
player.addControllerListener( new EventHandler() );
player.start();
}
catch ( Exception e )
{
JOptionPane.showMessageDialog( this, "Invalid file or location", "Error loading file",
JOptionPane.ERROR_MESSAGE );
}
}
private void removePreviousPlayer()
{
if ( player == null )
return;
player.close();
Component visual = player.getVisualComponent();
Component control = player.getControlPanelComponent();
Container c = getContentPane();
if ( visual != null )
c.remove( visual );
if ( control != null )
c.remove( control );
}
public static void main(String args[])
{
MediaPlayerDemo app = new MediaPlayerDemo();
app.addWindowListener( new WindowAdapter()
{
public void windowClosing( WindowEvent e )
{
System.exit(0);
}
}
}
private class EventHandler implements ControllerListener
{
public void controllerUpdate( ControllerEvent e )
{
if ( e instanceof RealizeCompleteEvent )
{
Container c = getContentPane();
Component visualComponent = player.getVisualComponent();
if ( visualComponent != null )
c.add( visualComponent, BorderLayout.CENTER );
Component controlsComponent = player.getControlPanelComponent();
if ( controlsComponent != null )
c.add( controlsComponent, BorderLayout.SOUTH );
c.doLayout();
}
}
}
}
import java.awt.event.*;
import java.io.*;
import javax.swing.*;
import javax.media.*;
public class MediaPlayerDemo extends JFrame
{
private Player player;
private File file;
public MediaPlayerDemo()
{
super( "Java Media Player" );
JButton openFile = new JButton( "Open file (Browse) to play" );
openFile.addActionListener( new ActionListener()
{
public void actionPerformed( ActionEvent e )
{
openFile();
createPlayer();
}
});
getContentPane().add( openFile, BorderLayout.NORTH );
setSize( 100, 200 );
show();
}
private void openFile()
{
JFileChooser fileChooser = new JFileChooser();
fileChooser.setFileSelectionMode( JFileChooser.FILES_ONLY );
int result = fileChooser.showOpenDialog( this );
if ( result == JFileChooser.CANCEL_OPTION )
file = null;
else
file = fileChooser.getSelectedFile();
}
private void createPlayer()
{
if ( file == null )
return;
removePreviousPlayer();
try
{
player = Manager.createPlayer( file.toURL() );
player.addControllerListener( new EventHandler() );
player.start();
}
catch ( Exception e )
{
JOptionPane.showMessageDialog( this, "Invalid file or location", "Error loading file",
JOptionPane.ERROR_MESSAGE );
}
}
private void removePreviousPlayer()
{
if ( player == null )
return;
player.close();
Component visual = player.getVisualComponent();
Component control = player.getControlPanelComponent();
Container c = getContentPane();
if ( visual != null )
c.remove( visual );
if ( control != null )
c.remove( control );
}
public static void main(String args[])
{
MediaPlayerDemo app = new MediaPlayerDemo();
app.addWindowListener( new WindowAdapter()
{
public void windowClosing( WindowEvent e )
{
System.exit(0);
}
}
}
private class EventHandler implements ControllerListener
{
public void controllerUpdate( ControllerEvent e )
{
if ( e instanceof RealizeCompleteEvent )
{
Container c = getContentPane();
Component visualComponent = player.getVisualComponent();
if ( visualComponent != null )
c.add( visualComponent, BorderLayout.CENTER );
Component controlsComponent = player.getControlPanelComponent();
if ( controlsComponent != null )
c.add( controlsComponent, BorderLayout.SOUTH );
c.doLayout();
}
}
}
}
A simple Audio File Load and Play Java Program
import java.applet.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
public class LoadAudioAndPlay extends JApplet
{
private AudioClip sound1, sound2, currentSound;
private JButton playSound, loopSound, stopSound;
private JComboBox chooseSound;
public void init()
{
Container c = getContentPane();
c.setLayout( new FlowLayout() );
String choices[] = { "Welcome", "Hi" };
chooseSound = new JComboBox( choices );
chooseSound.addItemListener( new ItemListener()
{
public void itemStateChanged( ItemEvent e )
{
currentSound.stop();
currentSound = chooseSound.getSelectedIndex() == 0 ? sound1 : sound2;
}
});
c.add( chooseSound );
ButtonHandler handler = new ButtonHandler();
playSound = new JButton( "Play" );
playSound.addActionListener( handler );
c.add( playSound );
loopSound = new JButton( "Loop" );
loopSound.addActionListener( handler );
c.add( loopSound );
stopSound = new JButton( "Stop" );
stopSound.addActionListener( handler );
c.add( stopSound );
sound1 = getAudioClip( getDocumentBase(), "welcome.wav" );
sound2 = getAudioClip( getDocumentBase(), "hi.au" );
currentSound = sound1;
}
public void stop()
{
currentSound.stop();
}
private class ButtonHandler implements ActionListener
{
public void actionPerformed( ActionEvent e )
{
if ( e.getSource() == playSound )
currentSound.play();
else if ( e.getSource() == loopSound )
currentSound.loop();
else if ( e.getSource() == stopSound )
currentSound.stop();
}
}
}
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
public class LoadAudioAndPlay extends JApplet
{
private AudioClip sound1, sound2, currentSound;
private JButton playSound, loopSound, stopSound;
private JComboBox chooseSound;
public void init()
{
Container c = getContentPane();
c.setLayout( new FlowLayout() );
String choices[] = { "Welcome", "Hi" };
chooseSound = new JComboBox( choices );
chooseSound.addItemListener( new ItemListener()
{
public void itemStateChanged( ItemEvent e )
{
currentSound.stop();
currentSound = chooseSound.getSelectedIndex() == 0 ? sound1 : sound2;
}
});
c.add( chooseSound );
ButtonHandler handler = new ButtonHandler();
playSound = new JButton( "Play" );
playSound.addActionListener( handler );
c.add( playSound );
loopSound = new JButton( "Loop" );
loopSound.addActionListener( handler );
c.add( loopSound );
stopSound = new JButton( "Stop" );
stopSound.addActionListener( handler );
c.add( stopSound );
sound1 = getAudioClip( getDocumentBase(), "welcome.wav" );
sound2 = getAudioClip( getDocumentBase(), "hi.au" );
currentSound = sound1;
}
public void stop()
{
currentSound.stop();
}
private class ButtonHandler implements ActionListener
{
public void actionPerformed( ActionEvent e )
{
if ( e.getSource() == playSound )
currentSound.play();
else if ( e.getSource() == loopSound )
currentSound.loop();
else if ( e.getSource() == stopSound )
currentSound.stop();
}
}
}
Subscribe to:
Posts (Atom)