coursetable.java

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

/*
 * 创建日期 2005-3-11
 *
 * 更改所生成文件模板为
 * 窗口 > 首选项 > Java > 代码生成 > 代码和注释
 */
package jdbc;
import java.sql.*;

/**
 * @author Owner
 *
 * 更改所生成类型注释的模板为
 * 窗口 > 首选项 > Java > 代码生成 > 代码和注释
 */
public class CourseTable
{
	private String command=null;
	private Statement statement=null;
	
	public CourseTable(Statement statement)
	{
		this.statement=statement;
	}
	
	public int insert(int courseID,int number) throws SQLException
	{
		command="INSERT INTO"+" CourseTable" +" VALUES (courseID,number,0)";
		return statement.executeUpdate(command);
	}
	
	public void delete(int courseID) throws SQLException
	{
		if(courseID<0)
			command="DELETE FROM CourseTable";
		else
			command="DELETE FROM CourseTable WHERE CourseID="+courseID;
	    statement.executeUpdate(command);
	}
	
	public void updateIncrease(int courseID) throws SQLException
	{
		command="UPDATE CourseTable SET StudentChosen=StudentChosen+1 WHERE CourseID="+courseID;
       	statement.executeUpdate(command);
	}
	public void updateDecrease(int courseID) throws SQLException
	{
		command="UPDATE CourseTable SET StudentChosen=StudentChosen-1 WHERE CourseID="+courseID;
		statement.executeUpdate(command);
	}
	
	public ResultSet select(int courseID) throws SQLException
	{	
		if(courseID<0)
			command="SELECT * FROM CourseTable";
		else
			command="SELECT * FROM CourseTable WHERE CourseID="+courseID;
	    return statement.executeQuery(command);
	}
}