package?JDBC;

import?java.sql.Connection;
import?java.sql.PreparedStatement;

/*
這是插入課程的類
?*/
import?Util.course;

public?class?addcoursesql?{
	private?course?Sc;
	private?Connection?conn;
	private?int?i;

	public?addcoursesql（course?Sc）?{
		this.conn?=?user.CONN（）;
		this.Sc?=?Sc;

		String?sql?=?“insert?into?course?values（????????）“;
		try?{
			PreparedStatement?stmt?=?conn.prepareStatement（sql）;
			stmt.setString（1?Sc.getNo（））;
			stmt.setString（2?Sc.getName（））;
			stmt.setFloat（3?Sc.getCredit（））;
			stmt.setString（4?Sc.getType（））;
			stmt.setString（5?Sc.getTeacher（））;
			stmt.setInt（6?Sc.getBegin（））;
			stmt.setInt（7?Sc.getEnd（））;
			stmt.setInt（8?Sc.getLast（））;
			i?=?stmt.executeUpdate（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}

	}

	public?int?getI（）?{
		return?i;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-07-21?16:33??報告\
?????文件??????520192??2019-07-21?16:33??報告\學生選課管理系統報告.doc
?????目錄???????????0??2019-07-21?16:30??數據庫\
?????文件????????4412??2019-07-12?11:49??數據庫\Course_Mananger.sql
?????目錄???????????0??2019-07-21?16:30??源代碼\
?????目錄???????????0??2019-07-21?16:30??源代碼\JDBC\
?????文件?????????866??2019-07-04?14:08??源代碼\JDBC\addcoursesql.java
?????文件?????????770??2019-07-04?14:08??源代碼\JDBC\addstudentsql.java
?????文件?????????488??2019-07-04?14:08??源代碼\JDBC\deletecoursesql.java
?????文件?????????729??2019-07-04?14:27??源代碼\JDBC\deletescsqlfor.java
?????文件?????????751??2019-07-04?14:08??源代碼\JDBC\deletestudentsql.java
?????文件?????????742??2019-07-04?14:08??源代碼\JDBC\select_lessonsql.java
?????文件????????3707??2019-07-04?14:46??源代碼\JDBC\selectsql.java
?????文件?????????923??2019-07-04?14:08??源代碼\JDBC\updatecoursesql.java
?????文件?????????832??2019-07-04?14:08??源代碼\JDBC\updatestudentsql.java
?????文件????????1477??2019-07-04?13:44??源代碼\JDBC\user.java
?????目錄???????????0??2019-07-21?16:30??源代碼\UI\
?????文件????????3778??2019-07-04?10:31??源代碼\UI\addcourse.java
?????文件????????2869??2019-07-02?19:02??源代碼\UI\addstudent.java
?????文件????????2999??2019-07-02?19:04??源代碼\UI\adminUI.java
?????文件????????1376??2019-07-03?10:48??源代碼\UI\delete_lessonforadmin.java
?????文件????????1282??2019-07-03?10:45??源代碼\UI\delete_lessonforstudent.java
?????文件????????1766??2019-07-04?14:31??源代碼\UI\deletecourse.java
?????文件????????2072??2019-07-03?09:32??源代碼\UI\deletestudent.java
?????文件????????2991??2019-07-03?11:31??源代碼\UI\LoginUI.java
?????文件????????2804??2019-07-03?10:56??源代碼\UI\select_lesson.java
?????文件????????2149??2019-07-04?11:16??源代碼\UI\select_sc.java
?????文件????????2442??2019-07-04?14:46??源代碼\UI\sselect_lesson.java
?????文件????????1772??2019-07-04?11:07??源代碼\UI\studentUI.java
?????文件????????3557??2019-07-02?19:06??源代碼\UI\updatecourse.java
?????文件????????2919??2019-07-03?09:09??源代碼\UI\updatestudent.java
............此處省略5個文件信息