package?com.demo.javabean;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

public?class?DBAccess?{

	private?String?drv?=?“org.gjt.mm.mysql.Driver“;

	private?String?url?=?“jdbc:mysql://localhost:3306/demo“;

	private?String?usr?=?“root“;

	private?String?pwd?=?““;

	private?Connection?conn?=?null;

	private?Statement?stm?=?null;

	private?ResultSet?rs?=?null;

	public?boolean?createConn（）?{
		boolean?b?=?false;
		try?{
			Class.forName（drv）.newInstance（）;
			conn?=?DriverManager.getConnection（url?usr?pwd）;
			b?=?true;
		}?catch?（SQLException?e）?{
		}?catch?（ClassNotFoundException?e）?{
		}?catch?（InstantiationException?e）?{
		}?catch?（IllegalAccessException?e）?{
		}
		return?b;
	}

	public?boolean?update（String?sql）?{
		boolean?b?=?false;
		try?{
			stm?=?conn.createStatement（）;
			stm.execute（sql）;
			b?=?true;
		}?catch?（Exception?e）?{
			System.out.println（e.toString（））;
		}
		return?b;
	}

	public?void?query（String?sql）?{
		try?{
			stm?=?conn.createStatement（）;
			rs?=?stm.executeQuery（sql）;
		}?catch?（Exception?e）?{
		}
	}
	
	public?boolean?next（）?{
		boolean?b?=?false;
		try?{
			if（rs.next（））b?=?true;
		}?catch?（Exception?e）?{
		}
		return?b;		
	}
	
	public?String?getValue（String?field）?{
		String?value?=?null;
		try?{
			if（rs!=null）value?=?rs.getString（field）;
		}?catch?（Exception?e）?{
		}
		return?value;
	}

	public?void?closeConn（）?{
		try?{
			if?（conn?!=?null）
				conn.close（）;
		}?catch?（SQLException?e）?{
		}
	}

	public?void?closeStm（）?{
		try?{
			if?（stm?!=?null）
				stm.close（）;
		}?catch?（SQLException?e）?{
		}
	}

	public?void?closeRs（）?{
		try?{
			if?（rs?!=?null）
				rs.close（）;
		}?catch?（SQLException?e）?{
		}
	}

	public?Connection?getConn（）?{
		return?conn;
	}

	public?void?setConn（Connection?conn）?{
		this.conn?=?conn;
	}

	public?String?getDrv（）?{
		return?drv;
	}

	public?void?setDrv（String?drv）?{
		this.drv?=?drv;
	}

	public?String?getPwd（）?{
		return?pwd;
	}

	public?void?setPwd（String?pwd）?{
		this.pwd?=?pwd;
	}

	public?ResultSet?getRs（）?{
		return?rs;
	}

	public?void?setRs（ResultSet?rs）?{
		this.rs?=?rs;
	}

	public?Statement?getStm（）?{
		return?stm;
	}

	public?void?setStm（Statement?stm）?{
		this.stm?=?stm;
	}

	public?String?getUrl（）?{
		return?url;
	}

	public?void?setUrl（String?url）?{
		this.url?=?url;
	}

	public?String?getUsr（）?{
		return?usr;
	}

	public?void?setUsr（String?usr）?{
		this.usr?=?usr;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????8854??2007-08-23?18:58??database\database\demo\address.frm

?????文件???????2068??2007-08-28?18:16??database\database\demo\address.MYD

?????文件???????4096??2007-08-28?18:16??database\database\demo\address.MYI

?????文件?????????65??2007-08-13?18:09??database\database\demo\db.opt

?????文件???????8770??2007-08-28?09:32??database\database\demo\meeting.frm

?????文件????????156??2007-08-29?18:46??database\database\demo\meeting.MYD

?????文件???????4096??2007-08-29?18:46??database\database\demo\meeting.MYI

?????文件???????8696??2007-08-28?09:32??database\database\demo\notice.frm

?????文件????????144??2007-08-29?18:16??database\database\demo\notice.MYD

?????文件???????4096??2007-08-29?18:16??database\database\demo\notice.MYI

?????文件???????8714??2007-08-28?09:32??database\database\demo\schedule.frm

?????文件????????176??2007-08-29?17:46??database\database\demo\schedule.MYD

?????文件???????4096??2007-08-29?17:46??database\database\demo\schedule.MYI

?????文件???????8736??2007-08-28?09:44??database\database\demo\sms.frm

?????文件????????136??2007-08-29?19:46??database\database\demo\sms.MYD

?????文件???????4096??2007-08-29?19:46??database\database\demo\sms.MYI

?????文件???????8664??2007-08-23?18:58??database\database\demo\user.frm

?????文件?????????80??2007-08-30?19:03??database\database\demo\user.MYD

?????文件???????4096??2007-08-30?19:16??database\database\demo\user.MYI

?????文件???????8796??2007-08-28?09:32??database\database\demo\worklog.frm

?????文件????????184??2007-08-29?17:46??database\database\demo\worklog.MYD

?????文件???????4096??2007-08-29?17:46??database\database\demo\worklog.MYI

?????文件???????9252??2007-08-28?18:21??database\database\demo.sql

?????文件????????414??2007-08-17?14:52??demo（JSP）\demo\.classpath

?????文件????????285??2007-08-17?13:14??demo（JSP）\demo\.mymetadata

?????文件???????1344??2007-08-17?13:33??demo（JSP）\demo\.project

?????文件??????23747??2007-08-17?16:14??demo（JSP）\demo\WebRoot\images\logo2.png

?????文件???????2530??2007-08-17?16:14??demo（JSP）\demo\WebRoot\images\logo3.png

?????文件??????20562??2007-08-17?16:14??demo（JSP）\demo\WebRoot\images\logo4.png

?????文件???????3806??2007-08-17?16:14??demo（JSP）\demo\WebRoot\images\logo5.bmp

............此處省略1470個文件信息