daocoder11.java

dgbas公文管理核心java源码

package com.jasson.business.document;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author unascribed
 * @version 1.0
 */
import java.sql.*;
import java.util.Properties;
import java.io.*;
import java.sql.*;
public class DaoCoder11 {

    public String pathName="D:\\JDYM\\src\\com\\jasson\\business\\document\\";
    public String className="";
    public String tableName="";
    private ResultSet rs = null;
    private Statement stmt = null;
    private ResultSetMetaData rsD;
    private String XXX="XXX";
    private String YYY="String";
    public DaoCoder11() {
    }
    public void writeDaoToFile(){
        try {
            //DbConn dbConn = new DbConn();
            //Connection conn = dbConn.getConnection();
            String url="jdbc:microsoft:sqlserver://devserver:1433;DatabaseName=AgentFlow";
            //String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
            String dbDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
            Properties props = new Properties();
            Class.forName(dbDriver);
            props.put("user","sa");
            props.put("password","");
            Connection conn = DriverManager.getConnection(url, props);
            String sql="select * from "+tableName+" where 1<>1";

            String fileStreamStr="package com.jasson.business.document;\r\n\r\n";
            fileStreamStr+="import java.io.*;\r\n";
            fileStreamStr+="import java.sql.*;\r\n";
            fileStreamStr+="import java.util.Properties;\r\n";
            fileStreamStr+="import java.util.Collection;\r\n";
            fileStreamStr+="import java.util.ArrayList;\r\n";
            fileStreamStr+="import com.jasson.business.common.DbConn;\r\n\r\n";
            fileStreamStr+="import com.jasson.common.*;\r\n\r\n";

            fileStreamStr+="////todo:where э跑