bookdb.java

这是个简单的在线书店购书系统

package mypack;
import java.sql.*;
import java.util.*;
import java.lang.*;

public class BookDB {
	 
  String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
  String user="sa";
  String pwd="sa";
  String url="jdbc:microsoft:sqlserver://127.0.0.1;databaseName=lm";
  private Connection con;
private Connection getCon() {
	try{
		 Class.forName(driver);
		 Connection con=DriverManager.getConnection(url, user, pwd);
 		return con;
	}catch(Exception e){
		e.printStackTrace();
	}
	return null;
}
  

//获取一本图书信息
//参数：图书编号；返回类型：userbean对象
//获取一本图书信息
//参数：图书编号；返回类型：bookbean对象
public BookBean getBook(String  id ){
	try{
		String sql="select * from books where bookid="+id;
		Connection con=getCon();
		Statement stm=con.createStatement();
		BookBean book=null;
		ResultSet rs=stm.executeQuery(sql);
		
		while(rs.next()){
			int bookid=rs.getInt(1);
			String bookname=rs.getString(2);
			String pub=rs.getString(3);
			String author=rs.getString(4);
			String picurl=rs.getString(5);
			float price=rs.getFloat(6);
			String intro=rs.getString(7);
			String sortname=rs.getString(8);
			book=new BookBean(bookid,bookname,pub,author,picurl,price,intro,sortname);
			}
		rs.close();
		stm.close();
		con.close();
		return book;
	
	}catch(Exception e){
		e.printStackTrace();
	}
	return null;
}
//获取所有的图书信息
//参数：无；返回类型：vector
public Vector getBooks(){
		try{
			String sql="select * from books";
			Connection con=getCon();
			Statement stm=con.createStatement();
			ResultSet rs=stm.executeQuery(sql);
			Vector v=new Vector();
			
			while(rs.next()){
				int bookid=rs.getInt(1);
				String bookname=rs.getString(2);
				String pub=rs.getString(3);
				String author=rs.getString(4);
				String picurl=rs.getString(5);
				float price=rs.getFloat(6);
				String intro=rs.getString(7);
				String sortname=rs.getString(8);
				BookBean book=new BookBean(bookid,bookname,pub,author,picurl,price,intro,sortname);
				v.add(book);
			}
			return v;
		}catch(Exception e){
			e.printStackTrace();
		}
	return null;
}
//添加一本书
//参数：一本图书信息bookbean对象；返回类型boolean，代表是否添加成功
public boolean addBook(BookBean book){
	try{
		
		   Connection con=getCon();
		   String sql="insert books Values(?,?,?,?,?,?,?,?)";//变量
		   PreparedStatement pstm=con.prepareStatement(sql);//传参
		   pstm.setInt(1,book.getBookid());//通过book对象给id　赋值
		   pstm.setString(2,book.getBookname());
		   pstm.setString(3,book.getPub());
		   pstm.setString(4,book.getAuthor());
		   pstm.setString(5,book.getPicurl());
		   pstm.setFloat(6,book.getPrice());
		   pstm.setString(7,book.getIntro());
		   pstm.setString(8,book.getSortname());
		  int flg= pstm.executeUpdate();
		pstm.close();
		con.close();
		if(flg!=0){return true;}
	}catch(Exception e){
			e.printStackTrace();
		}
	return false;
}
public boolean delBook(int id){
	try{
		String sql="delete from books where bookid="+id;
		Connection con=getCon();
		Statement stm=con.createStatement();
		
		int flg=stm.executeUpdate(sql);
	if(flg!=0){return true;}
	
}catch(Exception e){
	e.printStackTrace();
}
return false;
}
public ResultSet allbook(){
	try{
		String sql="select * from books ";
		Connection con=getCon();
		Statement stm=con.createStatement();
		
		ResultSet rs=stm.executeQuery(sql);
		
		
		
		return rs;
	}catch(Exception e){
			e.printStackTrace();
	}
		return null;
 }
}