java´æ´¢Í¼Æ¬µ½Êý¾Ý¿â
1 mysql´æ´¢´óÈÝÁ¿µÄ¶þ½øÖÆÎļþµÄ¸ñʽÊÇblob£¬Æäʵ³ýÁËͼƬ»¹¿ÉÒÔ´æ±ðµÄ
2 ÒªÏòÊý¾Ý¿â´æ´¢¶þ½øÖƵÄÎļþÒ»¶¨Òª°ÑÒª´æ´¢µÄÊý¾Ýת»»³É¶þ½øÖÆÁ÷
·Ï»°¾Í²»¶à˵ÁË£¬´ó¼Ò¿´¿´´úÂëºÜÈÝÒ×Ã÷°×£¬ÏÈÀ´¿´Ò»¸öapp³ÌÐò£¬µ±È»Ê×ÏÈÄúÒªÔÚÊý¾Ý¿âÖÐÏȽ¨Á¢Ò»¸öÓÃÓÚ±£´æÍ¼Æ¬µÄ±íºÍÏàÓ¦µÄÁУ¬Êý¾Ý¸ñʽΪblob
package com.lizhe;
import java.io.*;
import java.sql.*;
public class PutImg {
public void putimg() {
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url = "jdbc:mysql://localhost/img?user=root&password=root&useUnicode=true&characterEncoding=gbk";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
//stmt.execute("insert into imgt (id) values (5)");
stmt.close();
PreparedStatement pstmt = null;
String sql = "";
File file = new File("c:\\blog.jpg");
InputStream photoStream = new FileInputStream(file);
//sql = " UPDATE imgt SET img = ? ";
sql = "INSERT INTO imgtable (img) VALUES (?)";
pstmt = conn.prepareStatement(sql);
pstmt.setBinaryStream(1, photoStream, (int) file.length());
pstmt.executeUpdate();
pstmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String args[]){
PutImg pi=new PutImg();
pi.putimg();
}
}
InputStream photoStream = new FileInputStream(file);
¿ÉÒÔºÜÇå³þµÄ¿´µ½ÎÒÃÇÊ×ÏȰÑÒ»¸öͼƬÎļþ(µ±È»Ò²¿ÉÒÔÊDZðµÄʲôÎļþ)ת»»³ÉÁËÒ»¸ö¶þ½øÖÆÊäÈëÁ÷
pstmt.setBinaryStream(1, photoStream, (int) file.length());
Õâ¸ö·½·¨½¨Òé´ó¼ÒÈ¥²éÒ»ÏÂAPIÎĵµ,µÚÒ»¸ö²ÎÊýÊÇͨÅä·ûλÖÃûµÄ˵,µÚ¶þ¸ö²ÎÊýÊÇÁ÷,ÕâºÍÒÔÍùµÄstringÀàÐ͵IJÎÊý²»Ì«Ò»Ñù,ÎÒ¸Õ¿´µ½µÄÊ
Ïà¹ØÎĵµ£º
1.String str = new String("abc"); ÇëÎʶ¨ÒåÁ˼¸¸ö¶ÔÏó¡£¶¨ÒåÁËÁ½¸ö¶ÔÏó£¬Ò»¸ö"abc", Ò»¸öÊÇnew String().<String s = "abc";Ê×Ïȵ½¶ÑÖвéÕÒֵΪ"abc"µÄ¶ÔÏó£¬Ã»ÓоÍн¨Ò»¸ö¶ÔÏó£¬"abc"±¾Éí¾ÍÊÇÒ»¸ö¶ÔÏó¡£>
2.ÃæÏò¶ÔÏóµÄ¶«Î÷£ºabstract & interfaceµÄ¸÷×ÔµÄ×÷Óã¬Çø±ð¡£
3.ÃæÏò¶ÔÏóµÄÌØÕ÷£¬ÒÔ¼°ÔõôʵÏֵġ£1 ......
¶ÔÏó³Ö¾Ã»¯£¬Ò²¾ÍÊÇ¿ÉÒÔ°ÑÕâ¸ö¶ÔÏóÓÀÔ¶µÄ±£´æÆðÀ´£¬ÕâÀïµÄ±£´æ²»½öÊǶÔÏó±¾Éí£¬»¹°üÀ¨ËûµÄÊôÐÔºÍËùÒÀÀµµÄÆäËûÀࡣͨ³££¬¶ÔÏó¿ÉÒԳ־û¯µ½Îļþ»òÕßÊÇÊý¾Ý¿âÖС£ÎÒÕâÀïÖ»½éÉÜÈçºÎ½«¶ÔÏó´æ´¢µ½Êý¾Ý¿âÖС£Ç¡ÇÉOracleÊý¾Ý¿âΪÎÒÃÇÌṩÁËÕâÑùµÄ·½±ã¡£
ÔÚOracleÖУ¬ÓÐÒ»ÖÖblogµÄ×Ö¶ÎÀàÐÍ£¬ËüÊÇÓÃÀ´´æ´¢´óÁ¿µÄ¶ ......
ת×Ô£ºhttp://gyhgc.javaeye.com/blog/225039
ÔÚÈí¼þ¿ª·¢µÄ¹ý³ÌÖÐ×ÜÊÇÇ¿µ÷×¢Ê͵Ĺ淶£¬µ«ÊÇûÓÐÒ»¸ö¾ßÌåµÄ±ê×¼½øÐÐ˵Ã÷£¬Í¨³£¶¼ÊÇÔÚ´úÂë±àд¹æ·¶Öмòµ¥µÄÃèÊö¼¸¾ä£¬²»ÄÜ×÷Ϊһ¸ö´úÂë×¢Êͼì²éµÄ±ê×¼ºÍÒÀ¾Ý£¬×öʲô¶¼ÒªÓÐÒ»¸öÒÀ¾ÝÂð:),ÏÖÔÚÎÒÌØÕûÀíÁËÒ»¸ö¡¶JavaµÄ×¢Ê͹淶¡·£¬ÄÚÈÝÀ´×ÔÍøÂç¡¢Êé¼®ºÍ×Ô¼ºµÄ ......
Action×¢½âÅäÖÃ
ʹÓ÷½Ê½ÈçÏ£º
Java´úÂë
@ParentPackage(value="struts-default")
@Namespace(value="/test")
@Result(name="success",value="/userSuc.jsp")
@Results({
@Result(name="success",value="/userSu ......
import java.io.BufferedInputStream;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
public class RunDosCommand {
public static void main(String[] args) throws IOException {
String cmd = "ipconfig";
R ......