userdaoimpl.java

来自「是我自己在做java训练的时候做的一个小项目」· Java 代码 · 共 40 行

package com.magic.mobile.dao.impl;

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

import com.magic.mobile.dao.UserDAO;
import com.magic.mobile.util.DBUtil;
import com.magic.mobile.vo.User;

public class UserDAOImpl implements UserDAO {
	// 添加用户
	public boolean addUser(User user) {
		Connection conn = null;
		PreparedStatement pstmt = null;
		String sql = "insert into tuser values(user_sequence.nextval,?,?,?,?,?)";
		try {
			conn = DBUtil.getConn();
			pstmt = DBUtil.getpStmt(conn, sql);
			pstmt.setString(1, user.getTmobile().getMobile_Number());
			System.out.println(user.getTmobile().getMobile_Number());
			pstmt.setString(2, user.getRoamingStatus());
			System.out.println(user.getRoamingStatus());
			pstmt.setString(3, user.getComLevel());
			System.out.println(user.getComLevel());
			pstmt.setLong(4, user.getTcustomer().getCustomerId());
			System.out.println(user.getTcustomer().getCustomerId());
			pstmt.setLong(5, user.getTaccount().getAccountId());
			System.out.println(user.getTaccount().getAccountId());
			pstmt.executeUpdate();
			return true;
		} catch (SQLException e) {
			return false;
		} finally {
			DBUtil.closeStmt(pstmt);
			DBUtil.closeConn(conn);
		}
	}
}