package pack;

import java.sql.*;

public class DataAccess {
	//利用JDBC-ODBC或廠商驅動訪問SQl Server 2000數據庫
	public 	DataAccess() {
		try {
			//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		} catch(Exception e) {
			e.printStackTrace();
		}
	}
	
	//查詢
	public ResultSet query(String sql) {
		try {
			Connection myCon = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Ajax","sa","ok");
			Statement st = myCon.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
			return st.executeQuery(sql);
			
		} catch(Exception e) {
			e.printStackTrace();
			return null;
		}	
	}
	
	//刪除
	public int update(String sql) {
		try {
			Connection myCon = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Ajax","sa","ok");
			Statement st = myCon.createStatement();
			return st.executeUpdate(sql);
		} catch(Exception e) {
			e.printStackTrace();
			return 0;
		}	
	}
}