package booksys;

import java.sql.*;

public class publishers{
	int publisherid;
	String publishernm;
	String address1;
	String address2;
	String country;
	String phone;
	boolean newpublisher;
	
	public publishers(){
		}
		
	public static int searchid(String publishernm) throws Exception{
			dbconn.conn();
			int result;
			String sql = "select publisherid from publishers where publishernm='"+publishernm+"'";
			ResultSet rs = dbconn.dbquery(sql);
			if(rs.next()){
				result=rs.getInt(1);
				}
			else{
				result=0;
				}
			dbconn.dbclose();
			return result;
		}
		
	public static String searchnm(int id) throws Exception{
		dbconn.conn();
		String s="";
		String sql = "select publishernm from publishers where publisherid="+id;
		ResultSet rs = dbconn.dbquery(sql);
		if(rs.next()){
			s = rs.getString(1).trim();
			}
		return s;
		}
	}