dintputinfo.java

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

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

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

import bean.FoodTableBean;

public class DIntputInfo extends DConnet{
	

//	private Connection con = null;
////	private String str = "";
////	private int a = 0;
////	
//	private Statement stmt = null;
	
	public void DIntputInfo(){
		
	}

	public void inputInfo(FoodTableBean foodTablebean) throws SQLException{
		
		super.Connect();
		
		
		StringBuffer sql = new StringBuffer();
		
		sql = sql.append("insert ")
				.append(" into FOOD_TABLE(")
				.append("USER_ID,")
				.append("FOOD_ID,")
				.append("DNUMBER,")
				.append("DDATE)")
				.append("values(")
				.append("'"+foodTablebean.getUserId()+"',")
				.append("'"+foodTablebean.getFoodId()+"',")
				.append("'"+foodTablebean.getNumber()+"',")
				.append("'"+foodTablebean.getDate()+"')");
//		String sql1 = "insert into FOOD_TABLE(USER_ID,FOOD_ID,NUMBER,DATE)values(\"2\",\"2\",\"21\",\"20060923\")"	;	
//		String sql1 = "insert into FOOD_TABLE (USER_ID, FOOD_ID, DNUMBER, DDATE) values ('2','2','21','20060923')"	;
		int resultCount = this.update(sql.toString());
		System.out.println(resultCount);
	
	}
	
}