src/com/bean/KcBean.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.bean;

import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;

import com.util.Constant;
import com.util.DBO;

public class KcBean {

	private List list;
	private ResultSet rs = null;
	//声明时间变量
	String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());
	//add kecheng
	public int addKc(String title,String sktime,String place,String teacher,String intro,String student ){
		String sql ="insert into lesson (title,sktime,place,teacher,intro,student,addtime)" +
				"values('"+title+"','"+sktime+"','"+place+"','"+teacher+"','"+intro+"','"+student+"','"+date+"')";
		DBO dbo = new DBO();
		dbo.open();
		try{
				int i = dbo.executeUpdate(sql);
				if(i == 1){
					return Constant.SUCCESS;
				}
				else{
					return Constant.SYSTEM_ERROR;
				}
		
		}catch(Exception e){
			e.printStackTrace();
			return Constant.SYSTEM_ERROR;
		}finally{
			dbo.close();
		}
	}
	//up kecheng
	public int upKc(int id,String title,String sktime,String place,String teacher,String intro,String student ){
		String sql ="update lesson set title='"+title+"',sktime='"+sktime+"',place='"+place+"',teacher='"+teacher+"',intro='"+intro+"'," +
				"student='"+student+"' where id='"+id+"'";
		DBO dbo = new DBO();
		dbo.open();
		try{
				int i = dbo.executeUpdate(sql);
				if(i == 1){
					return Constant.SUCCESS;
				}
				else{
					return Constant.SYSTEM_ERROR;
				}
		
		}catch(Exception e){
			e.printStackTrace();
			return Constant.SYSTEM_ERROR;
		}finally{
			dbo.close();
		}