inoutsql.java

来自「改代码是采用JSP实现的在线办公自动化管理系统」· Java 代码 · 共 29 行

package swing;

import java.util.Date;

public class Inoutsql{
	
	public String manager;
	public String result;
	public String begintime;
	public String endtime;
	public String person;
	public String outtime;
	
	public String toSql(String manager,String result,String begintime,String endtime,String person,String outtime){
		
		this.manager=manager;
		this.result=result;
		this.begintime=begintime;
		this.endtime=endtime;
		this.person=person;
		this.outtime=outtime;
		
		String sql="insert into tb_leave(person,begintime,endtime,leavetime,reader,result,type,overread)" +
					"values('"+person+"','"+begintime+"','"+endtime+"','"+outtime+"','"+manager+"','"+result+"','"+0+"','"+0+"')";
		return sql;
	}
	

}