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

public class ConnDB
{
	public Connection conn=null;
	public Statement stmt=null;
	public ResultSet rs=null;
	private static String dbDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
	private static String dbUrl="jdbc:sqlserver://localhost:1433;databaseName=ShopSystem";
	private static String dbUser="sa";
	private static String dbPwd="123456";

	//打開數(shù)據(jù)庫連接
	public static Connection getConnection()
	{
		Connection conn=null;
		try
		{
			Class.forName(dbDriver);
			conn=DriverManager.getConnection(dbUrl,dbUser,dbPwd);
		}
		catch(Exception e)
		{
			e.printStackTrace();
			System.err.println("警告:沒有找到驅(qū)動!");
		}
    	if (conn == null) 
    	{
      		System.err.println("警告:數(shù)據(jù)庫連接失敗!");
    	}		
		return conn;
	}
	//讀取結(jié)果集
	public ResultSet doQuery(String sql)
	{
		try
		{
			conn=ConnDB.getConnection();
			stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rs=stmt.executeQuery(sql);
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
		return rs;
	}
	//更新數(shù)據(jù)
	public int doUpdate(String sql)
	{
		int result=0;
		try
		{
			conn=ConnDB.getConnection();
			stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			result=stmt.executeUpdate(sql);
		}
		catch(SQLException e)
		{
			result=0;
		}
		return result;
	}
	//關(guān)閉數(shù)據(jù)庫連接
	public void closeConnection()
	{
		try
		{
			if (rs!=null)
				rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		try
		{
			if (stmt!=null)
				stmt.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		try
		{
			if (conn!=null)
				conn.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public static void main(String[] args) {
		Connection conn=null;
		conn=ConnDB.getConnection();
		if(conn!=null){
			System.out.print("數(shù)據(jù)庫連接成功！");
		}else{
			System.out.print("數(shù)據(jù)庫連接失敗！");
		}
	}
}