oracle数据库连接实例

import java.awt.BorderLayout;

import java.awt.Choice;

import java.awt.Dimension;

import java.awt.Event;

import java.awt.Graphics;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.GridLayout;

import java.awt.Insets;

import java.awt.TextField;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.ItemEvent;

import java.awt.event.ItemListener;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.util.Vector;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.Statement;

import javax.swing.*;

import javax.swing.border.Border;

public class OracleConnectionTool {

public static void main(String[] args) {

Visualize vis = new Visualize();

vis.setVisible(true);

Lower.input.requestFocus();

vis.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

}

}

class JdbcOracle {

static Connection con = null;

String toOracle = null;

JdbcOracle(String ip_input, String port_input, String db_input,String username_input,String password_input) {

try {

String name = "oracle.jdbc.driver.OracleDriver";

Class.forName(name);

toOracle = "jdbc:oracle:thin:@" + ip_input + ":" + port_input + ":"

+ db_input;

System.out.println(toOracle);

String userName =username_input;

String pwds = password_input;

con = DriverManager.getConnection(toOracle, userName, pwds);

Lower.input.requestFocus();

Lower.information.setText("");

Lower.information.setText("数据库连接成功！");

//System.out.println(Lower.input.getText());

} catch (Exception e) {

Lower.information.setText("数据库连接失败！");

}

}

public static void main(String[] args) {

}

}

class Visualize extends JFrame {

Lower lower = new Lower();

Upper upper = new Upper();

JTable jt = new JTable();

JScrollPane jsb = new JScrollPane();

Visualize() {

setTitle("Demo");

setLayout(new GridLayout(3, 0,0,5));

add(upper);

add(lower);

add(jsb);

setSize(400, 400);

lower.connect.addActionListener(new ActionListener() {

@Override

public void actionPerformed(ActionEvent e) {

JdbcOracle jd = new JdbcOracle(upper.ip_input.getText(),

upper.port_input.getText(), upper.db_input.getText(),

upper.username_input.getText(),upper.password_input.getText());

}

});

lower.input.addActionListener(new ActionListener() {

@Override

public void actionPerformed(ActionEvent e) {

if(JdbcOracle.con==null){

Lower.information.setText("请先连接数据库！");

return;

}

String temp = Lower.input.getText().trim();

temp=temp.substring(0,temp.length()-1);

boolean judge=false;

if(temp.startsWith("desc")){

String[] ss=temp.split(" ");

temp="select * from "+ss[1];

judge=true;

}

PreparedStatement ps = null;

ResultSet rs = null;

ResultSetMetaData rsmd;

try {

ps = JdbcOracle.con.prepareStatement(temp);

System.out.println(temp);

if (ps.execute()) {

System.out.println("查询");

rs = ps.getResultSet();

rsmd = rs.getMetaData();

int number = rsmd.getColumnCount();

Vector colums = new Vector();

Vector rows = new Vector();

for (int i = 1; i <= number; i++) {

colums.addElement(rsmd.getColumnName(i));

}

//rows.addElement(colums);

if(judge==false){

while (rs.next()) {

Vector currentrows = new Vector();

for (int i = 1; i <= number; i++) {

String tempagain = rs.getString(rsmd

.getColumnName(i));

currentrows.addElement(tempagain);

}

rows.addElement(currentrows);

}

}

remove(jsb);

jt = new JTable(rows, colums);

jsb = new JScrollPane(jt);

Border etched=BorderFactory.createEtchedBorder();

jsb.setBorder(etched);

add(jsb);

validate();

Lower.input.requestFocus();

lower.information.setText("操作数据库成功！");

}

else {

System.out.println("执行");

Lower.input.requestFocus();

lower.information.setText("操作数据库成功！");

}

} catch (Exception ex) {

lower.information.setText("操作数据库失败！");

}

}

});

}

public void paint(Graphics g){

Dimension d=size();

g.drawRect(0,0,d.width-1,d.height-1);

}

public Insets insets() {

return new Insets(35, 5, 5, 5); }

}

class Upper extends JPanel {

JLabel ip = new JLabel("IP:");

JLabel port = new JLabel("PORT:");

JLabel db = new JLabel("DB Name:");

JLabel username=new JLabel("USERNAME:");

JLabel password=new JLabel("PASSWORD:");

static JTextField ip_input = new JTextField("127.0.0.1");

static JTextField port_input = new JTextField("1521");

static JTextField db_input = new JTextField("MIS");

static JTextField username_input = new JTextField("scott");

static JPasswordField password_input = new JPasswordField("tiger");

Upper() {

Border etched=BorderFactory.createEtchedBorder();

setBorder(etched);

GridBagConstraints c = new GridBagConstraints();

GridBagLayout gridbag = new GridBagLayout();

setLayout(gridbag);

c.fill = GridBagConstraints.BOTH;

c.gridwidth = 1;

c.weightx = 1.0;

gridbag.setConstraints(ip, c);

add(ip);

c.gridwidth = GridBagConstraints.REMAINDER;

gridbag.setConstraints(ip_input, c);

add(ip_input);

c.gridwidth = 1;

gridbag.setConstraints(port, c);

add(port);

c.gridwidth = GridBagConstraints.REMAINDER;

gridbag.setConstraints(port_input, c);

add(port_input);

c.gridwidth = 1;

gridbag.setConstraints(db, c);

add(db);

c.gridwidth = GridBagConstraints.REMAINDER;

gridbag.setConstraints(db_input, c);

add(db_input);

c.gridwidth = 1;

gridbag.setConstraints(username, c);

add(username);

c.gridwidth = GridBagConstraints.REMAINDER;

gridbag.setConstraints(username_input, c);

add(username_input);

c.gridwidth = 1;

gridbag.setConstraints(password, c);

add(password);

c.gridwidth = GridBagConstraints.REMAINDER;

gridbag.setConstraints(password_input, c);

add(password_input);

}

// public void paint(Graphics g){

// super.paint(g);

// Dimension d=size();

// g.drawRect(0,0,d.width-1,d.height-1); }

//

public Insets insets() {

return new Insets(5, 5, 5, 10);

}

}

class Lower extends JPanel {

JButton connect = new JButton("连接");

static JTextField input = new JTextField(); // 全局变量，获得sql语句

JComboBox choose = new JComboBox();

static JLabel information = new JLabel("");

Lower() {

Border etched=BorderFactory.createEtchedBorder();

setBorder(etched);

GridBagConstraints c = new GridBagConstraints();

GridBagLayout gridbag = new GridBagLayout();

setLayout(gridbag);

c.fill = GridBagConstraints.BOTH;

c.weightx = 1.0;

String[] info = { "建表