/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package html_test;


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

public class Html_test {

    Connection connection;
    ResultSet resultSet = null;
    PreparedStatement statement = null;
    private ResultSet resultSet1;


       public void Connect() {
        try {
            Class.forName("org.postgresql.Driver");
            System.out.println("Driver loading success!");

            String[] query = {
"select register_num from ecm.doc_cards where doc_cards.id = 4",

"select card_gm_orders.sign_date as date from ecm.card_gm_orders, ecm.doc_cards where ecm.doc_cards.id = ecm.card_gm_orders.doc_cardid and ecm.card_gm_orders.doc_cardid = 4;",

 "select ou.users.uname as uname_gen from ou.users, ecm.doc_bpm_roles where ou.users.id = ecm.doc_bpm_roles.userid and ecm.doc_bpm_roles.roleid = 31 group by ou.users.id",

 "select ou.users.uname as uname_exec from ou.users, ecm.doc_bpm_roles where ou.users.id = ecm.doc_bpm_roles.userid and ecm.doc_bpm_roles.roleid = 27 group by ou.users.id",

 "select ou.orgunit_users.post as post1 from ecm.doc_bpm_roles,ou.orgunit_users where ecm.doc_bpm_roles.doc_cardid = 4 and ecm.doc_bpm_roles.roleid = 24 and ou.orgunit_users.userid = ecm.doc_bpm_roles.userid",

 "select ou.users.uname as uname_post1 from ou.users, ecm.doc_bpm_roles where ou.users.id = ecm.doc_bpm_roles.userid and ecm.doc_bpm_roles.roleid = 24 group by ou.users.id",

 "select ou.orgunit_users.post as post2 from ecm.doc_bpm_roles,ou.orgunit_users where ecm.doc_bpm_roles.doc_cardid = 4 and ecm.doc_bpm_roles.roleid = 32 and ou.orgunit_users.userid = ecm.doc_bpm_roles.userid",

 "select ou.users.uname as uname_post2 from ou.users, ecm.doc_bpm_roles where ou.users.id = ecm.doc_bpm_roles.userid and ecm.doc_bpm_roles.roleid = 32 group by ou.users.id"
                                };

            for (int i = 0; i < query.length; i++ )

            connection = DriverManager.getConnection("jdbc:postgresql://192.168.0.108:5432/rdb", "user", "123456789");
            statement = connection.prepareStatement(query);
            resultSet = statement.executeQuery();


            String result="";
            while(resultSet.next()){
                result = result+resultSet.getString(1) + "\n";
            }
            System.out.println("the result is:  "+result);

            File fileIn = new File("D:\\Java_JR_Project\\html_test\\1.html");
            File file = new File("D:\\Java_JR_Project\\html_test\\2.doc");

            Reader r = new InputStreamReader(new FileInputStream(fileIn), "Cp1251");
            Writer w = new OutputStreamWriter(new FileOutputStream(file), "Cp1251");

            BufferedReader reader = new BufferedReader(r);
            BufferedWriter writer = new BufferedWriter(w);

            String line = null;
            while ((line = reader.readLine()) != null) {
                //System.out.println(line);
                if(line.contains("{register_num}")){
                    System.out.println(line);
                    line = line.replaceAll("\\{register_num\\}", result);
                }
                if(line.contains("{date}")){
                    System.out.println(line);
                    line = line.replaceAll("\\{date\\}", result);
                }
                if(line.contains("{uname_gen}")){
                    System.out.println(line);
                    line = line.replaceAll("\\{uname_gen\\}", result);
                }
                if(line.contains("{uname_exec}")){
                    System.out.println(line);
                    line = line.replaceAll("\\{uname_exec\\}", result);
                }
                if(line.contains("{post1}")){
                    System.out.println(line);
                    line = line.replaceAll("\\{post1\\}", result);
                }
                if(line.contains("{uname_post1}")){
                    System.out.println(line);
                    line = line.replaceAll("\\{uname_post1\\}", result);
                }
                if(line.contains("{post2}")){
                    System.out.println(line);
                    line = line.replaceAll("\\{post2\\}", result);
                }
                if(line.contains("{uname_post2}")){
                    System.out.println(line);
                    line = line.replaceAll("\\{uname_post2\\}", result);
                }

                writer.write(line);
                writer.newLine();
            }
            reader.close();  // Close to unlock.
            writer.close();  // Close to unlock and flush to disk.
            connection.close();

        } catch (Exception e) {
            System.out.println(e + " e1");
        }
    }

    public static void main(String[] args) {
       new Html_test().Connect();

    }
}