package find;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;




public class SqlConnection{
	private Connection conn;
	
	public SqlConnection(){
		
	}
	
/*
 *<myenv>

<datasource>
<dbhost>localhost</dbhost>
<dbname>finance</dbname>
<dbuser>sa</dbuser>
<dbpassword>sa</dbpassword>
</datasource>

</myenv>
 */	
	
	public Connection getSQLConnection(){
		try{
			ParseXML p = new ParseXML();
			p.parse("..\\webapps\\find\\WEB-INF\\dbpool.xml");
			Properties props  = p.getProps();
			
			
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();  
			String url="jdbc:microsoft:sqlserver://"+props.getProperty("dbhost")+":1433;DatabaseName="+props.getProperty("dbname");  
			//mydb為數據庫  
			String user=props.getProperty("dbuser");  
			String password=props.getProperty("dbpassword");  
			conn= DriverManager.getConnection(url,user,password);

		}catch(Exception e){
			e.printStackTrace();
		}
		return this.conn;
		
	}
	
		public Connection getSQLConnection1(){
		try{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();  
			String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";  
			//mydb為數據庫  
			String user="sa";  
			String password="";  
			conn= DriverManager.getConnection(url,user,password);

		}catch(Exception e){
			e.printStackTrace();
		}
		return this.conn;
		
	}
	
	public Connection getODBCConnection(){
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn = DriverManager.getConnection("jdbc:odbc:board","sa","sa");
		}catch(Exception e){
			e.printStackTrace();
		}
		return this.conn;
		
	}
	
	public static void main(String args[]){
		new SqlConnection().getSQLConnection();
	}
}