public ResultSet getForMetricId(
String metricId, java.sql.Timestamp startTime, java.sql.Timestamp endTime) {
String query =
SELECT
+ "from data_point this\n where\n this.\"metric_id\" = ?\n and this.\"timestamp\" >= ?\n and this.\"timestamp\" <= ?\n order by this.\"timestamp\"";
java.sql.PreparedStatement genorm_statement = null;
try {
genorm_statement = GenOrmDataSource.prepareStatement(query);
genorm_statement.setString(1, metricId);
genorm_statement.setTimestamp(2, startTime);
genorm_statement.setTimestamp(3, endTime);
s_logger.debug(genorm_statement.toString());
ResultSet rs = new SQLResultSet(genorm_statement.executeQuery(), query, genorm_statement);
return (rs);
} catch (java.sql.SQLException sqle) {
try {
if (genorm_statement != null) genorm_statement.close();
} catch (java.sql.SQLException sqle2) {
}
if (s_logger.isDebug()) sqle.printStackTrace();
throw new GenOrmException(sqle);
}
}
/**
* Find the record with the specified primary keys
*
* @return DataPoint or null if no record is found
*/
public DataPoint find(int id) {
DataPoint rec = new DataPoint();
// Create temp object and look in cache for it
((DataPoint_base) rec).initialize(id);
rec = (DataPoint) GenOrmDataSource.getGenOrmConnection().getCachedRecord(rec.getRecordKey());
java.sql.PreparedStatement genorm_statement = null;
java.sql.ResultSet genorm_rs = null;
if (rec == null) {
try {
// No cached object so look in db
genorm_statement = GenOrmDataSource.prepareStatement(SELECT + FROM + KEY_WHERE);
genorm_statement.setInt(1, id);
s_logger.debug(genorm_statement.toString());
genorm_rs = genorm_statement.executeQuery();
if (genorm_rs.next()) rec = newDataPoint(genorm_rs);
} catch (java.sql.SQLException sqle) {
throw new GenOrmException(sqle);
} finally {
try {
if (genorm_rs != null) genorm_rs.close();
if (genorm_statement != null) genorm_statement.close();
} catch (java.sql.SQLException sqle2) {
throw new GenOrmException(sqle2);
}
}
}
return (rec);
}
/**
* 获得公司的分部
*
* @param con
* @param company_code
* @return
* @throws SQLException
*/
private static java.util.List<JUnit> getChildBranch(Connection con, String company_code)
throws SQLException {
java.util.List<JUnit> lsBranch = new java.util.ArrayList<JUnit>();
java.sql.PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = null;
sql =
"select unit_id from t_unit "
+ " where (parent_code =? or parent_code =?) and is_branch = 1 "
+ " order by unit_index ";
pstmt = con.prepareStatement(sql);
pstmt.setString(1, company_code);
pstmt.setString(2, company_code + ".LX");
rs = pstmt.executeQuery();
while (rs.next()) {
JUnit uObj = JUnit.getUnit(rs.getString("unit_id"));
lsBranch.add(uObj);
}
/*
if(lsBranch.size() == 0)
{
lsBranch.add(JUnit.getUnitByCode(company_code));
}*/
rs.close();
pstmt.close();
return lsBranch;
}
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
Map root = new HashMap();
Connection conn = null;
conn = ConFact.getInstance().makeConnection();
String id = req.getParameter("id");
String sql = "select title,description,language_id from film where film_id=" + id + ";";
java.sql.PreparedStatement pst;
try {
pst = conn.prepareStatement(sql);
ResultSet rs = pst.executeQuery();
while (rs.next()) {
java.sql.PreparedStatement pst1;
String sql1 = "select name from language where language_id=" + rs.getString(3) + ";";
pst1 = conn.prepareStatement(sql1);
ResultSet rs1 = pst1.executeQuery();
while (rs1.next()) {
Template t = cfg.getTemplate("test.ftl");
root.put("title", rs.getString(1));
root.put("description", rs.getString(2));
root.put("language", rs1.getString(1));
resp.setContentType("text/html; charset=" + t.getEncoding());
Writer out = resp.getWriter();
t.process(root, out);
}
rs1.close();
}
rs.close();
pst.close();
conn.close();
} catch (TemplateException e) {
e.printStackTrace();
} catch (SQLException e1) {
e1.printStackTrace();
}
}
public ResultSet getByMetric(String metricId) {
String query = SELECT + "FROM data_point this WHERE this.\"metric_id\" = ?";
java.sql.PreparedStatement genorm_statement = null;
try {
genorm_statement = GenOrmDataSource.prepareStatement(query);
genorm_statement.setString(1, metricId);
s_logger.debug(genorm_statement.toString());
ResultSet rs = new SQLResultSet(genorm_statement.executeQuery(), query, genorm_statement);
return (rs);
} catch (java.sql.SQLException sqle) {
try {
if (genorm_statement != null) genorm_statement.close();
} catch (java.sql.SQLException sqle2) {
}
if (s_logger.isDebug()) sqle.printStackTrace();
throw new GenOrmException(sqle);
}
}