package?com.js.jsp.db;

import?java.sql.CallableStatement;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?sun.jdbc.rowset.CachedRowSet;

public?class?DbUtil?{
????public?boolean?execute（String?sql）?{
????	Connection?conn?=?null;
????	Statement?stmt?=?null;
????	try?{
	????	DriverManager.registerDriver（new?net.sourceforge.jtds.jdbc.Driver（））;
			conn??=?DriverManager.getConnection（“jdbc:jtds:sqlserver://192.168.1.100:1433;databaseName=test“?“sa“?““）;
			stmt?=?conn.createStatement（）;
			return?stmt.execute（sql）;
????	}
????	catch?（SQLException?e）?{
????		return?false;
????	}
????	finally?{
????		try?{
				stmt.close（）;
				conn.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
????	}?
????}
????public?ResultSet?executeCallable（int?intPage）{
????	Connection?conn?=?null;
????	CallableStatement?cs?=?null;
????	try?{
	????	DriverManager.registerDriver（new?net.sourceforge.jtds.jdbc.Driver（））;
			conn??=?DriverManager.getConnection（“jdbc:jtds:sqlserver://192.168.1.100:1433;databaseName=test“?“sa“?““）;
			cs?=?conn.prepareCall（“{call?sp_pagenation（????）}“）;
			cs.setString（1“dq_book“）;
			cs.setString（2“name“）;
			cs.setInt（35）;
			cs.setInt（4intPage）;
			ResultSet?rs?=??cs.executeQuery（）;
			CachedRowSet?crs?=?new?CachedRowSet（）;
			crs.populate（rs）;
			return?crs;
????	}
????	catch?（SQLException?e）?{
????		return?null;
????	}
????	finally?{
????		try?{
				cs.close（）;
				conn.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
????	}?
????}
????public?ResultSet?executeQuery（String?sql）?{
????	Connection?conn?=?null;
????	Statement?stmt?=?null;
????	try?{
	????	DriverManager.registerDriver（new?net.sourceforge.jtds.jdbc.Driver（））;
			conn??=?DriverManager.getConnection（“jdbc:jtds:sqlserver://192.168.1.100:1433;databaseName=test“?“sa“?““）;
			stmt?=?conn.createStatement（）;
			ResultSet?rs?=??stmt.executeQuery（sql）;
			CachedRowSet?crs?=?new?CachedRowSet（）;
			crs.populate（rs）;
			return?crs;
????	}
????	catch?（SQLException?e）?{
????		return?null;
????	}
????	finally?{
????		try?{
				stmt.close（）;
				conn.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
????	}?
????}
}

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

?????文件????????914??2008-11-25?13:01??vo\Book.java

?????文件???????2227??2008-12-06?12:02??servlet\Book1Servlet.java

?????文件???????6237??2008-12-04?17:57??service\BookService.java

?????文件???????2970??2008-12-06?13:40??servlet\BookServlet.java

?????文件???????2356??2008-12-02?17:47??db\DbUtil.java

?????文件???????2033??2008-12-05?16:31??db\DbUtil_pagination.java

?????文件????????366??2008-11-25?13:01??vo\Type.java

?????文件???????1994??2008-11-25?17:09??service\TypeService.java

?????文件???????2070??2008-12-09?13:41??book\bookAdd.jsp

?????文件???????4355??2008-12-06?13:26??book\bookList.jsp

?????文件????????489??2008-12-02?17:41??book\bookService.jsp

?????文件???????2623??2008-12-06?13:38??book\bookUpdate.jsp

?????文件???????1099??2008-11-25?11:03??book\login.jsp

?????文件????????308??2008-11-22?12:50??book\loginFail.jsp

?????文件???????1269??2008-11-22?13:04??book\manage.jsp

?????文件????????995??2008-11-24?18:22??book\typeAdd.jsp

?????文件???????2651??2008-11-25?16:59??book\typeList.jsp

?????文件???????1077??2008-12-02?14:16??book\typeService.jsp

?????文件???????1305??2008-11-25?16:52??book\typeUpdate.jsp

?????文件?????????48??2008-11-18?15:46??db\vssver.scc

?????目錄??????????0??2008-12-12?21:54??book

?????目錄??????????0??2008-12-12?21:52??db

?????目錄??????????0??2008-12-12?21:52??service

?????目錄??????????0??2008-12-12?21:54??servlet

?????目錄??????????0??2008-12-12?21:53??vo

-----------?---------??----------?-----??----

????????????????37386????????????????????25