Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¶ÁÈ¡sqlserverͼƬimageÊý¾ÝÉú³ÉͼƬÎļþ

//test.java
import java.io.BufferedOutputStream;
import java.io.DataOutputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class test {
 
 public static  void   main (String [] arge){
  try {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
   String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=TableName", user="username",
   password="password";
   Connection conn= DriverManager.getConnection(url,user,password);
   Statement stmt = conn.createStatement();
   ResultSet rs;
   String strSql  = "select name,photo from patient where name='name";
   InputStream   in   =   null;
   FileOutputStream   fileOutStream   =   null;
   rs=stmt.executeQuery(strSql);
   while(rs.next()){
    //Windows ϵͳÏ´洢·¾¶ÓÃ2¸ö·´Ð±¸Ü 
    DataOutputStream sos = new DataOutputStream(new BufferedOutputStream(new FileOutputStream("d:\\"+ rs.getString("name") +".jpg"))); 
    //¶Á³öÁ÷ÓÃgetBinaryStream()·½·¨¡£ 
    in = rs.getBinaryStream("photo");
    //Óûº´æÊý×éÖð½¥Êä³öÁ÷
    int len = 0;
    byte[] b = new byte[1024];
    while ((len = in.read(b)) != -1) {
     sos.write(b,0,len);
    }
    sos.close();
    in.close();
   }
   rs.close();
  &nbs


Ïà¹ØÎĵµ£º

PowerdesignerµÄÄæÏò¹¤³Ì½«sqlserverÊý¾Ý¿âÉú³ÉPDM

»·¾³£ºvs2005+sqlserver2005+PowerDesigner 12
 
´ò¿ªPowerDesigner 12(ÒÔϼò³Æpd)£¬Ð½¨pdm¹¤³Ì£¬ÈçͼËùʾ£º
 
×¢£ºdbmsÑ¡ÔñÄúĿǰÐèҪת»»µÄÀà±ð£¬ÎÒÓõÄÊÇsqlserver2005¡£
 
È»ºóÑ¡Ôñ²Ëµ¥¡¶Êý¾Ý¿â¡·¡¶ÏµÍ³DSN¡·£¬Ñ¡Ôñ»òÕßÌí¼ÓÄúÐèÒªµÄÊý¾Ý¿â£¬ÎÒÕâÀïÑ¡ÔñµÄÊÇsql server¡£ÈçͼËùʾ£º
 
½¨ºÃ ......

SQLSERVERÊý¾Ý¿â»¹Ô­ÊµÕ½

1£©Ð½¨Êý¾Ý¿âRESTORE
2£©ÔÚ¸ÃÊý¾Ý¿âÉÏÑ¡Ôñ£ºÈÎÎñ->»¹Ô­->Êý¾Ý¿â
3£©ÔÚ»¹Ô­Êý¾Ý¿â-RESTOREµÄ¶Ô»°¿òÖÐ
   Ä¿±êÊý¾Ý¿âÊÇRESTORE
   Ö¸¶¨ÓÃÓÚ»¹Ô­µÄ±¸·Ý¼¯µÄÔ´ºÍλÖÃ->Ô´É豸->Ñ¡Ôñ×îºóÒ»¸öÍêÈ«µÄ±¸·ÝBAKÎļþ
   ¹´Öл¹Ô­CheckBox
4£©Ñ¡Ôñ×óÉϽǵÄÑ¡Ïî
   ÔÚ»¹Ô­Ñ ......

sqlServerÖеÄ×ÔÔö×Ö¶Î


 
SQLÓï¾äÈçÏÂ:
CREATE TABLE [dbo].[test_table] (
    [ID] [int] IDENTITY (1, 1) NOT NULL ,
    [NAME] [varchar] (80)
)
Éè¼ÆÊÓͼÏÂ,ÔÚÌí¼ÓÒ»¸öINTÐ͵Ä×Ö¶ÎÊÇ,Ñ¡ÖÐÏ·½µÄ"±êʶ"Ϊ"ÊÇ",ÏÂÃæÓÐ"±êʶÖÖ×Ó"ºÍ"±êʶ×ÔÔöÁ¿",¿ÉÒÔ×Ô¼ºÉèÖÃ,ĬÈ϶¼Îª1
µ«ÊDz»ÖªµÀΪʲô,ʹÓÃÈÎÎ ......

sqlserver·ÖÒ³´æ´¢¹ý³ÌµÄÓ÷¨

create proc P_QuerySplit
 @sqlscript varchar(20),         --±íÃû/SQLÓï¾ä
 @pageSize int,                  --ÿҳ¼Ç¼Êý
 @pageIndex int,   &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ