existbuy.java

教材订购系统

package program;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class ExistBuy {
	
	public ExistBuy()
	{
		
	}
	public String YOrN(String bno,String bcount) throws ClassNotFoundException, SQLException 
	{
		String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
		String connectionStr="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ=D:/Java_Work/BookManager/program/db/bookmanage.mdb";
		Connection con = null;
		Statement stmt = null;
		ResultSet rs = null;
		
		Class.forName(DBDriver);	 //加载驱动器
		con=DriverManager.getConnection(connectionStr,"",""); //连接数据库
		stmt=con.createStatement();   //创建Statement对象
		rs=stmt.executeQuery("Select * From 书_inf Where 书号='"+bno+"'");  //查询 书_inf
		
		if(rs.next())
		{
			return "Y";
		}
		else
		{
			return "N";
		}
	}
}