// VisitData

package classFile;

import javax.swing.*;
import java.sql.*;


class VisitData
{
	public Connection con = null;
	public ResultSet result;
	public Statement stmt;
	public PreparedStatement pre = null;	
	private String url = new String("jdbc:odbc:data");
	private String driver = new String("sun.jdbc.odbc.JdbcOdbcDriver");

	public VisitData()
	{
		try
		{
			Class.forName(driver);
			con = DriverManager.getConnection(url,"lp", "lp");
		}
		catch(Exception e)
		{
			JOptionPane.showMessageDialog(null, "數(shù)據(jù)庫(kù)連接失敗!!");
			e.printStackTrace();
		}
	}
	
	public void DBLind(String sql) throws Exception
	{
		pre = con.prepareStatement(sql);
	} 
	
	public void query(String sql) throws Exception
	{
		stmt = con.createStatement();
		result = stmt.executeQuery(sql);
	}

	public void closeDB() throws Exception
	{
		con.close();
		stmt.close();
		result.close();
		pre.close();
	}
}