package com.test.j1.db_test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;
import com.sybase.jdbc4.jdbc.SybDriver;
public class SybaseDAO {
private static Logger logger = LogManager.getLogger(SybaseDAO.class);
Connection conn;
public SybaseDAO() {
String host = "kwon";
String url = "jdbc:sybase:Tds:" + host + ":5000";
String username = "root";
String password = "";
SybDriver sybDriver = null;
sybDriver = new SybDriver();
try {
conn = DriverManager.getConnection(url, username, password);
Statement stmt = conn.createStatement();
rs.next();
System.out.println(rs.getString(1));
}
catch (SQLException e) {
logger.error("Can't open datebase connection", e);
}
}
public List<PatAlterRow> getTableJ1() {
ResultSet resultSet;
boolean hasNext;
List<PatAlterRow> resultList = new ArrayList<PatAlterRow>();
try {
Statement stmt = conn.createStatement();
resultSet = stmt.executeQuery("select * from tss_test..MV_ERG_J1_PATALTER_2");//all tables from db: select name from sysobjects where type= 'U'
hasNext = resultSet.next();
try {
while (hasNext) {
PatAlterRow patAlterRow = new PatAlterRow(resultSet.getString(1), resultSet.getString(2), resultSet.getInt(3), resultSet.getInt(4));
resultList.add(patAlterRow);
hasNext = resultSet.next();
}
}
catch(SQLException e){
logger.error("error in line");
throw e;
}
} catch (SQLException e) {
logger.error("Can't open datebase connection", e);
}
return resultList;
}
}