coursewarebean.java

在线教育平台： 从小学

package edu;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;


public class CoursewareBean {
	private int id;
	private String title;
	private String content;
	private String filename;
	private int grade_id;
	private int class_id;
	private int subject_id;
	private String uploadtime;
	private int u_id;
	private String sort;
	private int filesize;
	private String fileext;
public int getClass_id() {
	return class_id;
}
public void setClass_id(int class_id) {
	this.class_id = class_id;
}
public String getContent() {
	return content;
}
public void setContent(String content) {
	this.content = content;
}
public String getFilename() {
	return filename;
}
public void setFilename(String filename) {
	this.filename = filename;
}
public int getGrade_id() {
	return grade_id;
}
public void setGrade_id(int grade_id) {
	this.grade_id = grade_id;
}
public int getId() {
	return id;
}
public void setId(int id) {
	this.id = id;
}
public String getSort() {
	return sort;
}
public void setSort(String sort) {
	this.sort = sort;
}
public int getSubject_id() {
	return subject_id;
}
public void setSubject_id(int subject_id) {
	this.subject_id = subject_id;
}
public String getTitle() {
	return title;
}
public void setTitle(String title) {
	this.title = title;
}
public int getU_id() {
	return u_id;
}
public void setU_id(int u_id) {
	this.u_id = u_id;
}
public String getUploadtime() {
	return uploadtime;
}
public void setUploadtime(String uploadtime) {
	this.uploadtime = uploadtime;
}
public String getFileext() {
	return fileext;
}
public void setFileext(String fileext) {
	this.fileext = fileext;
}
public int getFilesize() {
	return filesize;
}
public void setFilesize(int filesize) {
	this.filesize = filesize;
}

public int addcourseware() {
	int f=0;
	String sql = "insert into courseware (title,content,filename,filesize,fileext,grade_id,class_id,subject_id,uploadtime,u_id,sort) values( ";
	if(getTitle()==null){
		sql = sql + "'',";
	}else sql=sql+ "'" + getTitle() + "',";
	if(getContent()==null){
		sql=sql+"'',";
	}else sql=sql+"'"+getContent()+"',";
	if(getFilename()==null){
		sql=sql+"'',";
	}else sql=sql+"'"+getFilename()+"',";
	if(getFilesize()==0){
		sql=sql+"0,";
	}else sql=sql+"'"+getFilesize()+"',";
	if(getFileext()==null){
		sql=sql+"'',";
	}else sql=sql+"'"+getFileext()+"',";
	if(getGrade_id()==0){
		sql=sql+"0,";
	}else sql=sql+"'"+getGrade_id()+"',";
	if(getClass_id()==0){
		sql=sql+"0,";
	}else sql=sql+"'"+getClass_id()+"',";
	if(getSubject_id()==0){
		sql=sql+"0,";
	}else sql=sql+"'"+getSubject_id()+"',";
	if(getUploadtime()==null){
		sql=sql+"'',";
	}else sql=sql+"'"+getUploadtime()+"',";
	if(getU_id()==0){
		sql=sql+"0,";
	}else sql=sql+"'"+getU_id()+"',";
	if(getSort()==null){
		sql=sql+"'')";
	}else sql=sql+"'"+getSort()+"')";
	SqlBean db = new SqlBean();
	f=db.executeInsert(sql);
	return f;
}
public ResultSet getcourseware(){
	String sql="select * from courseware";
	SqlBean db = new SqlBean();
	ResultSet rs=db.executeQuery(sql);
	return rs;
}

public List getcwlist(){
	ArrayList paraList = new ArrayList();
	CoursewareBean cw=new CoursewareBean();
	ResultSet rs=cw.getcourseware();
	
	try{
	while(rs.next()){
		cw=new CoursewareBean();
		cw.setId(rs.getInt("id"));
		cw.setTitle(rs.getString("title"));
		cw.setContent(rs.getString("content"));
		cw.setFilename(rs.getString("filename"));
		cw.setGrade_id(rs.getInt("grade_id"));
		cw.setClass_id(rs.getInt("class_id"));
		cw.setSubject_id(rs.getInt("subject_id"));
		cw.setUploadtime(rs.getString("uploadtime"));
		cw.setU_id(rs.getInt("u_id"));
		cw.setSort(rs.getString("sort"));
		cw.setFilesize(rs.getInt("filesize"));
		cw.setFileext(rs.getString("fileext"));
		paraList.add(cw);
		
	}
	rs.close();
	}catch(SQLException e){
		
	}catch(NullPointerException e){
		
	}
	
	return paraList;
}
public List getcwlist(int u_id,String sort){
	ArrayList paraList = new ArrayList();
	String sql="select * from courseware where u_id='"+u_id+"'and sort='"+sort+"'";
	SqlBean db = new SqlBean();
	ResultSet rs=db.executeQuery(sql);
	CoursewareBean cw=new CoursewareBean();
	try{
		while(rs.next()){
			cw=new CoursewareBean();
			cw.setId(rs.getInt("id"));
			cw.setTitle(rs.getString("title"));
			cw.setContent(rs.getString("content"));
			cw.setFilename(rs.getString("filename"));
			cw.setGrade_id(rs.getInt("grade_id"));
			cw.setClass_id(rs.getInt("class_id"));
			cw.setSubject_id(rs.getInt("subject_id"));
			cw.setUploadtime(rs.getString("uploadtime"));
			cw.setU_id(rs.getInt("u_id"));
			cw.setSort(rs.getString("sort"));
			cw.setFilesize(rs.getInt("filesize"));
			cw.setFileext(rs.getString("fileext"));
			paraList.add(cw);
			
		}
		rs.close();
		}catch(SQLException e){
			
		}catch(NullPointerException e){
			
		}
		
		return paraList;
}
public CoursewareBean getcourseware(int id){
	CoursewareBean cw=null;
	String sql="select * from courseware where id="+id;
	SqlBean db = new SqlBean();
	ResultSet rs=db.executeQuery(sql);
	try{
		if(rs.next()){
			cw=new CoursewareBean();
			cw.setId(rs.getInt("id"));
			cw.setTitle(rs.getString("title"));
			cw.setContent(rs.getString("content"));
			cw.setFilename(rs.getString("filename"));
			cw.setGrade_id(rs.getInt("grade_id"));
			cw.setClass_id(rs.getInt("class_id"));
			cw.setSubject_id(rs.getInt("subject_id"));
			cw.setUploadtime(rs.getString("uploadtime"));
			cw.setU_id(rs.getInt("u_id"));
			cw.setSort(rs.getString("sort"));
			cw.setFilesize(rs.getInt("filesize"));
			cw.setFileext(rs.getString("fileext"));
		}
		rs.close();
	}catch(SQLException e){
		
	}
	return cw;
}
public int delcourseware(int id){
	int f=0;
	String sql="delete  from courseware where id="+id;
	SqlBean db = new SqlBean();
	 f=db.executeDelete(sql);
	return f;
}
public int updatecourseware(int id){
	int f=0;
	String sql="update courseware set title='"+title+"',content='"+content+"' where id="+id;
	SqlBean db = new SqlBean();
	 f=db.executeDelete(sql);
	return f;
}
}