import java.sql.*;
import java.io.*;
public class Mp3Test{
public static Connection con=null;
public static PreparedStatement ps=null;
public static void main(String[] args){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=pubs";
con=DriverManager.getConnection(url,"sa","");
InputStream in=new FileInputStream("f:/1.mp3");
String sql="insert into [Table] values(?)";
ps=con.prepareStatement(sql);
ps.setBinaryStream(1,in,in.available());
System.out.println("insert into Database");
ps.executeUpdate();
OutputStream out=new FileOutputStream("c:/2.mp3");
String sql1="select * from [Table]";
ps=con.prepareStatement(sql1);
ResultSet rs=ps.executeQuery();
rs.next();
InputStream in1=rs.getBinaryStream(2);
byte [] buffer=new byte[1024*2];
int length=0;