savebookbuy.java

手工完成

package Bean;

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

public class SaveBookBuy {

	Connection conn = null;
	public void buy()
	{
		conn = new DBConn().getConn();
		String sql = null;
		sql = "INSERT INTO users (userName, password,gender,email,telphone,money,usertype) VALUES (?,?,?,?,?,?,?)";
		
		try {
			PreparedStatement ps=conn.prepareStatement(sql);
			
//			ps.setString(1, user.getUsername());
//			ps.setString(2, user.getPassword());
//			ps.setString(3, user.getGender());
//			ps.setString(4, user.getEmail());
//			ps.setString(5, user.getTelphone());
//			ps.setDouble(6, user.getMoney());	
//			ps.setString(7, user.getUsertype());
			
			ps.executeUpdate();//
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	//	System.out.println("数据成功插入到数据库中！");finally
			{
			
				
			}			
	}
}