元数据，查看表结构，存储过程，泛型

[b][/b][size=x-small][/size][color=red]//元数据的使用(DatabaseMetaData)
import java.sql.*;

import oracle.jdbc.driver.OracleDriver;

public class DatabaseConnection {
public static Connection getMysqlConnection() throws Exception {
Connection conn = null;
Class.forName("com.mysql.jdbc.Driver");// (通过反射)加载数据库驱动

conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/test", "root", "1");// 获取与数据库的连接
return conn;
}

public static Connection getOracleConnection()throws Exception {
Connection conn = null;
Class.forName("oracle.jdbc.driver.OracleDriver");// (通过反射)加载数据库驱动

conn = DriverManager.getConnection(
"jdbc:oracle:thin:@192.168.3.7:1521:wbj", "lxf", "lxf");// 获取与数据库的连接
return conn;
}
}
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.sql.Types;

public class DatabaseMetaDataTest {

public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub
Connection conn = DatabaseConnection.getOracleConnection();
DatabaseMetaData m = conn.getMetaData();

// 取出数据库中所有的表
ResultSet rs = m.getTables(null, null, null, new String[] { "TABLE" });
/* while (rs.next()) {
System.out.println("数据库中的表分别是："+rs.getString("TABLE_NAME"));
}*/

// 取出table名字为HELLOTABLE中的所有字段，名称默认全是大写
rs = m.getColumns(null, null, "STU", null);
while (rs.next()) {
System.out.print(rs.getString("COLUMN_NAME"));
int dataType = rs.getInt("DATA_TYPE");//字段类型它用数字表示，所有要比较
switch (dataType) {
case Types.VARCHAR:
System.out.print("(varchar)");
System.out.println(" ");
break;
case Types.INTEGER:
System.out.print("(int)");
System.out.println(" ");
break;
}
}

rs.close();
conn.close();


}

}


//查询表里的信息

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

public class ResultSetMetaDataTest {

public static void main(String[] args) throws Exception {

Connection conDatabase = DatabaseConnection.getOracleConnection();
// 表加载与表显示
Statement stmt = null; // 声明Statement接口
ResultSet rs = null; // 声明ResultSet接口
ResultSetMetaData dbMD = null; // 声明ResultSetMetaData接口
int intRecCount = 0;
try {
stmt = conDatabase.createStatement();
stmt.execute("Select * From STU");
rs = stmt.getResultSet();
dbMD = rs.getMetaData();
// 表区域名称
for (int i = 1; i <= dbMD.getColumnCount(); i++){
System.out.print(dbMD.getColumnName(i)+" "+dbMD.getColumnType(i));
}
System.out.println();

// 打印表内容5笔
while (rs.next()) {
for (int j = 1; j <= dbMD.getColumnCount(); j++) {
System.out.print(rs.getString(j) + " ");
}
System.out.println();
}
} catch (SQLException e) {
System.out.println("表读取失败");
e.printStackTrace();
}

}

}


//存储过程的使用
package com.jdbc.self;

/*
*

create or replace
PROCEDURE STUTEST
( did IN out int
, dname out VARCHAR2
)
AS
BEGIN
SELECT name INTO dname FROM stu
WHERE stu.id=did;
END STUTEST;
*
*
*/
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Types;

public class CallableStatementTest {

public static void main(String[] args) throws Exception {
try{
Connection conn=DatabaseConnection.getOracleConnection();
CallableStatement cs;
cs = conn.prepareCall("{call STUTEST(?,?)}");
cs.registerOutParameter(2, java.sql.Types.VARCHAR);
cs.setInt(1, 23);
cs.executeUpdate();
String name=(String)cs.getObject(2);
System.out.println(name);
cs.close();
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}

}

//范型的使用（类范型，方法范型）
//使用了范型
public static <T,V>boolean isInArray(T a,V[]b){
boolean b1=false;
for (int i = 0; i < b.length; i++) {
if(a.equals(b[i])){
return true;
}
}
return false;
}
//未使用范型
public static boolean isInArray(Object a,Object[]b){
boolean b1=false;
for (int i = 0; i < b.length; i++) {
if(a.equals(b[i])){
return true;
}
}
return false;
}


//awt
import java.awt.*;
import java.awt.Dimension;
import java.awt.Frame;
import java.awt.Toolkit;
import javax.swing.JFrame;
public class Awt {

public static void main(String[] args) {
JFrame frame = new JFrame("录晓风");
frame.setVisible(true);
frame.setBackground(Color.blue);
frame.setSize(300, 250);
// frame.setLayout(null);//取消窗体的布局管理器
frame.setLayout(new GridLayout(3,3));
Button b=new Button("确定1");
Button b1=new Button("确定2");
Button b2=new Button("确定3");
Button b3=new Button("确定4");
Button b4=new Button("确定5");
Button b5=new Button("确定2");
Button b6=new Button("确定3");
Button b7=new Button("确定4");
Button b8=new Button("确定5");
b.setBackground(Color.blue);
frame.add(b1);
frame.add(b);
frame.add(b2);
frame.add(b3);
frame.add(b4);
frame.add(b5);
frame.add(b6);
frame.add(b7);
frame.add(b8);
frame.setResizable(false);//设置窗体为不可更改大小的
//frame.pack();//根据组件动态设置窗体大小
}
}[/color]