usersdaoimpl.java

学习 java 做 的一些 小 试验。。。。。。。可以

package com.wczy.daoimpl;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import com.wczy.dao.UsersDao;
import com.wczy.common.db.DBConnect;
import com.wczy.pojo.Users;

public class UsersDaoImpl implements UsersDao {

	public boolean isSetted(Users users) {
		return (users.username != null && users.username.length() > 0)
				&& (users.password.length() > 0 && users.password != null);
	}

	public Users getUsername(String username) {
		ArrayList<Users> arr1 = new ArrayList<Users>();
		Connection con = DBConnect.getConnection();
		String sql="select * from users where username='"+username+"'";
		try {
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery(sql);
			Users users1 = new Users();
			while(rs.next()){
			users1.setId(rs.getInt(1));
			users1.setUsername(rs.getString(2));
			users1.setPassword(rs.getString(3));
			users1.setLogin(rs.getBoolean(4));
			arr1.add(users1);
			if(rs.getString(2).equals(username)){
				return users1;
				}
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} 
		return null;
	}
}