publisherdao.java

主要是用net开发的 用mvc模式 有酒店管理

package com.apache.dao;

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

import com.apache.pojo.Publisher;

public class PublisherDao {
	Connection conn=null;
	PreparedStatement pstmt=null;
	ResultSet rs=null;
	//按编号查询
  public Publisher getPublisherById(int id)
  {
	  Publisher p=null;
	  conn=ConnectionManager.getConnction();
	  try {
		pstmt=conn.prepareStatement("select * from publishers where publisherID=?");
		pstmt.setInt(1, id);
		rs=pstmt.executeQuery();
		while(rs.next())
		{
			p=new Publisher();
			p.setPublisherid(rs.getInt("publisherID"));
			p.setPublisherName(rs.getString("publisherName"));
					
		}
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}finally
	{
		ConnectionManager.closeResultSet(rs);
		ConnectionManager.closeStatement(pstmt);
		ConnectionManager.closeConnection(conn);
	}
	  return p;
  }
}