?? 0202.htm
字號:
<html>
<head>
<title>新時代軟件教程:操作系統(tǒng) 主頁制作 服務器 設計軟件 網絡技術 編程語言 文字編輯</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
<!--
body, table {font-size: 9pt; font-family: 宋體}
a {text-decoration:none}
a:hover {color: red;text-decoration:underline}
.1 {background-color: rgb(245,245,245)}
-->
</style>
</head>
<p align="center"><script src="../../1.js"></script></a>
<p align="center"><big><strong>圖片的數(shù)據庫存儲</strong></big></p>
<div align="right">---摘自互聯(lián)網</div>
<br>import java.io.*; <br>
import java.sql.*; <br>
public class InsertBlob { <br>
public static void main(String args[]) { <br>
<br>
String username; <br>
String password; <br>
String url; <br>
String dropString; <br>
String createString; <br>
<br>
username = "system"; <br>
<br>
password = "manager"; <br>
<br>
// The URL that will connect to TECFA's MySQL server <br>
// Syntax: jdbc:TYPEachineort/DB_NAME <br>
url = "jdbcracle:thin:@cs05:1521s05"; <br>
// ---- configure END <br>
<br>
// INSTALL/load the Driver (Vendor specific Code) <br>
try { <br>
Class.forName("oracle.jdbc.driver.OracleDriver"); <br>
} catch(java.lang.ClassNotFoundException e) { <br>
System.err.print("ClassNotFoundException: "); <br>
System.err.println(e.getMessage()); <br>
} <br>
<br>
try { <br>
Connection con; <br>
Statement stmt; <br>
<br>
// Establish Connection to the database at URL with usename and password <br>
con = DriverManager.getConnection(url, username, password); <br>
System.out.println ("Ok, connection to the DB worked. Let's see if we can insert something:"); <br>
<br>
// con.setAutoCommit(false); <br>
<br>
FileInputStream fis=null; <br>
File file = new File("z.jpg"); <br>
try{ <br>
fis = new FileInputStream(file); <br>
} catch(FileNotFoundException e) {} <br>
PreparedStatement ps = con.prepareStatement("insert into binary_data values (?,?,?,?,?,?)"); <br>
ps.setInt(1,1); <br>
ps.setString(2,"櫻花"); <br>
ps.setBinaryStream(3,fis,3098); <br>
ps.setString(4,"z.jpg"); <br>
ps.setString(5,"3098"); <br>
ps.setString(6,"jpg"); <br>
ps.executeUpdate(); <br>
ps.close(); <br>
try{ <br>
fis.close(); <br>
} catch(IOException e) {} <br>
<br>
System.out.println ("Image Items have been inserted, you can now run the QueryCoffees program"); <br>
// Close resources <br>
// stmt.close(); <br>
con.close(); <br>
} <br>
// print out decent erreur messages <br>
catch(SQLException ex) { <br>
System.err.println("==> SQLException: "); <br>
while (ex != null) { <br>
System.out.println("Message: " + ex.getMessage ()); <br>
System.out.println("SQLState: " + ex.getSQLState ()); <br>
System.out.println("ErrorCode: " + ex.getErrorCode ()); <br>
ex = ex.getNextException(); <br>
System.out.println(""); <br>
} <br>
} <br>
<br>
} <br>
} <br>
</table>
<p align="center"><script src="../../2.js"></script></a>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -