package?bean;
import?java.sql.*;
public?class?dbcon
{
	??String?user=“sa“;
	??String?password=“sa“;
	??String?driverName=“sun.jdbc.odbc.JdbcOdbcDriver“;
	??String?connectURL=“jdbc:odbc:jspbook“;
	??Connection?conn=null;
	??Statement?stmt=null;
	??ResultSet?rs=null;
	
	public?dbcon（）
	{

		try{
			Class.forName（driverName）;
			conn=DriverManager.getConnection（connectURLuserpassword）;
			conn.setAutoCommit（true）;
			stmt=conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_READ_ONLY）;
			
			
		}
		catch（Exception?e）
		{
			System.out.println（“數據庫連接錯誤“+e.getMessage（））;
		}
	}
	public?ResultSet?executeQuery（String?sql）
	{
		try{
			rs=stmt.executeQuery（sql）;
		}
		catch（SQLException?ex）
		{
			System.out.println（“數據庫查詢錯誤“+ex.getMessage（））;
		}
		return?rs;
	}
	public?int?executeUpdate（String?sql）
	{
		try{
			int?i=stmt.executeUpdate（sql）;
?????????????????????return?i;
		???}
		catch（SQLException?ex）
		{
			System.out.println（“執行更新錯誤：“+ex.getMessage（））;
			return?-1;
		}
	}
	public?Connection?getcon（）
	{
		return?conn;
	}
}

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

?????目錄??????????0??2008-11-24?16:18??chap18

?????文件???????1312??2006-03-18?11:39??chap18\.classpath

?????文件??????????4??2006-03-18?11:39??chap18\.cvsignore

?????文件????????439??2006-03-18?11:39??chap18\.project

?????文件????????354??2006-03-18?11:39??chap18\.tomcatplugin

?????文件???????2889??2006-03-18?08:45??chap18\chujuan.jsp

?????文件???????2895??2005-05-08?13:48??chap18\chujuan.jsp.bak

?????文件???????3568??2006-08-15?15:51??chap18\chujuan1.jsp

?????文件???????3589??2006-03-20?03:38??chap18\chujuan1.jsp.bak

?????目錄??????????0??2008-11-24?16:18??chap18\database

?????文件???????1697??2006-07-28?16:20??chap18\database\testdb.sql

?????文件????1638400??2006-08-14?13:58??chap18\database\try_Data.MDF

?????文件????1048576??2006-08-14?13:58??chap18\database\try_Log.LDF

????..A..H.?????????9??2006-08-24?08:48??chap18\database\_desktop.ini

?????文件????????897??2006-03-23?10:42??chap18\index.jsp

?????文件???????4793??2006-03-20?06:49??chap18\kaoshi.jsp

?????文件???????4513??2006-03-18?11:11??chap18\kaoshi.jsp.bak

?????文件???????1401??2006-03-20?07:20??chap18\kaoshi1.jsp

?????文件???????1226??2006-03-23?10:50??chap18\left.jsp

?????文件???????1198??2006-03-23?10:50??chap18\main.jsp

?????文件???????4641??2006-03-19?06:25??chap18\panduanti.jsp

?????文件????????632??2006-03-20?06:03??chap18\shijuanbianhao.jsp

?????文件??????10143??2004-11-17?18:23??chap18\style.css

?????文件???????2552??2006-03-22?11:05??chap18\tiku.jsp

?????文件???????1633??2006-03-22?11:03??chap18\tiku1.jsp

?????文件????????682??2006-03-23?10:43??chap18\top.jsp

?????目錄??????????0??2008-11-24?16:18??chap18\WEB-INF

?????文件??????????7??2005-12-08?01:25??chap18\WEB-INF\.cvsignore

?????目錄??????????0??2008-11-24?16:18??chap18\WEB-INF\classes

?????目錄??????????0??2008-11-24?16:18??chap18\WEB-INF\classes\bean

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