JDBC 关于通用查询

关于通用查询

package test20140213;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * 
 * @author shihuafu
 *
 */
public class Query {

	//select
	public static void query(String TableName,Connection ConnName) throws SQLException {
		Connection conn = null;
		PreparedStatement pstmt1 = null;
		PreparedStatement pstmt2 = null;
		ResultSet rs1 = null;
		ResultSet rs2 = null;
		String sql1 = "select count(1) from all_tab_columns where table_name= upper('"+TableName+"')";
//		String sql3 = "select column_name from all_tab_columns where table_name= upper('"+TableName+"')";
		String sql2 = "select * from "+TableName+"";
		try {
			conn = ConnName;//数据库连接对象
			//用于执行sql语句的对象
			pstmt1 = conn.prepareStatement(sql1);
			pstmt2 = conn.prepareStatement(sql2);
			rs1 = pstmt1.executeQuery();///结果集
			rs2 = pstmt2.executeQuery();///结果集
			while(rs1.next()){
				int count = rs1.getInt(1);
				
				while(rs2.next()){
					System.out.print("{");
					for(int i = 1;i <= count; i++){
						System.out.print("'"+rs2.getString(i)+"'");
					}	
					System.out.print("}");
					System.out.println();
				}
			}

		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			rs1.close();
			pstmt1.close();
			rs2.close();
			pstmt2.close();
			conn.close();
		}
	}
	
	public static void main(String[] args) throws SQLException {
		query("tbl_lztest",DBConnDev.getConn());
	}

}

关于Oracle连接

package test20140213;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
 * 
 * @author shihuafu
 *
 */
public class DBConnInt {
	//public static String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	public static String driverName = "oracle.jdbc.driver.OracleDriver";
	//public static String url = "jdbc:sqlserver://127.0.0.1:1434;DatabaseName=member";
    //public static String url = "jdbc:oracle:thin:@10.10.164.83:1521:pdserver";
	public static String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
	public static String username="scott";
	public static String password="shihua";
	
	public static Connection getConn(){
		Connection conn = null;
		if (conn==null) {
			try {
				Class.forName(driverName);
				conn = DriverManager.getConnection(url,username,password);				
			} catch (ClassNotFoundException e) {
				System.out.println("jar包可能未导入");
			}catch (SQLException e) {
				System.out.println("请检查数据库url和用户名密码");
			}
		}
		return conn;
	}	

	public static void main(String[] args) {
		System.out.println(getConn());
	}
}