orderserver.java

来自「基于MVC架构实现的购物车功能」· Java 代码 · 共 35 行

package com.lyh.dao;
import com.lyh.common.*;
import com.lyh.entity.*;
import java.sql.*;

public class OrderServer {
	public static void foodOrder(foodOrderInfo foodOrder)
	{
		Connection conn=DBConnection.getConnection();
		PreparedStatement pStatement;
		ResultSet rs;
		try
		{
    	String SqlStr="insert into foodOrderInfo(customerName,address,zipCode,telephone,movephone,notice,totalPrice) " +
		"values(?,?,?,?,?,?,?)";
		pStatement=conn.prepareStatement(SqlStr);
		pStatement.setString(1,foodOrder.getCustomerName());
		pStatement.setString(2,foodOrder.getAddress());
		pStatement.setString(3,foodOrder.getZipCode());
		pStatement.setString(4,foodOrder.getTelephone());
		pStatement.setString(5,foodOrder.getMovePhone());
		pStatement.setString(6,foodOrder.getNotice());
		pStatement.setDouble(7,foodOrder.getTotalPrice());
		
		pStatement.executeUpdate();
		}catch(SQLException ex)
		{
			System.out.println(ex.getMessage());
		}
		
	
	}

}