package?dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.Statement;

import?vo.Books;

public?class?AddbookDao?{
	private?Connection?conn?=?null;
	public?int?addbook（Books?book）?throws?Exception{
	??????int?i;i=0;
	??????this.initConnection（）;
	??????Statement?stat?=?conn.createStatement（）;
			String?sql?=
					“INSERT?INTO??T_BOOK（BOOKNOBOOKNAMEBOOKPRICE）?VALUES（???）“;
			PreparedStatement?ps?=?conn.prepareStatement（sql）;
			ps.setString（1book.getBookno（））;
			ps.setString（2?book.getBookname（））;
			ps.setFloat（3?book.getBookprice（））;
			i?=?ps.executeUpdate（）;
		this.closeConnection（）;
		return?i;
		
	}
	public?void?initConnection（）throws?Exception{
		Class.forName（“com.mysql.jdbc.Driver“）;
		conn?=?DriverManager.getConnection（“jdbc:mysql://localhost:3306/SHOP““root““root“）;
		
		
	}
	public?void?closeConnection（）?throws?Exception{
		conn.close（）;
		
	}
}