registerdao.java

模拟的土豆网视频网站

package cn.myvideosite.data.model.dao;

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


import cn.myvideosite.data.model.bean.Register;


public class RegisterDAO extends BaseDAO{

	/**
	    * 用户信息表的保存方法
	    * @param userinfo
	    * @return
	    */
    public static Register save(Register register){
 	  PreparedStatement pstmt=null;
 	  String sql="insert into register (username,password,password2,email,sex,birthday,location) values (?,?,?,?,?,?,?)";
 	  try {
			pstmt=connection.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS);
							
			pstmt.setString(1, register.getUsername());						
			pstmt.setString(2, register.getPassword());
			pstmt.setString(3, register.getPassword2());
			pstmt.setString(4, register.getEmail());			
			pstmt.setString(5, register.getSex());
			pstmt.setString(6, register.getBirthday());			
			pstmt.setString(7, register.getLocation());		
			//pstmt.executeUpdate();
			if(pstmt.executeUpdate()==1){
				ResultSet rs=pstmt.getGeneratedKeys();				
				if(rs!=null){
					rs.next();
					register.setID(rs.getInt(1));	
				}
			}
		} catch (SQLException e) {			
			e.printStackTrace();
		}finally{
			if(pstmt!=null){
				try {
					pstmt.close();
					pstmt=null;
				} catch (SQLException e) {
					
					e.printStackTrace();
				}
			
			}
		}   	    	  
		return register;    	   
    }
    public static Register findByUserName(String username){
 	   PreparedStatement pstmt=null;
 	   ResultSet rs=null;
 	   String sql="select * from register where username=?";
 	   Register register=null;
 	   try {
			pstmt=connection.prepareStatement(sql);
			pstmt.setString(1,username );
			rs=pstmt.executeQuery();
			if(rs.next()){
				register=new Register();
				
				register.setID(rs.getInt(1));
				register.setUsername(rs.getString(2));								
				register.setPassword(rs.getString(3));
				register.setPassword2(rs.getString(4));
				register.setEmail(rs.getString(5));			
				register.setSex(rs.getString(6));
				register.setBirthday(rs.getString(7));				
				register.setLocation(rs.getString(8));
							
			}			
		} catch (SQLException e) {			
			e.printStackTrace();
		}finally{
			try {
				if(rs!=null){
				rs.close();
				rs=null;
				}
				if(pstmt!=null){
				pstmt.close();
				pstmt=null;
				}
			} catch (SQLException e) {
				
				e.printStackTrace();
			}
		} 
		return register;	   
    }
}