package?dbb;

import?java.lang.*;
import?java.io.*;
import?java.sql.*;
import?java.util.*;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

public?class?SQLServer
{
	String?sDBDriver?=?“com.microsoft.jdbc.sqlserver.SQLServerDriver“;
	String?url???????=?“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=kechengsheji“;
	
	String?user?=?“sa“;
	String?password?=?“sa“;
	
	Connection?connect?=?null;
	ResultSet??rs??????=?null;
	
	public?SQLServer（）
	{
		try
		{
			Class.forName（sDBDriver）;
		}
		catch（java.lang.ClassNotFoundException?e）
		{
			System.err.println（e.getMessage（））;
		}
	}
	
	public?ResultSet?executeQuery（String?sql）
	{
		try
		{
			connect?=?DriverManager.getConnection（urluserpassword）;
			Statement?stmt?=?connect.createStatement（ResultSet.TYPE_SCROLL_SENSITIVEResultSet.CONCUR_UPDATABLE）;
			rs?=?stmt.executeQuery（sql）;
		}
		catch（SQLException?ex）
		{
			System.err.println（ex.getMessage（））;
		}
		return?rs;
	}
	
	public??ResultSet?executeUpdate（String?sql）
	{
		try
		{
			connect?=?DriverManager.getConnection（urluserpassword）;?
			Statement?stmt?=?connect.createStatement（ResultSet.TYPE_SCROLL_SENSITIVEResultSet.CONCUR_UPDATABLE）;
			rs?=?stmt.executeQuery（sql）;
		}
		catch（SQLException?ex）
		{
			System.err.println（ex.getMessage（））;
		}
		return?rs;
	}
	
	public?int?executeInsert（String?sql）
	{
		int?result?=?0;
		try
		{
			connect?=?DriverManager.getConnection（urluserpassword）;
			Statement?stmt?=?connect.createStatement（）;
			result?=stmt.executeUpdate（sql）;
		}
		catch（SQLException?ex）
		{
			System.err.println（ex.getMessage（））;
		}
		return?result;
	}
	
	public?int?executeDelete（String?sql）
	{
		int?num?=?0;
		try
		{
			connect?=?DriverManager.getConnection（urluserpassword）;
			Statement?stmt?=?connect.createStatement（）;
			num?=?stmt.executeUpdate（sql）;
		}
		catch（SQLException?ex）
		{
			System.err.println（ex.getMessage（））;
		}
		return?num;
	}
}

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

?????文件???????1181??2009-06-04?10:44??jsp\admin\addkecheng.jsp

?????文件???????1880??2009-06-04?10:45??jsp\admin\adduser.jsp

?????文件???????5049??2009-06-03?19:40??jsp\admin\admin.jsp

?????文件???????5006??2009-06-03?20:03??jsp\admin\bianji.jsp

?????文件???????2183??2009-06-03?20:05??jsp\admin\bianjike.jsp

?????文件????????531??2009-05-28?14:47??jsp\admin\delete.jsp

?????文件????????536??2009-05-28?15:33??jsp\admin\deleteke.jsp

?????文件???????1749??2009-06-03?20:06??jsp\admin\kecheng.jsp

?????文件???????2510??2009-06-03?20:12??jsp\admin\showkecheng.jsp

?????文件???????2641??2009-05-29?10:02??jsp\admin\showuser.jsp

?????文件???????1135??2009-06-03?20:04??jsp\admin\update.jsp

?????文件????????986??2009-05-28?15:31??jsp\admin\updateke.jsp

?????文件???????2156??2009-06-03?19:58??jsp\admin\user.jsp

?????文件???????1059??2009-05-28?15:39??jsp\admin\welcome.jsp

?????文件???????4800??2009-05-12?15:35??jsp\css\admin_css.css

?????文件????????771??2009-06-03?18:50??jsp\css\leftmenu.css

?????文件???????1880??2009-06-03?11:00??jsp\css\main.css

?????文件????1048576??2009-06-04?16:57??jsp\data\kechengsheji_Data.MDF

?????文件????1048576??2009-06-04?16:57??jsp\data\kechengsheji_Log.LDF

?????文件???????2434??2009-06-03?19:38??jsp\deal.jsp

?????文件???????1337??2009-04-20?16:14??jsp\images\admintitlehide.gif

?????文件???????1333??2009-04-20?16:15??jsp\images\admintitleshow.gif

?????文件????????991??2008-06-05?13:04??jsp\images\login_btn_bg.gif

?????文件???????1535??2009-05-15?10:01??jsp\js\function.js

?????文件????????604??2009-06-04?11:45??jsp\js\leftmenu.js

?????文件???????4236??2009-06-04?14:53??jsp\js\login.js

?????文件???????2246??2009-06-03?18:22??jsp\login.jsp

?????文件?????????91??2004-01-05?21:54??jsp\student\buttonimage\standard\about.gif

?????文件?????????97??2004-01-06?16:58??jsp\student\buttonimage\standard\abspos.gif

?????文件????????272??2004-01-05?21:56??jsp\student\buttonimage\standard\anchor.gif

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