package?ckstudio.db;
import?java.sql.*;
public?class?mysqlconn?{
String?sDBDriver?=?“org.gjt.mm.mysql.Driver“;
//請修改下面參數(shù)--數(shù)據(jù)地址：localhost?數(shù)據(jù)庫名：jspshop?用戶名:root?密碼：
String?sConnStr?=?“jdbc:mysql://localhost/jspshop?user=root&password=&useUnicode=true&characterEncoding=GB2312“;
Connection?conn?=?null;
ResultSet?rs?=?null;
public?mysqlconn（）?{
try?{
Class.forName（sDBDriver）;?
}
catch（java.lang.ClassNotFoundException?e）?{
System.err.println（“conn（）:?“?+?e.getMessage（））;
}
}
public?void?executeInsert（String?sql）
	{
	try
		{
		conn=DriverManager.getConnection（sConnStr）;
		Statement?stmt=conn.createStatement（）;

		int?n=stmt.executeUpdate（sql）;
		}
		catch（SQLException?ex）
		{
			System.err.println（“conn.executeUpdate:“+?ex.getMessage（））;
		}
	}
public?ResultSet?executeQuery（String?sql）?{
rs?=?null;
try?{
conn?=?DriverManager.getConnection（sConnStr）;?
Statement?stmt;
stmt?=?conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_UPDATABLE）;
rs?=?stmt.executeQuery（sql）;
}?
catch（SQLException?ex）?{?
System.err.println（“conn.executeQuery:?“?+?ex.getMessage（））;
}
return?rs;
}
public?void?executeDelete（String?sql）
	{
	try
		{
		conn=DriverManager.getConnection（sConnStr）;
		Statement?stmt=conn.createStatement（）;
		stmt.executeUpdate（sql）;
		}
		catch（SQLException?ex）
		{
			System.err.println（“conn.executeDelete:?“+?ex.getMessage（））;
		}
	}
public?int?executeUpdate（String?sql）
	{
	????int?n=0;
	try
		{
		conn=DriverManager.getConnection（sConnStr）;
		Statement?stmt=conn.createStatement（）;
		
		n=stmt.executeUpdate（sql）;
		}
		catch（SQLException?ex）
		{
			System.err.println（“conn.executeDelete:?“+?ex.getMessage（））;
		}
		return?n;
	}
public?void?Close（）
???{
????try{
???????if（rs!=null）
???????{
??????????rs.close（）;
???????}
???????if（conn!=null）
???????{
??????????conn.close（）;
????????}
???????}?
???????catch（SQLException?ex）
		{
			System.err.println（“conn.executeDelete:?“+?ex.getMessage（））;
		}

???}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-10-18?18:39??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\
?????目錄???????????0??2005-05-23?12:43??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\
?????文件?????????817??2005-04-01?21:19??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\2login.jsp
?????文件?????????870??2005-05-21?09:48??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\ac.jsp
?????文件?????????781??2004-03-06?00:10??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\ac2.jsp
?????文件???????12829??2005-04-02?00:13??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\addhw.jsp
?????文件????????3500??2005-04-02?00:13??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\addnews.jsp
?????文件????????4590??2005-04-01?21:16??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\addsort.jsp
?????文件????????1300??2004-02-19?16:15??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\addsort1.jsp
?????文件????????1307??2004-02-19?16:15??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\addsort2.jsp
?????文件????????1599??2005-04-02?00:14??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\adduser.jsp
?????文件?????????557??2004-02-25?16:46??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\adel.jsp
?????文件????????6867??2005-04-02?00:17??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\changehw.jsp
?????文件?????????741??2005-04-01?21:08??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\conn.jsp
?????文件????????6332??2004-02-21?20:57??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\delhw.jsp
?????文件????????4776??2004-02-20?21:51??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\delnews.jsp
?????文件????????1771??2004-02-20?22:03??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\editnews.jsp
?????文件????????1774??2004-02-20?22:16??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\editnewsok.jsp
?????文件????????3154??2004-02-20?23:07??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\gg.jsp
?????文件?????????453??2005-04-02?00:15??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\gg2.jsp
?????文件?????????382??2004-02-20?23:37??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\ggdel.jsp
?????文件????????4896??2004-02-21?00:14??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\guanggao.jsp
?????目錄???????????0??2015-07-19?16:35??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\images\
?????文件?????????137??2003-04-26?00:00??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\images\0.gif
?????文件?????????116??2003-04-26?00:00??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\images\1.gif
?????文件?????????106??2003-04-26?00:00??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\images\10.gif
?????文件?????????115??2003-04-26?00:00??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\images\11.gif
?????文件?????????107??2003-04-26?00:00??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\images\12.gif
?????文件?????????137??2003-04-26?00:00??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\images\13.gif
?????文件?????????122??2003-04-26?00:00??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\images\2.gif
?????文件?????????128??2003-04-26?00:00??JSP網(wǎng)上購物系統(tǒng)的實(shí)現(xiàn)（含源代碼）\admin\images\3.gif
............此處省略257個(gè)文件信息