package car;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
import java.sql.*;

public class DataBaseManager {

    public static Connection con;
    ResultSet rs;
    Statement stmt;
//    private static String priA_strServerName; //服務器名或IP地址
//    private static String priA_strPortNumber; //端口號
//    private static String priA_strMyDatabase; //數據庫名
//    private static String priA_strUsername; //用戶名
//    private static String priA_strPassword; //密碼

//    public static DataBaseManager getlin()
//    {
//        DataBaseManager dbm=new DataBaseManager();
//        return dbm;
//
//     }
    public DataBaseManager() {

        try{
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        }catch(Exception e){}
        try{
          //  String url="jdbc:microsoft:sqlserver://"+"http://10.2.0.3"+":"+"1433"+";DatabaseName="+"CarMessage_Data.MDF";
            String priA_strServerName="127.0.0.1";
            String priA_strPortNumber="1433";
            String priA_strMyDatabase="CarMessage";
            String url = "jdbc:microsoft:sqlserver://"+priA_strServerName+":"+
                        priA_strPortNumber+";DatabaseName="+priA_strMyDatabase;

            Connection con=DriverManager.getConnection(url,"sa","");
            stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
            //創建Statment對象，指定記錄集可滾動，只讀執行查詢，返回結果集
        }catch(SQLException sqle){System.out.println(sqle.toString());}
    }

    public ResultSet getResult(String strSQL)//查詢
        {
            try {
                rs = stmt.executeQuery(strSQL);
                return rs;

            } catch (SQLException sqle) {
                System.out.println(sqle.toString());
                return null;
            }
        }

        public boolean updateSql(String strSQL)//修改
        {

            try {

                stmt.executeUpdate(strSQL);
                return true;
            } catch (SQLException sqle) {
                System.out.println(sqle.toString());
                return false;
            }
        }
        public void closeConnection()
        {
                try{
                    if(con!=null)
                    con.close();
                }catch(SQLException sqle){System.out.println(sqle.toString());}
        }
}