userinfoimple.java

网上书店jsp开发 购物车 收藏 使用servlet 是小型项目 仅供参考

package service;

import java.sql.SQLException;
import java.sql.Statement;

import conn.JdbcTool;
import javabean.UserInfo;

public class UserInfoImple implements IUserInfo{

	private JdbcTool tool;
	private Statement stm;
	private String sql;
	
	public UserInfoImple() {
		tool = new JdbcTool();
		stm = tool.getStatement();
	}

	public void add(UserInfo user) {
		sql = "insert into userinfo(name,password,email,number,adress) values('"+user.getName()+"','"+user.getPassword()+"','"+user.getEmail()+"','"+user.getNumber()+"','"+user.getAdress()+"')";
		try {
			stm.execute(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}