ddelete.java

来自「利用Struts的MVC写的WEB开发程序」· Java 代码 · 共 54 行

/****************************
****************************/
package dlayer;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import bean.InfoBean;

public class DDelete extends DConnet{
	
	private Connection con ;
	
	private ResultSet rs;
	
	private Statement stmt;
	
	public void DDelete(){
		
	}
	
	
	public void deleteInfo(InfoBean infoBean) throws SQLException{
		
		con = super.Connect();
		
		stmt = con.createStatement();
		
		String userId = "";
		
		String dDate = "";
		
		userId = infoBean.getUserId();
		
		dDate = infoBean.getDateSh();
		
		StringBuffer sql = new StringBuffer();
		
		sql.append("delete from FOOD_TABLE where ")
		   .append("DDate = '")
		   .append(dDate)
		   .append("'")
		   .append("and USER_ID='")
		   .append(userId)
		   .append("'");
		
		int resultCount = this.update(sql.toString());
	
	}

}