course.java

来自「学生/教师信息管理系统,用JSP+ACCESS开发」· Java 代码 · 共 37 行

 package stu;
 
 import java.sql.*;

public class course {  
  private String id;
  public String getId() {
    return id;
  }
  public void setId(String id) {
    this.id = id;
  }
  public ResultSet  getCourse(){         //察看所有课程
		String sql="select * from course   ";
		sqlBean db= new sqlBean();
		ResultSet rs = db.executeQuery(sql);
		 return rs;
		                         }
    public void deleteCourse(){   	
    	String sql="delete  from Course where id ='"+id+"' ";
    	sqlBean db= new sqlBean();
    	db.executeDelete(sql);
    	}                                           	
 	
    public boolean isLogin(){
    	boolean f=true;
    	String sql="select id from course where id='"+id+"'  ";
    	sqlBean db = new sqlBean();
    	try{
    	ResultSet rs =db.executeQuery(sql);
    	if(rs.next())
    	{f=false;}
          }catch(Exception e){ e.getMessage();}
    	return f;   
    	}
}