ordersdao.java

来自「一个java项目」· Java 代码 · 共 37 行

package com.xfaccp.htapp.dao;

import java.util.SortedMap;

import javax.servlet.jsp.jstl.sql.Result;

import com.xfaccp.htapp.hbm.DbManage;
import com.xfaccp.htapp.pojo.Orders;

public class OrdersDAO 
{
	
	
	public static boolean inser(Orders orders)
	{
		String sql=String.format("insert into orders values('%s','%s',%d,'%s')",orders.getProdName(),orders.getCusName(),orders.getAmount(),orders.getBuyDate());
		return DbManage.runnoneResultSet(sql);
	}
	public static Orders get(String cusname)
	{
		String sql ="select * from orders where id=(select max(id) from orders)";
		Result result = DbManage.runHasResultSet(sql);
		SortedMap[] rows = result.getRows(); 
		if(result.getRowCount()==1)
		{
			int ID =Integer.parseInt(rows[0].get("id").toString());
			String ProdName = rows[0].get("prodName").toString();
			String CusName=rows[0].get("cusName").toString();
			int Amount =Integer.parseInt(rows[0].get("amount").toString());
			String BuyDate =rows[0].get("buyDate").toString();
			return new Orders(ID,ProdName,CusName,Amount,BuyDate);
		}
		return null;
	}

}