userdao.java

一个视频网站的源码

package com.puckasoft.video312.dao;

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

import com.puckasoft.video312.po.User;

public class UserDao {
	
	public static void insert(User user){
		Connection conn  = DBConn.getConnection();
		String sql = "insert into user (uname,pwd,gender,email,ip) values (?,?,?,?,?)";
		PreparedStatement ps = null;
		try {
			ps = conn.prepareStatement(sql);
			ps.setString(1, user.getUname());
			ps.setString(2, user.getPwd());
			ps.setInt(3, user.getGender());
			ps.setString(4, user.getEmail());
			ps.setString(5, user.getIp());
			ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			DBConn.close(ps, conn);
		}
	}
	
	public static int isOnly(String uname){
		Connection conn  = DBConn.getConnection();
		String sql = "select count(*) from user where uname=?";
		PreparedStatement ps = null;
		ResultSet rs = null;
		int countUser = 0;
		try {
			ps = conn.prepareStatement(sql);
			ps.setString(1, uname);
			rs = ps.executeQuery();
			while(rs.next()){
				countUser=rs.getInt(1);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			DBConn.close(ps, conn);
		}
		
		return countUser;
	}
	
	public static User login(String uname,String pwd){
		Connection conn  = DBConn.getConnection();
		String sql = "select id,uname,pwd,gender,email from user where uname=? and pwd=?";
		PreparedStatement ps = null;
		ResultSet rs = null;
		User user = null;
		try {
			ps = conn.prepareStatement(sql);
			ps.setString(1, uname);
			ps.setString(2, pwd);
			rs = ps.executeQuery();
			while(rs.next()){
				user = new User(rs.getString("uname"),rs.getString("pwd"),rs.getInt("gender"),rs.getString("email"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			DBConn.close(ps, conn);
		}
		
		return user;
	}
	
	
	
	public static void main(String[] args) {
//		User user = new User("a","123",1,"[e-mail]","192.168.1.100");
//		UserDao.insert(user);
		User user = login("a","123");
		System.out.println(user.getEmail());
	}

}