3012107ef1cc001d15c68b756a903e4c

用struts框架做的jsp通讯录

package com.csthit.phonebook.dao;

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

import com.csthit.phonebook.Bean.User;
import com.csthit.phonebook.db.ConnClass;

public class UserDAO {
	private static ConnClass cc= ConnClass.getInstance(); 
	private static Connection conn =cc.getConn(); //获取单例中的Conncetion
	private static PreparedStatement pstmt = null;
	private static ResultSet rs = null;
	
	//验证登陆
	public static User isLogin(String username, String password) {	
	        User user = null;
		try {
			
			String sql = "select * from usertab where username=? and password=?";
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, username);
			pstmt.setString(2, password);
			rs = pstmt.executeQuery();
			if (rs.next()) {
				 user = new User();
				user.setUid(rs.getInt(1));
				user.setUserName(rs.getString(2));
				user.setPassword(rs.getString(3));
				user.setName(rs.getString(4));
				
			} 
		} catch (SQLException e) {
			e.printStackTrace();
			
		} catch (Exception e) {
			e.printStackTrace();
		} finally {

			try {
				
				
				pstmt.close();
				
			} catch (Exception e) {
				e.printStackTrace();
			}

		}
		return user;
	}

	public static int register(User user) {
		
		int i=0;
		String sql = "insert into users values(?,?,?)";
		try {
			
			pstmt = conn.prepareStatement(sql);
			
			pstmt.setString(1, user.getName());
			pstmt.setString(2, user.getUserName());
			pstmt.setString(3,user.getPassword());
			i=pstmt.executeUpdate();
		} catch (SQLException e) {			
			e.printStackTrace();
			return 0;
		} catch (Exception e) {
			e.printStackTrace();
			return 0;
		}
		return i;

	}
}