呵呵 以前记得写过的 忘记了 就又找些资料写出来了
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package objectintodb;
import java.io.ByteArrayInputStream;
import java.io.IOException;
import java.io.ObjectInputStream;
import java.io.ObjectOutputStream;
import java.io.PipedInputStream;
import java.io.PipedOutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
/**
*
* @author root
*/
public class Main {
/**
* @param args the command line arguments
*/
public static void main(String[] args) throws SQLException, ClassNotFoundException, IOException {
// TODO code application logic here
Connection conn=getConn();
//java.sql.PreparedStatement pstmt=conn.prepareStatement("insert into user values (?)");
//saveObject(new User("ty", "男", 20), pstmt, 1);
//pstmt.execute();
ResultSet rs=conn.createStatement().executeQuery("select user from user");
User user=null;
while(rs.next())
{
user= (User)(read(rs, "user"));
}
rs.close();
System.out.println(user.getUname());
}
static void saveObject(User user,PreparedStatement pstmt,int paramterIndex)
{
PipedInputStream is=new PipedInputStream();
try {
ObjectOutputStream oout = new ObjectOutputStream(new PipedOutputStream(is));
oout.writeObject(user);
oout.close();
pstmt.setBinaryStream(1, is, is.available());
} catch (IOException ex) {
Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
}
catch (SQLException sx)
{
sx.printStackTrace();
}
}
static Object read(ResultSet rs,String column) throws ClassNotFoundException, IOException, SQLException
{
byte[] buf=rs.getBytes(column);
if(buf!=null)
{
ObjectInputStream objIn=new ObjectInputStream(new ByteArrayInputStream(buf));
return objIn.readObject();
}
return null;
}
static Connection getConn()
{
Connection conn=null;
try {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/user";
String username = "ty";
String pwd = "ty";
Class.forName(driver);
conn = DriverManager.getConnection(url, username, pwd);
} catch (SQLException ex) {
Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
} catch (ClassNotFoundException ex) {
Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
}
return conn;
}
}
跟你的没多大的不同，主要就是你的
InputStream is = rs.getBinaryStream("bean");
和我的
byte[] buf=rs.getBytes(column);
我的测试已经成功了
ty
BUILD SUCCESSFUL (total time: 0 seconds)
