精品久久久久亚洲,欧美精品久久久久久 ,91wwwcom在线观看

Insert text file into MySQL

import? java.io.File;
import? java.io.FileInputStream;
import? java.sql.Connection;
import? java.sql.DriverManager;
import? java.sql.PreparedStatement;

public?class? InsertTextFileToMySQL? {

?? public?static? Connection?getConnection ()? throws? Exception? {
???? String?driver?=? "org.gjt.mm.mysql.Driver" ;
???? String?url?=? "jdbc:mysql://localhost/databaseName" ;
???? String?username?=? "root" ;
???? String?password?=? "root" ;

???? Class .forName ( driver ) ;
???? Connection?conn?=?DriverManager.getConnection ( url,?username,?password ) ;
???? return? conn;
?? }

?? public?static? void? main ( String []? args ) throws? Exception? {
???? String?id?=? "001" ;
???? String?fileName?=? "fileName.txt" ;
????
???? FileInputStream?fis?=? null ;
???? PreparedStatement?pstmt?=? null ;
???? Connection?conn?=? null ;
???? try? {
?????? conn?=?getConnection () ;
?????? conn.setAutoCommit ( false ) ;
?????? File?file?=? new? File ( fileName ) ;
?????? fis?=? new? FileInputStream ( file ) ;
?????? pstmt?=?conn.prepareStatement ( "insert?into?DataFiles(id,?fileName,?fileBody)?values?(?,??,??)" ) ;
?????? pstmt.setString ( 1 ,?id ) ;
?????? pstmt.setString ( 2 ,?fileName ) ;
?????? pstmt.setAsciiStream ( 3 ,?fis,? ( int )? file.length ()) ;
?????? pstmt.executeUpdate () ;
?????? conn.commit () ;
???? }? catch? ( Exception?e )?{
?????? System.err.println ( "Error:?"? +?e.getMessage ()) ;
?????? e.printStackTrace () ;
???? }? finally? {
?????? pstmt.close () ;
?????? fis.close () ;
?????? conn.close () ;
???? }
?? }
}

posted on 2006-09-13 11:33 zhaofei1394 閱讀(668) 評論(0) 編輯收藏所屬分類: SQL Server

新用戶注冊刷新評論列表


只有注冊用戶登錄后才能發表評論。




網站導航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關文章: Insert text file into MySQL 一個簡單的存儲過程！ CREATE PROCEDURE 在SQL中使用convert函數進行日期的查詢

Jody

Insert text file into MySQL

導航

統計

常用鏈接

留言簿(1)

隨筆分類

隨筆檔案

文章分類

文章檔案

友情鏈接

搜索

最新評論

閱讀排行榜

評論排行榜