package?ckstudio.db;
import?java.sql.*;
public?class?mysqlconn?{
String?sDBDriver?=?“com.mysql.jdbc.Driver“;
//請修改下面參數--數據地址：localhost?數據庫名：jspshop?用戶名:root?密碼：
String?sConnStr?=?“jdbc:mysql://localhost:3306/jspshop“;
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“root““123“）;
		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“root““123“）;?
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（））;
		}

???}
}

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

?????文件????????648??2011-06-29?09:50??jspshop\jspshop\jspshop（mysql版）安裝與使用方法.txt

?????文件????????455??2011-06-25?12:57??jspshop\jspshop\jspshoping\.classpath

?????文件????????297??2011-07-07?16:01??jspshop\jspshop\jspshoping\.mymetadata

?????文件???????1281??2011-06-25?13:01??jspshop\jspshop\jspshoping\.project

?????文件????????500??2011-06-25?17:03??jspshop\jspshop\jspshoping\.settings\.jsdtscope

?????文件????????724??2011-06-25?13:35??jspshop\jspshop\jspshoping\.settings\org.eclipse.core.resources.prefs

?????文件????????330??2011-06-25?12:53??jspshop\jspshop\jspshoping\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2011-06-25?17:03??jspshop\jspshop\jspshoping\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-06-25?17:03??jspshop\jspshop\jspshoping\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件?????232276??2011-06-29?09:44??jspshop\jspshop\jspshoping\jspshop.sql

?????文件???????2024??2011-06-25?17:27??jspshop\jspshop\jspshoping\src\ckstudio\db\mysqlconn.java

?????文件???????2025??2011-06-25?17:27??jspshop\jspshop\jspshoping\src\ckstudio\db\mysqlconn2.java

?????文件????????817??2005-04-01?21:19??jspshop\jspshop\jspshoping\WebRoot\admin\2login.jsp

?????文件????????813??2011-06-25?13:47??jspshop\jspshop\jspshoping\WebRoot\admin\ac.jsp

?????文件????????781??2011-06-25?12:55??jspshop\jspshop\jspshoping\WebRoot\admin\ac2.jsp

?????文件??????12829??2011-06-25?12:55??jspshop\jspshop\jspshoping\WebRoot\admin\addhw.jsp

?????文件???????3500??2011-06-25?12:55??jspshop\jspshop\jspshoping\WebRoot\admin\addnews.jsp

?????文件???????4590??2011-06-25?12:55??jspshop\jspshop\jspshoping\WebRoot\admin\addsort.jsp

?????文件???????1300??2011-06-25?12:55??jspshop\jspshop\jspshoping\WebRoot\admin\addsort1.jsp

?????文件???????1307??2011-06-25?12:55??jspshop\jspshop\jspshoping\WebRoot\admin\addsort2.jsp

?????文件???????1599??2011-06-25?12:55??jspshop\jspshop\jspshoping\WebRoot\admin\adduser.jsp

?????文件????????557??2011-06-25?12:55??jspshop\jspshop\jspshoping\WebRoot\admin\adel.jsp

?????文件???????6867??2011-06-25?12:55??jspshop\jspshop\jspshoping\WebRoot\admin\changehw.jsp

?????文件????????826??2011-06-25?13:01??jspshop\jspshop\jspshoping\WebRoot\admin\conn.jsp

?????文件???????6332??2011-06-25?12:55??jspshop\jspshop\jspshoping\WebRoot\admin\delhw.jsp

?????文件???????4776??2011-06-25?12:55??jspshop\jspshop\jspshoping\WebRoot\admin\delnews.jsp

?????文件???????1771??2011-06-25?12:55??jspshop\jspshop\jspshoping\WebRoot\admin\editnews.jsp

?????文件???????1774??2011-06-25?12:55??jspshop\jspshop\jspshoping\WebRoot\admin\editnewsok.jsp

?????文件???????3154??2011-06-25?12:55??jspshop\jspshop\jspshoping\WebRoot\admin\gg.jsp

?????文件????????453??2011-06-25?12:55??jspshop\jspshop\jspshoping\WebRoot\admin\gg2.jsp

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