authors.java

图书馆管理系统,从我们导师的实验室(国家重点实验室)带出来的,不过是我们自己开发的,已经提交,没有问题!站长采纳,可别说是偶传的噢!

package booksys;

import java.sql.*;

/**作者类*/
public class authors{
	int authorid;
	String authornm;
	String authorintroduce;
	String country;
	boolean newauthor;
	
	public authors(){
		}
		
	public static int searchid(String authornm) throws Exception{
			dbconn.conn();
			int result;
			String sql = "select authorid from authors where authornm='"+authornm+"'";
			ResultSet rs = dbconn.dbquery(sql);
			if(rs.next()){
				result=rs.getInt(1);
				}
			else{
				result=0;
				}
			dbconn.dbclose();
			return result;
		}
	}