Connection connection = null;
Statement statement = null;
ResultSet rs1 = null;
try{
connection = JDBC.getConnection();
statement = connection.createStatement();
rs1 = statement.executeQuery(qryStr);
int ch = 0;
StringBuffer sbf = new StringBuffer();
if (rs1.next()) {
PDNM=rs1.getString("pro_name").trim();
java.io.InputStream ins = rs1.getAsciiStream("riskpost");
if (ins != null) {
while ( (ch = ins.read()) != -1) {
sbf.append( (char) ch);
}
ins.close();
funcRemark1 = sbf.toString();
}
//new String(sbf.toString().getBytes("8859_1"), "GB2312"); //解决中文乱码问题。
}
}
}
catch(Exception ex)
{ ex.printStackTrace();
throw ex;
}finally {
JDBC.close(rs1);
JDBC.close(statement);
JDBC.close(connection);
}
Statement statement = null;
ResultSet rs1 = null;
try{
connection = JDBC.getConnection();
statement = connection.createStatement();
rs1 = statement.executeQuery(qryStr);
int ch = 0;
StringBuffer sbf = new StringBuffer();
if (rs1.next()) {
PDNM=rs1.getString("pro_name").trim();
java.io.InputStream ins = rs1.getAsciiStream("riskpost");
if (ins != null) {
while ( (ch = ins.read()) != -1) {
sbf.append( (char) ch);
}
ins.close();
funcRemark1 = sbf.toString();
}
//new String(sbf.toString().getBytes("8859_1"), "GB2312"); //解决中文乱码问题。
}
}
}
catch(Exception ex)
{ ex.printStackTrace();
throw ex;
}finally {
JDBC.close(rs1);
JDBC.close(statement);
JDBC.close(connection);
}