¶ÁÈ¡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
Ïà¹ØÎĵµ£º
1¡¢ÊµÀýÒ»£º
public void SqlConnectionOpen()
{
SqlConnection myConn=new SqlConnection();
myConn.ConnectionString="server=(local);database=pubs;Trusted_Connection=yes";
......
Êý¾ÝÀï(sqlserver) µÄ²Ù×÷ £º
eg £º2008-3-31 10:34 --> 2008-3-31
Ò».½ØÈ¡×Ö·û´®·½Ê½
select substring('2008-3-31 10:34',0,charindex(' ','2008-3-31 10:34'))
¶þ.
Select
CONVERT(varchar, getdate(), 1),--mm/dd/yy
CONVERT(varchar, getdate(), 2),--yy.mm.dd
CONVERT(varchar, getdate() ......
ÎÒÃÇ×ÜÊǰÑSQL Server Õâ¸öµ¥´Ê¹ÒÔÚ×ì±ß£¬Ò²ÐíºÜÉÙÓÐÈË˼¿¼¹ý SQL Server µ½µ×ÊÇʲô¶«Î÷¡£Õâ¸öÎÊÌâºÜÄÑÓü¸¾ä»°½²Çå³þ¡£ÎÒÃÇÖ®ËùÒÔÒªÓÃÁ¬Ôصķ½Ê½ÌÖÂÛ SQL Server£¬¾ÍÊÇÒª´Ó²»Í¬µÄ½Ç¶È²ûÊöÕâ¸öÎÊÌâ¡£
¡¡¡¡Ò»¡¢·þÎñÆ÷×é¼þ
¡¡¡¡SQL Server 2000ÓÉÁ½¸ö²¿·Ö×é³É£º·þÎñÆ÷×é¼þºÍ¿Í»§¶Ë¹¤¾ß¡£
¡¡¡¡1.ÄÚÈÝ
¡¡¡¡SQL ServerµÄ·þ ......
ÒýÓÃ×Ôhttp://blog.163.com/xing_aixin/blog/static/3723550520088189201623/
ÍøÉÏÓкܶàSQL ServerÊý¾Ý¿â×ÖµäµÄSQLÓï¾ä£¬ÆßÁã°ËÂ䣬ÎÒÔÚ¹¤×÷ÕûÀíÁËÒ»ÏÂ˼·£¬×ܽáSQL´úÂëÈçÏ¡£Êý¾Ý¿â×Öµä°üÀ¨±í½á¹¹(·Ö2KºÍ2005)¡¢Ë÷ÒýºÍÖ÷¼ü. Íâ¼ü.Ô¼Êø.ÊÓͼ.º¯Êý.´æ´¢¹ý³Ì.´¥·¢Æ÷¡£¿ÉÒÔÔÚÆóÒµ¹ÜÀíÆ÷¡¢²éѯ·ÖÎöÆ÷Öмòµ¥Ö´ÐУ¬Ö±½ÓÁ˵±µ ......
select
convert(char(4),auth,120)+'Äê'+
substring(convert(char(10),auth,120),6,2)+'ÔÂ'+
substring(convert(char(10),auth,120),9,2)+'ÈÕ',
convert(char(4),appr,120)+'Äê'+
substring(convert(char(10),appr,120),6,2)+'ÔÂ'+
substring(convert(char(10),appr,120),9,2)+'ÈÕ'
from a
ÒÔÉÏ´úÂëʵÏֵĹ¦Ä ......