import?java.util.*;
import?java.io.*;
import?java.text.*;
import?java.sql.*;

/**
?*?A?class?representing?the?driver?program?to?the
?*?SSD7?transaction?exercise.
?*
?*?@author?iCarnegie
?*?@version?1.0
?*/

public?class?MovieTransaction
{
????/**
?????*?main?method.
?????*
?????*/
????public?static?void?main（?String?[]?args?）
????{
	
	String?[]?movienames?=?new?String[10];
	String?[]?movietimes?=?new?String[10];
	String?sqlquery?=?null;
	String?moviename?=?null;
	String?movietime?=?null;
	ResultSet?rset?=?null;
	Connection?conn?=?null;
	Statement?stmt?=?null;
	BufferedReader?keyIn?=?null;
	String?url?=?“jdbc:postgresql:movie“;
	String?username?=?“webuser“;
	String?password?=?“webuser“;
	int?position?=?0?choice?movie_id?numseats?availableseats;
	
	try
	????{
		//?Create?a?BufferedReader?to?read?input?from?the?keyboard.
		keyIn?=?new?BufferedReader（new?InputStreamReader（System.in））;
		
		//?Load?the?PostgreSQL?JDBC?driver
		Class.forName（“org.postgresql.Driver“）;

		//?Create?a?connection?to?the?database.
		conn?=?DriverManager.getConnection（?url?usernamepassword?）;

		//?Turn?off?autocommit?at?each?statement.?We?will?manually?commit.
		//?Set?the?transaction?isolation?level?to?serializable
		conn.setAutoCommit（false）;
		conn.setTransactionIsolation（Connection.TRANSACTION_SERIALIZABLE）;

		//?Create?a?statement?object.
		stmt?=?conn.createStatement（）;

		System.out.println（?“Welcome?to?the?movie?theater!“?）;
		
		//?Query?the?titles?currently?playing.
		String?SQLQuery?=?“select?distinct?title?from?movie“;
		rset?=?stmt.executeQuery（?SQLQuery?）;
		while（?rset.next（）?）
		????{
			movienames[rset.getRow（）]?=?rset.getString（?“title“?）;
			System.out.println（?rset.getRow（）?+?“:?“?+?rset.getString（“title“）?）;
		????}
		
		//?Ask?the?user?what?movie?he?wants?to?see.
		System.out.print（?“Enter?the?number?of?the?movie?you?want?to?see:“?）;
		choice?=?Integer.parseInt（keyIn.readLine（））;
		moviename?=?movienames[（choice）];
		
		//?Query?the?id?for?this?movie.
		sqlquery?=?new?String（?“select?movie_id?from?movie?where?title=‘“?+?moviename?+?“‘“?）;
		rset?=?stmt.executeQuery（?sqlquery?）;
		rset.next（）;
		movie_id?=?rset.getInt（?“movie_id“?）;
		
		//?Query?the?available?times?for?the?chosen?movie.
		sqlquery?=?new?String（?“select?distinct?movie_time?from?showing?where?movie_id?=“?+?movie_id?）;
		rset?=?stmt.executeQuery（?sqlquery?）;
		while（?rset.next（）?）?{
			movietimes[（rset.getRow（））]?=?rset.getString（?“movie_time“?）;
????????????????????????	System.out.println（?rset.getRow（）?+?“:?“?+?rset.getString（?“movie_time“?）?）;
????????????????????	}
		//?Ask?the?user?what?showing?he?wants?to?see.
		System.out.println（?“Enter?the?number?of?the?time?you?want?to?see:?“?）;
		choice?=?Integer.parseInt（?keyIn.readLine（）?）;
		movietime?=?movietimes[（choice）];

		//?Ask?the?user?how?many?seats?he?wants.
		System.out.println（?“Please?enter?the?number?of?seats?that?you?want?to?buy:?“

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

?????文件???????3952??2013-10-01?20:45??EX1\BookPublisher.html

?????文件???????1999??2013-10-09?19:14??EX1\createDB.sql

?????文件????????210??2013-10-01?20:39??EX1\part3.txt

?????文件????????251??2013-10-01?20:04??EX1\Rel-ops.txt

?????文件???????6452??2013-10-13?10:33??EX2\createLibraryPostgreSQL.sql

?????文件???????2160??2013-10-13?12:09??EX2\Ex2.sql

?????文件???????2246??2013-10-15?15:09??EX3\alter_tables.sql

?????文件???????1622??2013-10-28?19:15??EX3\createDBPostgreSQL.sql

?????文件?????????64??2013-10-14?09:30??EX3\delete_rows.sql

?????文件??????10153??2013-10-13?10:33??EX3\insertRowsPostgreSQL.sql

?????文件???????2486??2013-10-28?19:20??EX3\queries.sql

?????文件??????26213??2013-11-25?20:53??EX5\E-R.GIF

????..A.SH.?????20992??2013-11-24?19:38??EX5\Thumbs.db

?????文件??????11587??2013-11-25?20:51??EX5\wy.class.violet

?????文件???????1648??2013-11-28?08:29??EX6\normalization.txt

????I.A....??????2547??2013-12-16?20:33??EX7\relational-model.sql

????I.A....??????4626??2013-12-16?20:31??EX7\relational-schema.txt

?????文件???????3435??2013-12-29?19:25??EX9\bank.txt

?????文件???????1056??2013-12-23?12:22??EX9\build_trans_db.sql

?????文件????????753??2013-10-13?10:33??EX9\create_movie.sql

?????文件???????1928??2013-12-23?13:12??EX9\deadlock.txt

?????文件?????125952??2013-10-13?10:33??EX9\EX9.doc

?????文件???????1686??2013-12-23?12:07??EX9\isolation.txt

?????文件???????4839??2013-10-13?10:33??EX9\MovieTransaction.java

?????文件????????986??2013-12-23?10:49??EX9\rollback.txt

?????文件???????7667??2014-01-06?09:37??EX10\indexes.txt

?????文件???????2242??2013-10-28?20:08??EXAM1\exam1.sql

?????目錄??????????0??2013-10-11?16:42??EX1

?????目錄??????????0??2013-10-13?10:35??EX2

?????目錄??????????0??2014-01-06?11:00??EX3

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