sell.java

JSP酒店服务管理系统,用于中小型饭店的各种服务

package sell;

import java.sql.*;



public class sell
{
	String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=preconcert"; 
  	String user="sa"; 
  	String password="deardan";
	
	Connection conn =null; 
	Statement stmt =null;
	String sql =null;
	ResultSet rs =null;
	int n;
	
	private String dept = "";
	private int price =0;
	private String year ="";
	private String month = "";

	public void setdept(String d)
	{
		this.dept = d;
	}	
	public String getdept()
	{
		return this.dept;
	}
	
	public void setprice(int p)
	{
		this.price = p;
	}
	public int getprice()
	{
		return this.price;
	}

	public void setmonth(String m)
	{
		this.month = m;
	}
	public String getmonth()
	{
		return this.month;
	}

	public void setyear(String y)
	{
		this.year = y;
	}
	public String getyear()
	{
		return this.year;
	}

	public sell()
	{
		try{
		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
   		conn= DriverManager.getConnection(url,user,password);   
  		stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 
		}
		catch(Exception ex)
		{
			System.out.println(ex.getMessage());
		}
	}
	public boolean insert()
	{
		sql = "insert into sell (dept,price,year,month) values(?,?,?,?)";

		try{
		PreparedStatement ps = conn.prepareStatement(sql);
		ps.setString(1,this.dept);
		ps.setInt(2,this.price);
		ps.setString(3,this.year);
		ps.setString(4,this.month);
		
		
		n=ps.executeUpdate(); 
		if(n==1)
			return true;
		else
			return false;
		}
		catch(Exception e)
		{
			return false;
		}
		
	}
	public int selectprice()
	{
		sql = "select price from sell where dept=? and year=? and month=?";
		int p=-1;
		try{
			PreparedStatement ps = conn.prepareStatement(sql);
			ps.setString(1,this.dept);
			ps.setString(2,this.year);
			ps.setString(3,this.month);
			rs = ps.executeQuery();
			rs.next();
			p=rs.getInt(1);
			return p;
			
		}
		catch(Exception e)
		{
			return -1;
		}
	}
	public boolean updateprice()
	{
		sql ="update sell set price=? where dept=? and year=? and month=?";
		try{
			PreparedStatement ps = conn.prepareStatement(sql);
			ps.setInt(1,this.price);
			ps.setString(2,this.dept);
			ps.setString(3,this.year);
			ps.setString(4,this.month);
			n = ps.executeUpdate();
			if(n==1)
			{
				return true;
			}
			else
				return false;
		}
		catch(Exception e)
		{
			return false;
		}
	}
	public void close()
	{
		try{
 		stmt.close();   
		conn.close();
		}
		catch(Exception ex)
		{
			System.out.println(ex.getMessage());
		}
	}
}