127 lines
3.5 KiB
Plaintext
127 lines
3.5 KiB
Plaintext
package th.co.muangthai.endrprint.util.dbfactory;
|
|
|
|
/**
|
|
* Created by IntelliJ IDEA.
|
|
* User: ZIZU
|
|
* Date: 4/25/13
|
|
* Time: 4:01 PM
|
|
* To change this template use File | Settings | File Templates.
|
|
*/
|
|
import java.sql.Connection;
|
|
import java.sql.ResultSetMetaData;
|
|
import java.sql.DriverManager;
|
|
import java.sql.ResultSet;
|
|
import java.sql.Statement;
|
|
import java.util.ArrayList;
|
|
import java.util.List;
|
|
|
|
public class Dbms {
|
|
|
|
// Oracle 10g
|
|
// private static String driverClass = "oracle.jdbc.driver.OracleDriver";
|
|
// private static String url = "jdbc:oracle:thin:@10.80.1.132:1521:thpostdb";
|
|
// private static String username = "hr_owner1";
|
|
// private static String password = "passw0rd";
|
|
|
|
|
|
protected static String driverClass = "oracle.jdbc.driver.OracleDriver";
|
|
protected static String url = "jdbc:oracle:thin:@10.80.1.157:1521:tpbi";
|
|
protected static String username = "tpstat";
|
|
protected static String password = "passw0rd";
|
|
// private static List<String> listOfTable = new ArrayList<String>();
|
|
private Connection conn = null;
|
|
|
|
public Dbms()
|
|
{
|
|
|
|
}
|
|
|
|
public Dbms(String host, String sid, String username, String password)
|
|
{
|
|
this.username = username;
|
|
this.password = password;
|
|
this.url = "jdbc:oracle:thin:@" + host + ":1521:" + sid;
|
|
|
|
}
|
|
|
|
public Connection getConnection() {
|
|
try {
|
|
Class.forName(driverClass);
|
|
conn = DriverManager.getConnection(url, username, password);
|
|
} catch (Exception e) {
|
|
e.printStackTrace();
|
|
}
|
|
return conn;
|
|
}
|
|
|
|
public void Close() {
|
|
try {
|
|
conn.close();
|
|
} catch (Exception e) {
|
|
e.printStackTrace();
|
|
}
|
|
}
|
|
|
|
public static void gen() {
|
|
List<String> listOfTable = new ArrayList<String>();
|
|
|
|
String t = "MA_ORG_QUANTITY_JOB";
|
|
String sql = " select * from " + t;
|
|
try {
|
|
Connection conn = null;
|
|
Class.forName(driverClass);
|
|
conn = DriverManager.getConnection(url, username, password);
|
|
Statement stmt = conn.createStatement();
|
|
|
|
ResultSet rs =
|
|
stmt.executeQuery(sql);
|
|
System.out.println();
|
|
ResultSetMetaData rsmd = rs.getMetaData();
|
|
System.out.println("Table >>>>" + t);
|
|
|
|
for (int i = 1; i < rsmd.getColumnCount() + 1; i++) {
|
|
String col = rsmd.getColumnName(i);
|
|
String type = rsmd.getColumnTypeName(i);
|
|
|
|
// System.out.println("dbms : " + type + " " + col);
|
|
// System.out.println("bean :" + new Programs().getType(type) + " " + new Programs().nameBean(col));
|
|
|
|
}
|
|
|
|
|
|
rs.close();
|
|
stmt.close();
|
|
conn.close();
|
|
} catch (Exception e) {
|
|
e.printStackTrace();
|
|
}
|
|
}
|
|
|
|
public List<String> getTable() throws Exception {
|
|
|
|
List<String> listOfTable = new ArrayList<String>();
|
|
|
|
String sql = " select * from tab t order by t.tname";
|
|
try {
|
|
Connection conn = null;
|
|
Class.forName(driverClass);
|
|
conn = DriverManager.getConnection(url, username, password);
|
|
Statement stmt = conn.createStatement();
|
|
ResultSet rs = stmt.executeQuery(sql);
|
|
|
|
while (rs.next()) {
|
|
listOfTable.add(rs.getString("TNAME"));
|
|
}
|
|
|
|
rs.close();
|
|
stmt.close();
|
|
conn.close();
|
|
} catch (Exception e) {
|
|
throw e;
|
|
}
|
|
|
|
return listOfTable;
|
|
}
|
|
}
|
|
|