package?my;

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

public?class?DBBean?{
	private?String?driverStr?=?“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	private?String?connStr?=?“jdbc:sqlserver://localhost:1433;DatabaseName=addre_book;?user=sa;?password=sa“;
	private?Connection?conn;
	private?Statement?stmt;
	
	public?DBBean（）{
		try?{
			Class.forName（driverStr）;
			conn?=?DriverManager.getConnection（connStr）;
			stmt?=?conn.createStatement（）;
		}?catch?（Exception?e）?{
			System.out.println（e.getMessage（））;
		}
	}
	
	
	public?String?getDriverStr（）?{
		return?driverStr;
	}


	public?void?setDriverStr（String?driverStr）?{
		this.driverStr?=?driverStr;
	}


	public?String?getConnStr（）?{
		return?connStr;
	}


	public?void?setConnStr（String?connStr）?{
		this.connStr?=?connStr;
	}


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


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


	public?Statement?getStmt（）?{
		return?stmt;
	}


	public?void?setStmt（Statement?stmt）?{
		this.stmt?=?stmt;
	}


	public?ResultSet?mySelect（String?sql）{
		ResultSet?rs?=?null;
		try?{
			rs?=?stmt.executeQuery（sql）;
		}?catch?（Exception?e）?{
			System.out.println（e.getMessage（））;
		}
		return?rs;
	}
	public?int?myUpdate（String?sql）{
		int?result?=?0;
		try?{
			conn?=?DriverManager.getConnection（connStr）;
			stmt?=?conn.createStatement（）;
			result?=?stmt.executeUpdate（sql）;
		}?catch?（Exception?e）?{
			System.out.println（e.getMessage（））;
		}
		return?result;
	}
	public?void?close（）{
		try?{
			stmt.cancel（）;
			conn.close（）;
		}?catch?（Exception?e）?{
			System.out.println（e.getMessage（））;
		}
	}
//??public?static?void?main（String?args[]）{
//	??DBBean?db=new?DBBean（）;
//	??ResultSet?rs=db.executeQuery（“select?*?from?vote“）;
//	??
//	??try?{
//		while（rs.next（））{
//		?????
//		??????System.out.println（rs.getString（“id“））;
//		?????//?out.println（rs.getString（“name“））;
//		???
//		???
//		????}
//		??rs.close（）;
//	???????db.close（）;
//	}?catch?（SQLException?e）?{
//		//?TODO?Auto-generated?catch?block
//		e.printStackTrace（）;
??}

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

?????文件????????468??2010-12-28?21:34??addre_book\.classpath

?????文件????????303??2010-12-28?20:08??addre_book\.mymetadata

?????文件???????1416??2010-12-28?20:35??addre_book\.project

?????文件????????500??2010-12-28?20:08??addre_book\.settings\.jsdtscope

?????文件????????334??2010-12-28?20:08??addre_book\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2010-12-28?20:08??addre_book\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2010-12-28?20:08??addre_book\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????327??2010-12-30?19:14??addre_book\sql.sql

?????文件?????253122??2006-08-16?16:00??addre_book\sqljdbc.jar

?????文件???????2272??2011-01-03?01:35??addre_book\src\my\DBBean.java

?????文件???????2012??2011-01-03?12:16??addre_book\src\my\ShowPage.java

?????文件???????3148??2011-01-01?23:11??addre_book\WebRoot\adduser.jsp

?????文件?????347213??2010-12-29?17:58??addre_book\WebRoot\bg.jpg

?????文件????????290??2010-12-29?21:34??addre_book\WebRoot\check.jsp

?????文件????????567??2010-12-29?16:29??addre_book\WebRoot\checkadmin.jsp

?????文件???????1537??2010-12-30?23:42??addre_book\WebRoot\dealdelete.jsp

?????文件???????2172??2010-12-31?09:41??addre_book\WebRoot\dealinsert.jsp

?????文件???????1747??2010-12-30?18:28??addre_book\WebRoot\dealupdate.jsp

?????文件???????1480??2010-12-30?22:53??addre_book\WebRoot\delete.jsp

?????文件???????1014??2010-12-31?10:33??addre_book\WebRoot\home.jsp

?????文件???????3093??2010-12-31?13:07??addre_book\WebRoot\insert.jsp

?????文件???????1664??2010-12-31?15:32??addre_book\WebRoot\left.jsp

?????文件??????29136??2010-12-30?14:07??addre_book\WebRoot\left_bg.jpg

?????文件???????2026??2011-01-02?23:42??addre_book\WebRoot\login.jsp

?????文件????????350??2010-12-31?13:48??addre_book\WebRoot\logout.jsp

?????文件?????????36??2010-12-28?20:08??addre_book\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1261??2010-12-31?11:31??addre_book\WebRoot\process.jsp

?????文件???????2791??2010-12-31?10:37??addre_book\WebRoot\register.jsp

?????文件???????5393??2011-01-02?16:31??addre_book\WebRoot\right2.jsp

?????文件???????1414??2010-12-31?15:35??addre_book\WebRoot\top.jsp

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