classcoursetable.java

来自「这是一个可以在手机客户端运行的选课系统 这个是客户端」· Java 代码 · 共 54 行

package jdbc;

import java.sql.*;
import exception.*;

public class ClassCourseTable
{
	private String command=null;
	private Statement statement=null;
	
	public ClassCourseTable(Statement statement)
	{
		this.statement=statement;	
	}
	
	public int insert(String classID,String course) throws SQLException
	{
		command="INSERT INTO ClassCourseTable VALUES ('"+classID+"'"+",'"+course+"')";
		return statement.executeUpdate(command);
	}
	
	public int delete(String classID) throws SQLException
	{
		command="DELETE FROM ClassCourseTable WHERE classID='"+classID+"'";		
		return statement.executeUpdate(command);
	}
	
	public int updateCourse(String classID,int day,int courseNum,String course) throws SQLException,DateException
	{
		String weekday=null;
		switch(day)
		{
			case '1':weekday="Mon";break;
			case '2':weekday="Tue";break;
			case '3':weekday="Wen";break;
			case '4':weekday="Thu";break;
			case '5':weekday="Fri";break;
			case '6':weekday="Sat";break;
			case '7':weekday="Sun";break;
			default:throw new DateException();
		}
		command="UPDATE ClassCourseTable SET "+weekday+""+courseNum+"='"+course+"' WHERE classID='"+classID+"'";
		return statement.executeUpdate(command);	
	}
	
	public ResultSet select(String classID) throws SQLException
	{
		if(classID==null)
			command="SELECT * FROM ClassCourseTable";
		else	
			command="SELECT * FROM ClassCourseTable WHERE classID='"+classID+"'";
		return statement.executeQuery(command);
	}
}