booksave.java

手工完成

package Bean;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class BookSave {
	public void save(String strusername,String strbookID)
	{
		String username = strusername;
		String bookID = strbookID;
		
		Connection conn = null;
		conn = new DBConn().getConn();
		
		String sql = null;
		sql = "INSERT INTO savebook (username,bookID) VALUES (?,?)";
			
			try {
				PreparedStatement ps=conn.prepareStatement(sql);
				
				ps.setString(1, username);
				ps.setString(2, bookID);
				
				ps.executeUpdate();//
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
			System.out.println("数据成功插入到数据库中！");
	}
}