usersqlserverdaoimpl.java

来自「StrustStart框架的一个小小的应用 为了更方便程序员开发」· Java 代码 · 共 36 行

package com.ebuji.strustStrat.user.dao.impl;

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

import com.ebuji.strustStrat.user.dao.IUserDao;
import com.ebuji.struts.form.LoginForm;
import com.ebuji.util.DBConnection;
import com.sun.corba.se.impl.javax.rmi.CORBA.Util;

public class UserSqlserverDaoImpl implements IUserDao {

	public boolean verify(LoginForm form) {
		boolean flg=false;
		Connection conn=null;
		PreparedStatement pstmt=null;
		ResultSet rs=null;
		try {
			conn=DBConnection.getConnection();
			pstmt=conn.prepareStatement("select 1 from USERS where userName=? and password=?");
			pstmt.setString(1, form.getUserName());
			pstmt.setString(2, form.getPassword());
			
			rs=pstmt.executeQuery();
			flg=rs.next();			
			
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			DBConnection.close(rs, pstmt, conn);
		}
		return flg;
	}
}