import java.sql.*;
import javax.swing.JOptionPane;
class Conn{
	Statement stmt;
	public Connection openDatabase(){
		String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=HappyChat";
		try{
		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		Connection con=DriverManager.getConnection(url,"sa","");
		return con;
		}
		catch(Exception e)
		{
			JOptionPane.showMessageDialog(null,"數(shù)據(jù)庫連接出錯(cuò)!");
			return null;
		}

	}
	public boolean executesql(String sql)
	{
		try{
			//String sql="select * from users where U_Name='mxb' and U_pass='mxb'";
			Statement stmt=openDatabase().createStatement();
			
			ResultSet rs=stmt.executeQuery(sql);
			if(rs.next())
				return true;
			else
			{
				JOptionPane.showMessageDialog(null,"用戶名或密碼錯(cuò)誤!");
				return false;
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally{
			try{
				if(openDatabase()!=null)
				{
					openDatabase().close();
					
				//	stmt.close();
				}
			}catch(Exception e){
				JOptionPane.showMessageDialog(null,"關(guān)閉數(shù)據(jù)庫出錯(cuò)!");
	
			}
			
		}
	
		return false;
	}

}