oracle数据库连接实例

+ db_input;
System.out.println(toOracle);
String userName =username_input;
String pwds = password_input;
con = DriverManager.getConnection(toOracle, userName, pwds);
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
judge=true;
}
PreparedStatement ps = null;
ResultSet rs = null;
ResultSetMetaData rsmd;
try {
ps = JdbcOracle.con.prepareStatement(temp);
ername_input.getText(),upper.password_input.getText());
}
});
lower.input.addActionListener(new ActionListener() {
@Override
for (int i = 1; i <= number; i++) {
String tempagain = rs.getString(rsmd
.getColumnName(i));
currentrows.addElement(tempagain);
JLabel port = new JLabel("PORT:");
JLabel db = new JLabel("DB Name:");
JLabel username=new JLabel("USERNAME:");
JLabel password=new JLabel("PASSWORD:");
import java.sql.ResultSetMetaData;
import java.util.Vector;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
setLayout(new GridLayout(3, 0,0,5));
add(upper);
add(lower);
add(jsb);
setSize(400, 400);
lower.connect.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
if(JdbcOracle.con==null){
rmation.setText("请先连接数据库！");
return;
}
String temp = Lower.input.getText().trim();
System.out.println(temp);
if (ps.execute()) {
System.out.println("查询");
rs = ps.getResultSet();
rsmd = rs.getMetaData();
}
} catch (Exception ex) {
rmation.setText("操作数据库失败！");
}
}
});
}
public void paint(Graphics g){
Dimension d=size();
Lower lower = new Lower();
Upper upper = new Upper();
JTable jt = new JTable();
JScrollPane jsb = new JScrollPane();
Visualize() {
setTitle("Demo");
Border etched=BorderFactory.createEtchedBorder();
jsb.setBorder(etched);
add(jsb);
validate();
Lower.input.requestFocus();
int number = rsmd.getColumnCount();
Vector colums = new Vector();
Vector rows = new Vector();
for (int i = 1; i <= number; i++) {
import java.sql.Statement;
import javax.swing.*;
import javax.swing.border.Border;
public class OracleConnectionTool {
public static void main(String[] args) {
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:");
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;
rmation.setText("操作数据库成功！");
}
else {
System.out.println("执行");
Lower.input.requestFocus();
rmation.setText("操作数据库成功！");
colums.addElement(rsmd.getColumnName(i));
}
// rows.addElement(colums);
if(judge==false){
while (rs.next()) {
Vector currentrows = new Vector();
}
rows.addElement(currentrows);
}
}
remove(jsb);
jt = new JTable(rows, colums);
jsb = new JScrollPane(jt);
@Override
public void actionPerformed(ActionEvent e) {
JdbcOracle jd = new JdbcOracle(upper.ip_input.getText(),
upper.port_input.getText(), upper.db_input.getText(),
static JTextField username_input = new JTextField("scott");
static JPasswordField password_input = new JPasswordField("tiger");
Upper() {
Border etched=BorderFactory.createEtchedBorder();
} catch (Exception e) {
rmation.setText("数据库连接失败！");
}
}
public static id main(String[] args) {
}
}
class Visualize extends JFrame {
Visualize vis = new Visualize();
vis.setVisible(true);
Lower.input.requestFocus();
vis.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
}
class JdbcOracle {
Lower.input.requestFocus();
rmation.setText("");
rmation.setText("数据库连接成功！");
// System.out.println(Lower.input.getText());
temp=temp.substring(0,temp.length()-1);