package odbc;

import java.sql.*;


import javax.swing.JOptionPane;

public class Conn {
	private static Connection conn=null;
	private static int msum,gsum;
	
	public static Connection getConnection() {
		
		try {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			 conn = DriverManager.getConnection("jdbc:odbc:sm"); 	
		} catch (ClassNotFoundException e) {			
			e.printStackTrace();
			JOptionPane.showMessageDialog(null, "找不到數(shù)據(jù)庫驅(qū)動程序！","加載數(shù)據(jù)庫驅(qū)動程序錯誤！",JOptionPane.ERROR_MESSAGE);
		} catch (SQLException e) {
			// TODO 自動生成 catch 塊
			e.printStackTrace();
		}		
		return conn;
	}
	
	public static int mSum() {
		try{
	        Statement stmt = Conn.getConnection().createStatement();
	        ResultSet rs=stmt.executeQuery("select COUNT(Mid) from members");
	        rs.next();
	        msum=Integer.parseInt(rs.getString(1));
		    rs.close();
	        stmt.close();
	        conn.close();
		   }catch(SQLException e1){
		       e1.getStackTrace();
		   }
		return msum;
	}
	
	public static int gSum() {
		try{
	        Statement stmt = Conn.getConnection().createStatement();
	        ResultSet rs=stmt.executeQuery("select COUNT(Gid) from goods");
	        rs.next();
	        gsum=Integer.parseInt(rs.getString(1));
		    rs.close();
	        stmt.close();
	        conn.close();
		   }catch(SQLException e1){
		       e1.getStackTrace();
		   }
		return gsum;
	}
	
}