java操作sqlserver image字段

显示

List<AlarmForm> dataFormList = new ArrayList();

String stuphonepath=System.getProperty("locksys_school.root") +"stuphone/";
while(rs.next())
{
AlarmForm dataform = new AlarmForm();
dataform.setStuid(rs.getString("userid"));
dataform.setStuname(rs.getString("username"));
try {

int tmpi=0;
InputStream ins= rs.getBinaryStream("UserImage");
if(ins!=null)
{
OutputStream out = new FileOutputStream(stuphonepath+dataform.getStuid()+".jpg");
while((tmpi=ins.read())!=-1){
out.write(tmpi);
}
ins.close();
out.flush();
out.close();
dataform.setStuphonefilename(dataform.getStuid()+".jpg");
}
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


dataFormList.add(dataform);
}

return dataFormList;

插入

String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";  //加载JDBC驱动
 String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=zyCenter";  //连接服务器和数据库test
 String userName = "sa";  //默认用户名
 String userPwd = "";  //密码
 Connection dbConn;


 try {
  Class.forName(driverName);
  dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
  String s="insert into UserImage(userid,userimage)  values(44,?)";
  PreparedStatement stat=(PreparedStatement) dbConn.prepareStatement(s);
 FileInputStream fi=new FileInputStream("d://bd_logo1.jpg");
 stat.setBinaryStream(1,fi, fi.available());
   stat.execute();
   fi.close();
   stat.close();
   dbConn.close();
  System.out.println("Connection Successful!");  //如果连接成功 控制台输出Connection Successful!
 } catch (Exception e) {
  e.printStackTrace();
 }