eclipse连接oracle慢,Eclipse 中连接Oracle数据库

下面是一个Java连Oracle数据库的一个简单测试，以及在Oracle中存储图片信息

import java.awt.Container;

import java.io.InputStream;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

import javax.swing.ImageIcon;

import javax.swing.JFrame;

import javax.swing.JLabel;

class  ReadPic  extends JFrame{

public ReadPic(){

try{

/*

* 建立数据库的连接

*/

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:zgydb","jenny","888888");

Statement stmt = conn.createStatement();

/*

*执行数据查询语句

*/

ResultSet rs = stmt.executeQuery("select * from images");

rs.next();

/*

* 获取读取到的信息

*/

//String name = rs.getString(1);

int length = rs.getInt(2);

InputStream is = rs.getBinaryStream(3); //准备字节流

byte[] b = new byte[length];

is.read(b);  //读取字节信息

/*

* 显示图片

*/

ImageIcon icon = new ImageIcon(b);

Container cont = this.getContentPane();

JLabel label = new JLabel(icon);

cont.add(label);

this.setSize(300,200);

this.setLocation(300,300);

this.validate();

}catch(Exception e){

System.out.println("wrong!");

}

this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

this.setVisible(true);

}

public static void main(String args[]){

new ReadPic();

save  pic

import java.awt.FileDialog;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.io.File;

import java.io.FileInputStream;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JTextField;

public class SavePic extends JFrame implements ActionListener{

JTextField tf = new JTextField();

public SavePic(){

JButton jb = new JButton("单击选择待存储文件");

jb.addActionListener(this);

this.getContentPane().add(tf,"North");

this.getContentPane().add(jb,"South");

this.setSize(300,150);

this.setLocation(300,300);

this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

this.setVisible(true);

}

public void actionPerformed(ActionEvent arg0) {

FileDialog jf = new FileDialog(this);  //构造选择文件对话框

jf.setVisible(true);

String fname = jf.getFile();

String path = jf.getDirectory() + fname;  //获取用户所选择文件的路径

File f = new File(path);

long length = f.length();

try{

FileInputStream fis = new FileInputStream(f);  //准备文件输入流

/*

* 建立与Oracle数据库之间的连接

*/

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:zgydb","jenny","888888");

PreparedStatement pstmt = conn.prepareStatement("insert into images values(?,?,?)");

//给参数赋值

pstmt.setString(1,fname);

pstmt.setInt(2,(int)length);

pstmt.setBinaryStream(3,fis,(int)length);

//执行插入数据库的语句

pstmt.executeUpdate();

pstmt.close();

tf.setText("图片已经成功存储到数据库中！");  //显示存储成功提示信息

}catch(Exception e){

tf.setText("图片存储不成功！");  //显示存储失败提示信息

}

}

public static void main(String[] args) {

new SavePic();

}

}

}

}