package?cheshi;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

import?junit.framework.TestCase;

public?class?Test?extends?TestCase?{

	public?void?testSelect（）{
		String?SQL=“insert?into?test_admin?values（‘test‘‘test‘‘test‘8）“;
		Connection?conn?=?null;
		Statement?stmt?=?null;
		ResultSet?rs?=null;
		try?{
			Class.forName（“oracle.jdbc.driver.OracleDriver“）;
			conn?=?DriverManager.getConnection（
					“jdbc:oracle:thin:@localhost:1521:orcl“?“scott“?“tiger“）;
			stmt=conn.createStatement（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		try?{
			if（stmt.executeUpdate（SQL）?>?0）{
				System.out.println（“insert?OK!“）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
	}
}

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

?????文件???????1222??2008-12-27?11:52??test\.project

?????文件???????4530??2008-12-28?11:00??test\src\test\InsertTestData.java

?????文件???????6614??2008-12-28?10:09??test\src\test\GenPaperServlet.java

?????文件???????1462??2008-12-28?12:37??test\src\test\ConnOracle.java

?????文件???????1062??2008-12-30?18:17??test\src\cheshi\Test.java

?????文件????1600198??2008-12-22?20:21??test\WebRoot\WEB-INF\lib\classes12.jar

?????文件???????4635??2008-12-29?18:52??test\WebRoot\WEB-INF\classes\test\InsertTestData.class

?????文件???????6048??2008-12-29?18:52??test\WebRoot\WEB-INF\classes\test\GenPaperServlet.class

?????文件???????2179??2008-12-29?18:52??test\WebRoot\WEB-INF\classes\test\ConnOracle.class

?????文件????????565??2008-12-30?18:17??test\WebRoot\WEB-INF\classes\cheshi\Test.class

?????文件???????1349??2008-12-28?11:08??test\WebRoot\WEB-INF\web.xml

?????文件?????????39??2008-12-27?09:47??test\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1732??2008-12-28?12:15??test\WebRoot\index.htm

?????文件???????1436??2005-09-04?17:55??test\WebRoot\test\chkstudent.jsp

?????文件???????1422??2005-09-04?17:55??test\WebRoot\test\exam.jsp

?????文件???????7218??2008-12-28?12:03??test\WebRoot\test\exam2.jsp

?????文件???????3576??2005-09-04?17:55??test\WebRoot\test\getscore.jsp

?????文件??????10844??2008-12-27?12:36??test\WebRoot\register\RegistStudent.jsp

?????文件??????12784??2005-09-04?17:55??test\WebRoot\register\index.htm

?????文件????????157??2005-09-04?17:55??test\WebRoot\public\checkvalidadmin.jsp

?????文件????????159??2005-09-04?17:55??test\WebRoot\public\checkvalidadmin8.jsp

?????文件????????160??2005-09-04?17:55??test\WebRoot\public\checkvalidstudent.jsp

?????文件????????563??2008-12-29?19:35??test\WebRoot\public\dberror.jsp

?????文件????????515??2008-12-29?19:35??test\WebRoot\public\error.JSP

?????文件????????691??2005-09-04?17:55??test\WebRoot\public\style.css

?????文件????????360??2005-09-04?17:55??test\WebRoot\images\addfav.gif

?????文件??????15333??2005-09-04?17:55??test\WebRoot\images\bg3.gif

?????文件???????1200??2005-09-04?17:55??test\WebRoot\images\bg_1.gif

?????文件????????131??2005-09-04?17:55??test\WebRoot\images\botleft.gif

?????文件?????????95??2005-09-04?17:55??test\WebRoot\images\botmid.gif

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