package?db;
import?java.sql.Connection;
import?java.sql.Statement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.DriverManager;
import?java.io.*;
public?class?DB?{
	private?Connection?conn=null;
	private?Statement?stat=null;
????public?ResultSet?rs=null;

	public?void?connectMySQL（）?
	{
		String?url=“jdbc:mysql://localhost:3306/zheng“;
		String?user=“root“;
		String?psd=“java“;
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
		????conn?=?DriverManager.getConnection（url?user?psd）;
		????stat?=?conn.createStatement（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			
		}
	}
	
	
	public?ResultSet?query（String?sql）?throws?SQLException
	{
		if（sql==null||sql.equals（““））
		{
			return?null;
		}
		rs?=?stat.executeQuery（sql）;
		return?rs;
	}
	
	public?int?update（String?sql）?throws?SQLException
	{		
		int?i;
		if（sql==null||sql.equals（““））
		{
			return?0;
		}
		i=stat.executeUpdate（sql）;	
		return?i;
	}
	
	public?ResultSet?executeSQL（String?sql）?throws?SQLException{
		
		boolean?t;
		if（sql==null||sql.equals（““））
		{
			return?null;
		}
		t=stat.execute（sql）;
		if（t）{
			rs?=?stat.getResultSet（）;
			return?rs;
		}
		else{
			return?null;
		}		
	}
	
	public?void?closeDB（）?throws?SQLException
	{
		if（rs!=null）
		{
			rs.close（）;
			rs=null;
		}
		if（stat!=null）
		{
			stat.close（）;
			stat=null;
		}
		if（conn!=null）
		{
			conn.close（）;
			conn=null;
		}
	}
	
/*	
	public??static?void?main（String?arg[]）?throws?SQLExceptionIOException?InstantiationException?IllegalAccessException?ClassNotFoundException{
	?
		String?sql=“select?*?from?user“;
		
		DB?d=new?DB（）;
		
		d.connectMySQL（）;
		
		ResultSet?rs=d.query（sql）;
		
		if（rs!=null）{
		System.out.println（“success“）;
		while（rs.next（））{
			
			String?i=rs.getString（“username“）;
			System.out.println（i）;
			String?j=rs.getString（“password“）;
			System.out.println（j）;
			}
		}
		else{
			System.out.println（“Fail“）;
		}
		d.closeDB（）;
	
	}
*/

}

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

?????文件????????662??2012-08-27?17:41??JFreeChart\.classpath

?????文件???????1216??2012-07-26?10:37??JFreeChart\.myeclipse\profiler\AnnotationDemo2.xml

?????文件????????860??2012-07-28?09:33??JFreeChart\.myeclipse\profiler\PieChartDemo7.xml

?????文件????????303??2012-05-08?11:22??JFreeChart\.mymetadata

?????文件???????1753??2012-05-08?15:42??JFreeChart\.project

?????文件????????493??2012-05-08?11:22??JFreeChart\.settings\.jsdtscope

?????文件????????395??2012-05-08?11:22??JFreeChart\.settings\org.eclipse.jdt.core.prefs

?????文件????????468??2012-07-29?17:14??JFreeChart\.settings\org.eclipse.wst.common.component

?????文件????????252??2012-05-08?11:22??JFreeChart\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2012-05-08?11:22??JFreeChart\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2012-05-08?11:22??JFreeChart\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2068??2012-07-11?09:24??JFreeChart\src\db\DB.java

?????文件???????5492??2012-07-12?21:24??JFreeChart\src\db\useDB.java

?????文件???????1768??2012-07-29?17:35??JFreeChart\src\LCCsystem\LCClogin.java

?????文件???????1968??2012-07-31?10:23??JFreeChart\src\LCCsystem\modifyCost1.java

?????文件???????1952??2012-07-31?11:15??JFreeChart\src\LCCsystem\modifyCost2.java

?????文件???????2370??2012-07-30?11:38??JFreeChart\src\LCCsystem\modifyPasswd1.java

?????文件???????7109??2012-07-06?17:45??JFreeChart\src\org\jfree\chart\demo\AnnotationDemo2.java

?????文件???????2674??2012-07-05?17:33??JFreeChart\src\org\jfree\chart\demo\NormalDistributionDemo.java

?????文件???????2362??2012-07-28?11:00??JFreeChart\src\org\jfree\chart\demo\PieChartDemo7.java

?????文件???????1495??2012-07-16?10:35??JFreeChart\src\servlet\deleteFruit.java

?????文件???????2187??2012-08-22?11:22??JFreeChart\src\servlet\insertFruit.java

?????文件???????1628??2012-07-16?16:58??JFreeChart\src\servlet\modifyFruit.java

?????文件???????2259??2012-07-13?16:18??JFreeChart\src\servlet\modifyPasswd.java

?????文件???????2437??2012-07-20?15:27??JFreeChart\src\servlet\queryFruit.java

?????文件???????1765??2012-07-13?11:15??JFreeChart\src\servlet\userLogin.java

?????文件???????2795??2012-07-12?20:06??JFreeChart\src\test\ChartUtil.java

?????文件??????12554??2012-09-17?19:29??JFreeChart\src\test\DianYaMoNiTu.java

?????文件???????5560??2012-08-01?17:33??JFreeChart\src\test\ReturnLcc1.java

?????文件???????5565??2012-08-01?18:14??JFreeChart\src\test\ReturnLcc2.java

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