j2se 统计

package com.erp.app.count;

import java.io.*;
import java.sql.*;

/**
* Created by IntelliJ IDEA.
* User: Administrator
* Date: 2009-2-9
* Time: 16:49:16
* To change this template use File | Settings | File Templates.
*/
public class xx {


String url = "jdbc:oracle:thin:@192.168.1.200:1521:picc";
String user = "piccsys";
String password = "piccsys";


public String Count(String Ptable, String Pid) throws Exception {
Connection conn = DriverManager.getConnection(url, user, password);
ResultSet rs = null;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
String sql = "select count(*) as rec from " + Ptable + " a ,T_BUS_MODEL b where a.SMODELCODE=b.SMODELCODE " +
"and a.SMODELCODE='" + Pid + "'";
rs = stmt.executeQuery(sql);
String returnStr = "";
if (rs.next())
returnStr = rs.getString("rec");
return returnStr;
}

public String scsqlx() throws Exception {
StringBuffer sqlx = new StringBuffer();
String url = "jdbc:oracle:thin:@192.168.1.200:1521:picc";
String user = "piccsys";
String password = "piccsys";
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch (java.lang.ClassNotFoundException e) {
System.err.print(e);
}

Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
String sql = "select a.SMODELCODE ,a.SMODELNAME , a.STABLE_NAME from T_BUS_MODEL a where rownum <= 100 ";
ResultSet rs = stmt.executeQuery(sql);
String[] row = new String[6];
sqlx.append(" <table>\n" +
" <thead>\n" +
" <tr>\n" +
" <td>车型编码</td>\n" +
" <td>车型名称</td>\n" +
" <td>零件总数量</td>\n" +
" <td>有效数量</td>\n" +
" </tr>\n" +
" </thead>");
for (int i = 0; rs.next(); i++) {

row[0] = rs.getString("SMODELCODE");
row[1] = rs.getString("SMODELNAME");
row[2] = rs.getString("STABLE_NAME");
row[3] = this.Count(row[2], row[0]);
sqlx.append("<tr>");
sqlx.append("<td>'" + row[0] + "'<td>");
sqlx.append("<td>'" + row[1] + "'<td>");
sqlx.append("<td>'" + row[3] + "'<td>");
sqlx.append("<td><td><tr>");
}
sqlx.append("</table>");
return sqlx.toString();
}

public void write(String path, String content) {

String s = new String();
String s1 = new String();
try {
File f = new File(path);
if (f.exists()) {
System.out.println("文件存在");
} else {
System.out.println("文件不存在，正在创建...");
if (f.createNewFile()) {
System.out.println("文件创建成功！");
} else {
System.out.println("文件创建失败！");
}

}
BufferedReader input = new BufferedReader(new FileReader(f));

while ((s = input.readLine()) != null) {
s1 += s + "\n";
}
System.out.println("文件内容：" + s1);
input.close();
s1 += content;
BufferedWriter output = new BufferedWriter(new FileWriter(f));
output.write(s1);
output.close();
} catch (Exception e) {
e.printStackTrace();
}
}

public static void main(String[] args) {
try {
System.out.println("begin");
xx x = new xx();
x.write("D:\\123.html", x.scsqlx());
System.out.println("end");
} catch (Exception e) {
e.printStackTrace(); //To change body of catch statement use File | Settings | File Templates.
}
}

}