package?com.data;
import?java.sql.*;

public?class?ConDatabase?{
	private?Connection?con=?null;

	//連接數據庫
	public?void?ConnData（String?userString?password）{
		String?url=“jdbc:sqlserver://localhost:1433;DatabaseName=MoviePrebuy“;
		try{
		????Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
		????con=DriverManager.getConnection（urluserpassword）;
		}catch（Exception?e）{
			System.err.println（“錯誤的原因是“+e.getMessage（））;
		}
	}
	
	//查找
	public?ResultSet?executeQuery（String?sql）{
????????Statement?stmt=null;
????????ResultSet?rs=null;
		try{
			stmt=con.createStatement（）;
			rs=stmt.executeQuery（sql）;
			return?rs;
		}catch（SQLException?e）{
			e.printStackTrace（）;
		}
		return?null;
	}
	
	//更新
	public?void?executeUpdate（String?sql）?throws?SQLException{
		Statement?stmt=null;
		try{
			stmt=con.createStatement（）;
			stmt.executeUpdate（sql）;
		}catch（SQLException?e）{
			e.printStackTrace（）;
			throw?e;
		}
	}
	
	/*
????//關閉語句
	public?void?closeStatement（）{
		if（stmt!=null）{
		???try{
			??stmt.close（）;
		???}
		???catch（SQLException?e）{
			e.printStackTrace（）;
		???}
		}
	}
	
????//關閉結果集
	public?void?closeResult（）{
		if（rs!=null）{
		???try{
			??rs.close（）;
		???}
		???catch（SQLException?e）{
			e.printStackTrace（）;
		???}
		}
	}
	*/
	
	//關閉連接
	public?void?CloDatabase（）{
		if（con!=null）{
			try{
				con.close（）;
			}catch（Exception?e）{
				System.err.println（“錯誤的原因是“+e.getMessage（））;
			}
		}
	}
	
}

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

?????文件????????335??2013-12-29?10:13??MovieSystem\.classpath

?????文件????????507??2013-12-29?10:13??MovieSystem\.project

?????文件???????2186??2014-01-19?15:39??MovieSystem\com\data\ConDatabase.class

?????文件???????1547??2013-12-29?10:13??MovieSystem\com\data\ConDatabase.java

?????文件???????1908??2014-01-19?15:39??MovieSystem\com\data\Movie.class

?????文件???????1288??2013-12-29?10:13??MovieSystem\com\data\Movie.java

?????文件????????725??2014-01-19?15:39??MovieSystem\com\func\ImagePanel.class

?????文件????????386??2013-12-29?10:13??MovieSystem\com\func\ImagePanel.java

?????文件???????2305??2014-01-19?15:39??MovieSystem\com\func\JImagePane.class

?????文件???????4923??2013-12-29?10:13??MovieSystem\com\func\JImagePane.java

?????文件???????1867??2014-01-19?15:39??MovieSystem\com\func\Resize.class

?????文件???????1254??2013-12-29?10:13??MovieSystem\com\func\Resize.java

?????文件???????4038??2014-01-19?15:39??MovieSystem\com\interfaces\AlterUser$1.class

?????文件???????1034??2014-01-19?15:39??MovieSystem\com\interfaces\AlterUser$2.class

?????文件???????1141??2014-01-19?15:39??MovieSystem\com\interfaces\AlterUser$3.class

?????文件???????1200??2014-01-19?15:39??MovieSystem\com\interfaces\AlterUser$4.class

?????文件???????5474??2014-01-19?15:39??MovieSystem\com\interfaces\AlterUser.class

?????文件??????10700??2013-12-29?10:13??MovieSystem\com\interfaces\AlterUser.java

?????文件????????888??2014-01-19?15:39??MovieSystem\com\interfaces\FrmMain$1.class

?????文件???????2694??2014-01-19?15:39??MovieSystem\com\interfaces\FrmMain$10.class

?????文件????????895??2014-01-19?15:39??MovieSystem\com\interfaces\FrmMain$2.class

?????文件???????1019??2014-01-19?15:39??MovieSystem\com\interfaces\FrmMain$3.class

?????文件???????2273??2014-01-19?15:39??MovieSystem\com\interfaces\FrmMain$4.class

?????文件???????1642??2014-01-19?15:39??MovieSystem\com\interfaces\FrmMain$5.class

?????文件???????1763??2014-01-19?15:39??MovieSystem\com\interfaces\FrmMain$6.class

?????文件???????1024??2014-01-19?15:39??MovieSystem\com\interfaces\FrmMain$7.class

?????文件????????821??2014-01-19?15:39??MovieSystem\com\interfaces\FrmMain$8.class

?????文件???????1287??2014-01-19?15:39??MovieSystem\com\interfaces\FrmMain$9.class

?????文件???????9598??2014-01-19?15:39??MovieSystem\com\interfaces\FrmMain.class

?????文件??????15797??2013-12-29?10:33??MovieSystem\com\interfaces\FrmMain.java

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