package wssd;
import java.sql.*;
import java.util.*;
import java.io.*;
public class connectDB
{
	Connection conn = null;
	PreparedStatement stmt = null;
	String DBUrl = "jdbc:oracle:thin:@localhost:1521:ORACLE";
	String DBDriver = "oracle.jdbc.driver.OracleDriver";
	String DBUser = "jerry";
	String DBPsw = "123456";
	public connectDB()
	{
			try
			{
				Class.forName(DBDriver); 
				conn = DriverManager.getConnection(DBUrl,DBUser,DBPsw);
			}
			catch(Exception e)
			{
				e.printStackTrace();
			}
	}
	
	private int setDBParameter()
	{
		int result=0;
		Properties pro = new Properties();
		try
		{
			FileInputStream fin = new FileInputStream("dbinfo.properties");
			pro.load(fin);
			DBUrl = pro.getProperty("DBUrl");
			DBDriver = pro.getProperty("DBDriver");
			DBUser = pro.getProperty("DBUser");
			DBPsw = pro.getProperty("DBPsw");
			fin.close();
			result = 1;
		}
		catch (Exception e)
		{	
			e.printStackTrace();
		}
		return result;
	}

	public ResultSet executeQuery(String sql) throws Exception
	{
		try
		{
			stmt = null;
			stmt = conn.prepareStatement(sql);
			return stmt.executeQuery();
		}
		catch(Exception e)
		{
			e.printStackTrace();
			return null;
		}
	}
	
	public void executeUpdate(String sql) throws Exception
	{
		try
		{
			stmt = null;
			stmt = conn.prepareStatement(sql);
			stmt.executeUpdate();
		}	
		catch(Exception e)
		{
			e.printStackTrace();
		}	
	}
	
	public void closeDB()
	{
		try
		{
			conn.close();
			stmt.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	public String DB2HTML(String str)
	{
		if(str == null||str.equals(""))
		{
		    return str;
		}
		
		StringBuffer temp = new StringBuffer();
		int i = 0;
		while(i < str.length()) 
		{
		    //將\n轉換成<br>
				if(str.charAt(i) == '\n')
				{
				    temp = temp.append("<br>");
				}
				
				//將空格轉換成&nbsp;
				else if(str.charAt(i) == ' ')
				{
				    temp = temp.append("&nbsp;");
				}
				
				//將<轉換成&lt;
				else if(str.charAt(i) == '<')
				{
				    temp = temp.append("&lt;");
				}
				
				//將>轉換成&gt;
				else if(str.charAt(i) == '>')
				{
				    temp = temp.append("&gt;");
				}
				
				else
				{
				    temp = temp.append(str.substring(i,i+1));
				}
				
				i++;
		}
		
		return temp.toString();
	}		 
}