package lj_cust;

import java.io.*;
import java.text.*;
import java.sql.*;
import oracle.jdbc.driver.*;

public class wtpart_sql_chk2csv3 {

	public wtpart_sql_chk2csv3() { }

	public static void main(String[] args) throws Exception{
		try {
			Connection conn = null;
			try {
				Class.forName("oracle.jdbc.driver.OracleDriver");
				conn = DriverManager.getConnection("jdbc:oracle:thin:@LARRYServer:1521:wind","system","manager");

				Statement stmt = conn.createStatement();
				ResultSet rs = stmt.executeQuery("select WTPARTNUMBER,NAME from wcuser.WTPARTMASTER "+
				"where WTPARTNUMBER LIKE '%.DRW' or WTPARTNUMBER LIKE '%.drw' Or "+
				"WTPARTNUMBER LIKE '%.ASM' or WTPARTNUMBER LIKE '%.asm' Or "+
				"WTPARTNUMBER LIKE '%.PRT' or WTPARTNUMBER LIKE '%.prt' "+
				"order by WTPARTNUMBER");

				ResultSetMetaData rm = rs.getMetaData();
				int cols = rm.getColumnCount();

				//System.out.println("<TABLE CELLSPACING=\"2\" CELLPADDING=\"5\" BORDER=\"1\">");

				//System.out.println("<TR>");
				for(int j=1; j<=cols; j++) {
					//System.out.println("<TD>" + rm.getColumnName(j) + "</TD>"); }
					if (j < cols) {
						System.out.print(rm.getColumnName(j) + ",");
					}
					else {
						System.out.println(rm.getColumnName(j));
					}
				}
				//System.out.println("</TR>");

				while(rs.next()){
					//System.out.println("<TR>");
					for(int i=1; i<=cols;i++){
						//System.out.println("<TD>" + rs.getString(i) + "</TD>");
						if (i < cols) {
							System.out.print(rs.getString(i) + ",");
						}
						else {
							System.out.println(rs.getString(i));
						}
					}
					//System.out.println("</TR>");
				}
				//System.out.println("</TABLE>");
			}
			catch(SQLException e) {
				System.out.println("SQLException: " + e.getMessage() + "<BR>");
				while((e = e.getNextException()) != null)
				System.out.println(e.getMessage() + "<BR>");
			}
			catch(ClassNotFoundException e){
				System.out.println("ClassNotFoundException: " + e.getMessage() + "<BR>");
			}
			finally {
				if(conn != null){
					try {
						conn.close();
					}
					catch (Exception ignored) {}
				}
			}
		}
		catch (Exception e){ }
	}
}