// trained data
void trainedWeights() {
weightUpdate.clear();
try {
String line;
FileReader fileReader = new FileReader("WeightFile.txt");
BufferedReader bufferedReader = new BufferedReader(fileReader);
while ((line = bufferedReader.readLine()) != null) {
String[] lineSplit = line.split(" ");
weightUpdate.put(
weightKey(Integer.parseInt(lineSplit[0]), Integer.parseInt(lineSplit[1])),
Double.parseDouble(lineSplit[2]));
}
bufferedReader.close();
} catch (FileNotFoundException ex) {
System.out.println("File Reading Error");
} catch (IOException ex) {
System.out.println("Error reading to file ");
}
}
public void getSavedLocations() {
// System.out.println("inside getSavedLocations"); //CONSOLE * * * * * * * * * * * * *
loc.clear(); // clear locations. helps refresh the list when reprinting all the locations
BufferedWriter f = null; // just in case file has not been created yet
BufferedReader br = null;
try {
// attempt to open the locations file if it doesn't exist, create it
f =
new BufferedWriter(
new FileWriter("savedLocations.txt", true)); // evaluated true if file does not exist
br = new BufferedReader(new FileReader("savedLocations.txt"));
String line; // each line is one index of the list
loc.add("Saved Locations");
// loop and read a line from the file as long as we don't get null
while ((line = br.readLine()) != null)
// add the read word to the wordList
loc.add(line);
} catch (IOException e) {
e.printStackTrace();
} finally {
try {
// attempt the close the file
br.close(); // close bufferedwriter
} catch (IOException ex) {
ex.printStackTrace();
}
}
}
public Duder(String args[]) {
getConnected(args);
play();
try {
sin.close();
sout.close();
s.close();
} catch (IOException e) {
System.out.println(e);
}
}
private CIJob getJob(ApplicationInfo appInfo) throws PhrescoException {
Gson gson = new Gson();
try {
BufferedReader br = new BufferedReader(new FileReader(getCIJobPath(appInfo)));
CIJob job = gson.fromJson(br, CIJob.class);
br.close();
return job;
} catch (FileNotFoundException e) {
S_LOGGER.debug(e.getLocalizedMessage());
return null;
} catch (com.google.gson.JsonParseException e) {
S_LOGGER.debug("it is already adpted project !!!!! " + e.getLocalizedMessage());
return null;
} catch (IOException e) {
S_LOGGER.debug(e.getLocalizedMessage());
return null;
}
}
public static void main(String[] args) throws Exception {
// set up our flags and our input and output streams based on the
// command-line arguments (exceptions generated here will propagate out
// to the environment)
BufferedReader in = null;
PrintWriter out = null;
boolean writeNewFile = false;
boolean doThrow = true;
for (int i = 0; i < args.length; i++) {
if (args[i].equals("-w")) {
writeNewFile = true;
doThrow = false;
} else if (args[i].equals("-nothrow")) doThrow = false;
else if (args[i].equals("-s") && in == null)
in = new BufferedReader(new EscapeReader(new InputStreamReader(System.in, "ISO8859_1")));
else if (!args[i].startsWith("-") && in == null)
in =
new BufferedReader(
new EscapeReader(new InputStreamReader(new FileInputStream(args[i]), "ISO8859_1")));
}
if (in == null) {
File localeData = new File(System.getProperty("test.src", "."), "LocaleData");
in =
new BufferedReader(
new EscapeReader(
new InputStreamReader(new FileInputStream(localeData), "ISO8859_1")));
}
out = new PrintWriter(new EscapeWriter(new OutputStreamWriter(System.out, "ISO8859_1")), true);
// perform the actual test
int errorCount = doTest(in, out, writeNewFile);
// write out the error count, and throw an exception out into the environment
// if there were any errors
if (errorCount != 0) {
if (!writeNewFile) out.println("Test failed. " + errorCount + " errors.");
if (doThrow) throw new Exception("Test failed. " + errorCount + " errors.");
} else if (!writeNewFile) out.println("Test passed.");
in.close();
out.close();
}
public List<CIJob> getJobs(ApplicationInfo appInfo) throws PhrescoException {
S_LOGGER.debug("GetJobs Called!");
try {
boolean adaptedProject = adaptExistingJobs(appInfo);
S_LOGGER.debug("Project adapted for new feature => " + adaptedProject);
Gson gson = new Gson();
BufferedReader br = new BufferedReader(new FileReader(getCIJobPath(appInfo)));
Type type = new TypeToken<List<CIJob>>() {}.getType();
List<CIJob> jobs = gson.fromJson(br, type);
br.close();
return jobs;
} catch (FileNotFoundException e) {
S_LOGGER.debug("FileNotFoundException");
return null;
} catch (IOException e) {
S_LOGGER.debug("IOException");
throw new PhrescoException(e);
}
}
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
res.setContentType("text/html");
PrintWriter out = res.getWriter();
int i, j;
String amount = req.getParameter("amount");
String from = req.getParameter("from");
String to = req.getParameter("to");
String ch = req.getParameter("choice");
String answer, answer1, answer2, answer3;
if ("INFO".equals(ch)) {
Redirect_info newurl = (Redirect_info) getServletContext().getAttribute("redirect");
res.sendRedirect(newurl.getUrl());
} else {
out.println("<html>");
out.println("<title>Currency Converter</title>");
String addr = "http://www.google.com/ig/calculator?hl=en&q=" + amount + from + "=?" + to;
URL convert = new URL(addr);
BufferedReader in = new BufferedReader(new InputStreamReader(convert.openStream()));
answer = in.readLine();
answer = new String(answer.getBytes("ISO-8859-1"), "ISO-8859-7");
from = new String(from.getBytes("ISO-8859-1"), "ISO-8859-7");
to = new String(to.getBytes("ISO-8859-1"), "ISO-8859-7");
amount = new String(amount.getBytes("ISO-8859-1"), "ISO-8859-7");
in.close();
i = answer.indexOf('"');
answer = answer.substring(i + 1);
i = answer.indexOf('"');
answer = answer.substring(i + 1);
i = answer.indexOf('"');
answer = answer.substring(i + 1);
i = answer.indexOf('"');
answer = answer.substring(0, i);
out.println("<p ALIGN=CENTER>" + amount + " " + from + " == " + answer + "(" + to + ")</p>");
out.println("</body>");
out.println("</html>");
}
}
public void run(String arg) {
GenericDialog gd = new GenericDialog("Options");
double sfreq = 20000.0;
gd.addNumericField("Sampling Frequency?", sfreq, 1, 10, null);
String[] psfchoice = {"3D Gaussian", "Gaus-Lorentz^2", "2D Gaussian"};
gd.addChoice("PSF Type?", psfchoice, psfchoice[0]);
String[] filetypechoice = {
"Confocor 3 raw", "Short binary trajectory", "PlotWindow trajectory", "Ascii Text File"
};
gd.addChoice("File Type?", filetypechoice, filetypechoice[0]);
boolean ch2green = true;
gd.addCheckbox("Ch2 is green?", ch2green);
gd.showDialog();
if (gd.wasCanceled()) {
return;
}
sfreq = gd.getNextNumber();
int psfflag = gd.getNextChoiceIndex();
int fileflag = gd.getNextChoiceIndex();
ch2green = gd.getNextBoolean();
int nfiles = 0;
Object[] histograms = null;
int xmax = 0;
int ymax = 0;
String[] names = null;
if (fileflag < 2) {
jdataio ioclass = new jdataio();
File[] filearray = ioclass.openfiles(OpenDialog.getDefaultDirectory(), IJ.getInstance());
if (filearray.length == 0) {
return;
}
String dir = filearray[0].getAbsolutePath();
int sepindex = dir.lastIndexOf(File.separator);
String newdir = dir.substring(0, sepindex + 1);
OpenDialog.setDefaultDirectory(newdir);
nfiles = filearray.length / 2;
if (nfiles > 25) {
nfiles = 25;
}
histograms = new Object[nfiles];
names = organize_c3_files(filearray);
for (int i = 0; i < nfiles; i++) {
try {
int length1 = (int) (((double) filearray[2 * i].length() - 128.0) / 4.0);
int length2 = (int) (((double) filearray[2 * i + 1].length() - 128.0) / 4.0);
int length3 = (int) (((double) filearray[2 * i].length()) / 2.0);
int length4 = (int) (((double) filearray[2 * i + 1].length()) / 2.0);
InputStream instream = new BufferedInputStream(new FileInputStream(filearray[2 * i]));
InputStream instream2 =
new BufferedInputStream(new FileInputStream(filearray[2 * i + 1]));
if (fileflag == 0) {
int[] pmdata = new int[length1];
int[] pmdata2 = new int[length2];
if (!ioclass.skipstreambytes(instream, 128)) {
showioerror();
instream.close();
return;
}
if (!ioclass.skipstreambytes(instream2, 128)) {
showioerror();
instream2.close();
return;
}
if (!ioclass.readintelintfile(instream, length1, pmdata)) {
showioerror();
instream.close();
return;
}
if (!ioclass.readintelintfile(instream2, length2, pmdata2)) {
showioerror();
instream2.close();
return;
}
if (ch2green) {
histograms[i] = (new pmodeconvert()).pm2pch(pmdata2, pmdata, sfreq, 20000000);
} else {
histograms[i] = (new pmodeconvert()).pm2pch(pmdata, pmdata2, sfreq, 20000000);
}
} else {
float[] tmdata = new float[length3];
float[] tmdata2 = new float[length4];
if (!ioclass.readintelshortfile(instream, length3, tmdata)) {
showioerror();
instream.close();
return;
}
if (!ioclass.readintelshortfile(instream2, length4, tmdata2)) {
showioerror();
instream2.close();
return;
}
if (ch2green) {
histograms[i] = (new pmodeconvert()).create_2Dhistogram(tmdata2, tmdata);
} else {
histograms[i] = (new pmodeconvert()).create_2Dhistogram(tmdata, tmdata2);
}
}
if (((float[][]) histograms[i]).length > xmax) {
xmax = ((float[][]) histograms[i]).length;
}
if (((float[][]) histograms[i])[0].length > ymax) {
ymax = ((float[][]) histograms[i])[0].length;
}
instream.close();
instream2.close();
} catch (IOException e) {
showioerror();
return;
}
}
} else {
if (fileflag == 2) {
ImageWindow iw = WindowManager.getCurrentWindow();
float[][] trajectories = (float[][]) jutils.runPW4VoidMethod(iw, "getYValues");
float[][] tempxvals = (float[][]) jutils.runPW4VoidMethod(iw, "getXValues");
sfreq = 1.0 / ((double) tempxvals[0][1]);
nfiles = trajectories.length / 2;
if (nfiles > 25) {
nfiles = 25;
}
names = new String[nfiles + 1];
names[nfiles] = "avg";
histograms = new Object[nfiles];
for (int i = 0; i < nfiles; i++) {
names[i] = "trajectory " + (i + 1);
if (ch2green) {
histograms[i] =
(new pmodeconvert())
.create_2Dhistogram(trajectories[2 * i + 1], trajectories[2 * i]);
} else {
histograms[i] =
(new pmodeconvert())
.create_2Dhistogram(trajectories[2 * i], trajectories[2 * i + 1]);
}
if (((float[][]) histograms[i]).length > xmax) {
xmax = ((float[][]) histograms[i]).length;
}
if (((float[][]) histograms[i])[0].length > ymax) {
ymax = ((float[][]) histograms[i])[0].length;
}
}
} else {
// here we read tab delimited lines from files
jdataio ioclass = new jdataio();
File[] filearray = ioclass.openfiles(OpenDialog.getDefaultDirectory(), IJ.getInstance());
if (filearray.length == 0) {
return;
}
String dir = filearray[0].getAbsolutePath();
int sepindex = dir.lastIndexOf(File.separator);
String newdir = dir.substring(0, sepindex + 1);
OpenDialog.setDefaultDirectory(newdir);
nfiles = filearray.length;
if (nfiles > 25) {
nfiles = 25;
}
histograms = new Object[nfiles];
names = new String[nfiles + 1];
names[nfiles] = "avg";
for (int i = 0; i < nfiles; i++) {
try {
names[i] = filearray[i].getName();
BufferedReader d = new BufferedReader(new FileReader(filearray[i]));
String[] lines = new String[256];
int counter = 0;
do {
lines[counter] = d.readLine();
counter++;
} while ((lines[counter - 1] != null && lines[counter - 1] != "") && counter < 256);
int numcolumns = 0;
for (int j = 0; j < counter - 1; j++) {
int temp = getncolumns(lines[j]);
if (temp > numcolumns) {
numcolumns = temp;
}
}
float[][] temphist2 = null;
if (ch2green) {
temphist2 = new float[numcolumns][counter - 1];
} else {
temphist2 = new float[counter - 1][numcolumns];
}
for (int k = 0; k < counter - 1; k++) {
float[] temp = tab_delim2float(lines[k]);
for (int j = 0; j < numcolumns; j++) {
if (ch2green) {
temphist2[j][k] = temp[j];
} else {
temphist2[k][j] = temp[j];
}
}
}
histograms[i] = temphist2;
d.close();
} catch (IOException e) {
showioerror();
return;
}
}
for (int i = 0; i < nfiles; i++) {
if (((float[][]) histograms[i]).length > xmax) {
xmax = ((float[][]) histograms[i]).length;
}
if (((float[][]) histograms[i])[0].length > ymax) {
ymax = ((float[][]) histograms[i])[0].length;
}
}
}
}
// note that here x is green and y is red
float[][][] pch = new float[nfiles][xmax][ymax];
for (int i = 0; i < nfiles; i++) {
for (int j = 0; j < ((float[][]) histograms[i]).length; j++) {
for (int k = 0; k < ((float[][]) histograms[i])[j].length; k++) {
pch[i][j][k] = ((float[][]) histograms[i])[j][k];
}
}
}
final PCH2DFitWindow cw = new PCH2DFitWindow();
cw.init(names, pch, psfflag);
final Frame f = new Frame("PCH 2D Analysis");
f.setLocation(10, 10);
f.addWindowListener(
new WindowAdapter() {
public void windowClosing(WindowEvent e) {
f.dispose();
}
});
f.add(cw);
f.pack();
f.setResizable(false);
Insets ins = f.getInsets();
cw.totalSize.height = PCH2DFitWindow.H + ins.bottom + ins.top + 65;
cw.totalSize.width = PCH2DFitWindow.WR + ins.left + ins.right;
f.setSize(cw.totalSize);
f.setVisible(true);
cw.requestFocus();
}
/**
* Takes a vector full of property lists and generates a report.
*
* @param args Command line arguments. args[0] should be the config filename.
*/
public static void main(String[] args) {
// Load the database properties from properties file
Properties properties = new Properties();
// Load config file
String configFile = null;
if (args.length > 0) configFile = args[0];
try {
if (configFile == null) {
System.out.println("Database config file not set.");
return;
} else properties.load(new FileInputStream(configFile));
} catch (IOException e) {
System.out.println("Error opening config file.");
}
String url = properties.getProperty("databaseUrl");
String username = properties.getProperty("username");
String password = properties.getProperty("password");
String dir = System.getProperty("user.dir"); // Current working directory
Connection con = null;
// Try to open file containing javac output
String output = "";
try {
BufferedReader outputReader = new BufferedReader(new FileReader(dir + "/CompileOut.txt"));
while (outputReader.ready()) output += outputReader.readLine() + '\n';
// Close file
outputReader.close();
} catch (FileNotFoundException e) {
System.out.println("Error opening compilation output file.");
return;
} catch (IOException e) {
System.out.println("I/O Exception Occured.");
return;
}
boolean hasDriver = false;
// Create class for the driver
try {
Class.forName("com.mysql.jdbc.Driver");
hasDriver = true;
} catch (Exception e) {
System.out.println("Failed to load MySQL JDBC driver class.");
}
// Create connection to database if the driver was found
if (hasDriver) {
try {
con = DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
System.out.println("Couldn't get connection!");
}
}
// Check that a connection was made
if (con != null) {
long userEventId = -1;
// Store results from the report into the database
try {
BufferedReader rd =
new BufferedReader(
new FileReader(dir + "/userId.txt")); // Read userId.txt to get userId
String userId = rd.readLine(); // Store userId from text file
rd.close();
// Insert the report into the table and get the auto_increment id for it
Statement stmt = con.createStatement();
stmt.executeUpdate("INSERT INTO userEvents (userId) VALUES ('" + userId + "')");
ResultSet result = stmt.getGeneratedKeys();
result.next();
userEventId = result.getLong(1);
// Close the statement
stmt.close();
// Prepare statement for adding the compilation error to the userEvent
PreparedStatement compErrorPrepStmt =
con.prepareStatement(
"INSERT INTO userEventCompilationErrors(userEventId, output) VALUES (?, ?)");
// Insert userEventId and docletId into the database
compErrorPrepStmt.setLong(1, userEventId);
compErrorPrepStmt.setString(2, output);
compErrorPrepStmt.executeUpdate();
// Close the prepare statements
compErrorPrepStmt.close();
} catch (Exception e) {
System.out.println("Exception Occurred");
System.out.println(e);
}
// Store the java files for the report
try {
// Prepare statement for storing files
PreparedStatement filePrepStmt =
con.prepareStatement(
"INSERT INTO files(userEventId, filename, contents) VALUES ("
+ userEventId
+ ", ?, ?)");
// Get the list of files from source.txt
BufferedReader rd =
new BufferedReader(
new FileReader(dir + "/source.txt")); // Read userId.txt to get userId
while (rd.ready()) {
String filename = rd.readLine(); // Store userId from text file
// Remove the "src/" from the beginning to get the real file name
String realname = filename.substring(4);
filePrepStmt.setString(1, realname);
// Read in the contents of the files
String contents = "";
File javaFile = new File(dir + "/" + filename);
int length = (int) javaFile.length();
// Add parameter for file contents to the prepared statement and execute it
filePrepStmt.setCharacterStream(2, new BufferedReader(new FileReader(javaFile)), length);
filePrepStmt.executeUpdate();
}
rd.close();
} catch (IOException e) {
System.err.println("I/O Exception Occured.");
} catch (SQLException e) {
System.err.println("SQL Exception Occured.");
}
}
}
public static void main(String[] args) {
if (args.length != 2) {
System.out.println(
"Usage: java Purger <folder> <date>\n"
+ " - folder: is the path to account.txt and athena.txt files.\n"
+ " - date: accounts created before this date will be purged (dd/mm/yy or yyyy-mm-dd).");
return;
}
int accounts = 0;
int characters = 0;
int deletedCharacters = 0;
Vector activeAccounts = new Vector();
File folder = new File(args[0]);
// Do some sanity checking
if (!folder.exists()) {
System.out.println("Folder does not exist!");
return;
}
if (!folder.isDirectory()) {
System.out.println("Folder is not a folder!");
return;
}
File oldAccount = new File(folder, "account.txt");
File oldAthena = new File(folder, "athena.txt");
File newAccount = new File(folder, "account.txt.new");
File newAthena = new File(folder, "athena.txt.new");
DateFormat dateFormat;
Date purgeDate = null;
for (String format : new String[] {"dd/MM/yy", "yyyy-MM-dd"}) {
dateFormat = new SimpleDateFormat(format);
try {
purgeDate = dateFormat.parse(args[1]);
break;
} catch (ParseException e) {
}
}
if (purgeDate == null) {
System.out.println("ERROR: Date format not recognized.");
return;
}
String line;
// Remove accounts
try {
FileInputStream fin = new FileInputStream(oldAccount);
BufferedReader input = new BufferedReader(new InputStreamReader(fin));
FileOutputStream fout = new FileOutputStream(newAccount);
PrintStream output = new PrintStream(fout);
while ((line = input.readLine()) != null) {
boolean copy = false;
String[] fields = line.split("\t");
// Check if we're reading a comment or the last line
if (line.substring(0, 2).equals("//") || fields[1].charAt(0) == '%') {
copy = true;
} else {
// Server accounts should not be purged
if (!fields[4].equals("S")) {
accounts++;
dateFormat = new SimpleDateFormat("yyyy-MM-dd");
try {
Date date = dateFormat.parse(fields[3]);
if (date.after(purgeDate)) {
activeAccounts.add(fields[0]);
copy = true;
}
} catch (ParseException e) {
System.out.println(
"ERROR: Wrong date format in account.txt. (" + accounts + ": " + line + ")");
// return;
} catch (Exception e) {
e.printStackTrace();
return;
}
} else {
copy = true;
}
}
if (copy) {
try {
output.println(line);
} catch (Exception e) {
System.err.println("ERROR: Unable to write file.");
}
}
}
input.close();
output.close();
} catch (FileNotFoundException e) {
System.out.println("ERROR: file " + oldAccount.getAbsolutePath() + " not found.");
return;
} catch (Exception e) {
System.out.println("ERROR: unable to process account.txt");
e.printStackTrace();
return;
}
System.out.println(
"Removed " + (accounts - activeAccounts.size()) + "/" + accounts + " accounts.");
// Remove characters
try {
FileInputStream fin = new FileInputStream(oldAthena);
BufferedReader input = new BufferedReader(new InputStreamReader(fin));
FileOutputStream fout = new FileOutputStream(newAthena);
PrintStream output = new PrintStream(fout);
while ((line = input.readLine()) != null) {
boolean copy = false;
String[] fields = line.split("\t");
// Check if we're reading a comment or the last line
if (line.substring(0, 2).equals("//") || fields[1].charAt(0) == '%') {
copy = true;
} else {
characters++;
String id = fields[1].substring(0, fields[1].indexOf(','));
if (activeAccounts.contains(id)) {
copy = true;
} else {
deletedCharacters++;
}
}
if (copy) {
output.println(line);
}
}
input.close();
output.close();
} catch (FileNotFoundException e) {
System.out.println("ERROR: file " + oldAthena.getAbsolutePath() + " not found.");
return;
} catch (Exception e) {
System.out.println("ERROR: unable to process athena.txt");
e.printStackTrace();
return;
}
System.out.println("Removed " + deletedCharacters + "/" + characters + " characters.");
}
/**
* Perrform process.
*
* @return Message that would be set to process infor summary (no use currently)
* @throws Exception if not successful
*/
protected String doIt() throws Exception {
// load query into cache file directly
// int userId= this.getAD_User_ID();
// User user= SecurityUtils.getUser(userId);
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
QueryEngine engine = QueryEngine.getInstance();
conn = engine.getConnection();
Configurations conf =
(Configurations)
WebUtils.getServletContextManager().getActor(nds.util.WebKeys.CONFIGURATIONS);
String folder = conf.getProperty("ahyy.payment.folder.download", "e:/act/ahyy/download");
File fd = new File(folder);
if (!fd.exists()) fd.mkdirs();
ahyyCode = conf.getProperty("ahyy.payment.code");
if (ahyyCode == null || ahyyCode.length() != 8)
throw new NDSException("Wrong code for bank payment interface");
SimpleDateFormat df = new SimpleDateFormat("yyMMdd");
String ftpFile = "MPAYREP" + ahyyCode + df.format(new java.util.Date());
String file = folder + "/" + ftpFile;
StringBuffer sb = new StringBuffer();
String lineSep = Tools.LINE_SEPARATOR;
try {
// 下载文件
CommandExecuter cmd = new CommandExecuter(folder + "/log/" + ftpFile + ".log");
String exec = conf.getProperty("ahyy.payment.download", "e:/act/bin/download.cmd");
int err = cmd.run(exec + " " + ftpFile);
if (err != 0) {
throw new NDSException("Error(code=" + err + ") when doing " + exec + " " + ftpFile);
}
if (!(new File(file)).exists()) {
throw new NDSException("File not downloaded when doing " + exec + " " + ftpFile);
}
BufferedReader in = new BufferedReader(new FileReader(file));
in.readLine(); // skip first line, which is summary
String line = in.readLine();
pstmt =
conn.prepareStatement(
"update b_pay_sum set state=?, err_code =? where billno=? and state='R'");
while (line != null) {
log.debug(line);
if (line.length() < 34) {
log.debug("line not has length: 34");
}
/*
String billType= line.substring(0,2);
String billNo= line.substring(0, 22);// billno
String amt=line.substring(22,34);
String ack=line.substring(34,36);*/
String billNo = line.substring(0, 20); // billno
String amt = line.substring(20, 32);
String ack = line.substring(32, 34);
if ("00".equals(ack)) {
java.math.BigDecimal bd = new java.math.BigDecimal(amt);
pstmt.setString(1, "Y");
pstmt.setNull(2, java.sql.Types.VARCHAR);
pstmt.setString(3, billNo);
int ret = pstmt.executeUpdate();
if (ret != 1) {
sb.append(line + "(updated " + ret + " lines)").append(lineSep);
}
} else {
pstmt.setString(1, "P");
pstmt.setString(2, ack);
pstmt.setString(3, billNo);
int ret = pstmt.executeUpdate();
if (ret != 1) {
sb.append(line + "(updated " + ret + " lines)").append(lineSep);
}
}
line = in.readLine();
}
in.close();
try {
log.debug("Move " + file + " to " + folder + "/log/" + ftpFile);
(new File(file)).renameTo(new File(folder + "/log/" + ftpFile));
} catch (Throwable t) {
log.error("Fail to move " + file + " to " + folder + "/log/" + ftpFile, t);
}
Vector vet = new Vector();
String log = sb.toString();
this.log.debug(log);
this.addLog(log);
return "完成";
} finally {
if (rs != null)
try {
rs.close();
} catch (Throwable t) {
}
if (pstmt != null)
try {
pstmt.close();
} catch (Throwable t) {
}
if (conn != null)
try {
conn.close();
} catch (Throwable t) {
}
}
}