insertuser.java

网上购物源代码

/**
 * 
 */
package com.chinaaccpDao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import com.chinaaccpbean.LoginUserBean;
/**
 * @author liu
 *
 */
public class InsertUser {
	
	public String GetInsertInfo(LoginUserBean user)
	{
		Connection con = null;
		try {
			con = ConnectionLee.GetCon();
			String sql = "Insert into UserInfo(logname,password,name,idnum,postcode,address,email,tel) values(?,?,?,?,?,?,?,?)";
			PreparedStatement ps = con.prepareStatement(sql);
			ps.setString(1, user.getLogname());
			ps.setString(2, user.getPassword());
			ps.setString(3, user.getName());
			ps.setString(4, user.getIdnum());
			ps.setString(5, user.getPostcode());
			ps.setString(6, user.getAddress());
			ps.setString(7, user.getEmail());
			ps.setString(8, user.getTel());
			int row = ps.executeUpdate();
			if(row>0)
			{
				String success = "注册成功";
				return success;
			}
			else
			{
				String failure = "注册失败";
				return failure;
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		String DBError = "注册失败";
		return DBError;
	}

}