티스토리 뷰

어플리케이션

JDBC 샘플 코드

쌀맛나는세상 2009. 6. 18. 01:05


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

public class testJdbc {

	static public final String driver = "oracle.jdbc.driver.OracleDriver";
	static public final String connection = "jdbc:oracle:thin:@192.168.159.129:1521:quarkdb";
	static public final String user = "system";
	static public final String password = "oracle";

	//	
	// static public final String driver = "com.mysql.jdbc.Driver";
	// static public final String connection =
	// "jdbc:mysql://localhost:3306/komal";
	// static public final String user = "root";
	// static public final String password = "root";

	public static void main(String args[]) {

		try {
			Class.forName(driver);
			Connection con = DriverManager.getConnection(connection, user,
					password);

			Statement st = con.createStatement();

			String sql = "select * from aaa";
			ResultSet rs = st.executeQuery(sql);
			ResultSetMetaData metaData = rs.getMetaData();

			int rowCount = metaData.getColumnCount();

			System.out.println("Table Name : " + metaData.getTableName(2));
			System.out.println("Field  \tsize\tDataType");

			for (int i = 0; i < rowCount; i++) {
				System.out.print(metaData.getColumnName(i + 1) + "  \t");
				System.out.print(metaData.getColumnDisplaySize(i + 1) + "\t");
				System.out.println(metaData.getColumnTypeName(i + 1));
			}

			DatabaseMetaData dbmd = con.getMetaData();

			ResultSet tableRs = dbmd.getTables(null, null, null, null);
			if (tableRs.next()) {
				metaData = tableRs.getMetaData();
				rowCount = metaData.getColumnCount();

				
				for (int i = 0; i < rowCount; i++) {
					System.out.print(metaData.getColumnName(i + 1) + "  \t");
					System.out.print(metaData.getColumnDisplaySize(i + 1)
							+ "\t");
					System.out.println(metaData.getColumnTypeName(i + 1));
				}
			}
		} catch (Exception e) {
			System.out.println(e);
		}
	}
}