package db;

import java.sql.*;

public class dbConn
{
	String sDBDriver ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	String sConnStr = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=YouBangDB";
	String user = "sa";
	String password = "admin";
	Connection conn = null;
	ResultSet rs = null;
	int result;
	//
	public dbConn()
	{
		try
		{
			Class.forName(sDBDriver);
		}
		catch(java.lang.ClassNotFoundException e)
		{
			System.err.println(e.getMessage());
		}
		
	}
	//詢侄渭詢
	public ResultSet executeQuery(String sql)
	{
		try
		{
			conn = DriverManager.getConnection(sConnStr,user,password);
			Statement stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);	
		}
		catch(SQLException ex)
		{
			System.err.println(ex.getMessage());
		}
		return rs;
	}
	//蕕姆
	/*public int executeUpdate(String sql)
	{
		try
		{
			conn = DriverManager.getConnection(sConnStr,user,password);
			Statement stmt = conn.createStatement();
			result = stmt.executeUpdate(sql);
		}
		catch(SQLException ex)
		{
			System.err.println(ex.getMessage());	
		}
		return result;
	}*/
}