librarybooks.java

来自「java实现的小型购物平台,虽然简单」· Java 代码 · 共 70 行

package  LL;

import java.sql.*;

/**
 * @author hefei
 *
 */
public class LibraryBooks {
	private String bookIsbn[]=new String[100];
	private String bookTitle[]=new String[100];
	private int quantity = 0;

	public LibraryBooks() {
		try {
			String userId = "root";
			String password = "6228456";
			String url = "jdbc:mysql://localhost/lib";
			Class.forName("com.mysql.jdbc.Driver");
			Connection dbcon = DriverManager.getConnection(url, userId,
					password);
			Statement st = dbcon.createStatement();
			ResultSet res = st.executeQuery("Select name,isbn from title5");
				while (res.next()) {
				bookTitle[quantity] = res.getString("name");
			    System.out.println(res.getString("name"));//*******
				bookIsbn[quantity] = res.getString("isbn");
				//System.out.println("!!!!!!!!!");//@@@@@@@@@@@@
				quantity++;
				//System.out.println(quantity);//&&&&&
			}
		} catch(SQLException e){
			System.out.println(e.toString());
			
		}catch (Exception e) {
			System.out.println(e.toString());
		}

	}

	public int getQuantity() {
		return quantity;
	}

	public void setQuantity(int quantity) {
		this.quantity = quantity;
	}

	public String[] getBookIsbn() {
		return bookIsbn;
	}

	public String[] getBookTitle() {
		return bookTitle;
	}

	public void setBookIsbn(String[] bookIsbn) {
		this.bookIsbn = bookIsbn;
	}

	public void setBookTitle(String[] bookTitle) {
		this.bookTitle = bookTitle;
	}
	public static void main(String[] args){
		LibraryBooks l = new LibraryBooks();
   
		System.out.println(l.getBookTitle()[0]);
	}
}