admin_login_dao.java

这是一个Struts网上商城(图书)的管理系统源代码.

package com.bookshop.dao;
import java.util.*;
import java.sql.*;
import com.bookshop.db.*;
import com.bookshop.dao.*;
import com.bookshop.dto.*;
public class admin_login_dao {
	public boolean admin_login(String manager,String pwd){
		//管理员登陆
		Connection conn=DBConnection.getConnection();
		Statement st=null;
		ResultSet rs=null;
		String sql="";
		boolean flag=false;
		try{
			sql="select * from tb_manager where manager='"+manager+"' and pwd='"+pwd+"'";
			st=conn.createStatement();
			rs=st.executeQuery(sql);
			if(rs.next())
				flag=true;
			
		}catch(SQLException e){e.printStackTrace();return false;}
			
		finally{
			
			try{
				rs.close();
				st.close();
				conn.close();
			}catch(SQLException e){e.printStackTrace();}
			
		}
		return flag;
		
	}

}