userdaoimpl.java

关于Ejb3的一个小的Demo

package com.bluedot.persist;

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

import javax.ejb.Stateless;

import com.bluedot.common.JdbcUtil;
import com.bluedot.domain.User;

@Stateless
public class UserDaoImpl implements UserDao{

	public void insert(User user) {
		Connection conn=null;
		conn=JdbcUtil.getConnection();
		String userName=user.getName();
		String birth=new SimpleDateFormat("yyyy-MM-dd").format(user.getBirth());
		try {
			PreparedStatement ps=conn.prepareStatement("insert into test.user(name,birth) values(?,to_date(?,'YYYY-MM-DD'))");
			ps.setString(1, userName);
			ps.setString(2, birth);
			ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
}