loginmanager.java

java编写小型超市管理系统+数据库.用于小型超市简单的货品进存销

package com.wish;
import java.sql.*;
//登陆时查询的类
public class loginmanager {
	public boolean login(String name,String pwd){
		boolean flag=false;
		Connection cn=ConnectionDB.getCon();
		Statement st=null;
		ResultSet rs=null;
	
		String sql="select * from adminlist where admin_name='"+name+"' and admin_pwd='"+pwd+"'";
		try {
			st=cn.createStatement();
			rs=st.executeQuery(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
				try {
					if(rs.next())
						flag=true;
					else
						flag=false;
				} catch (SQLException e) {
					e.printStackTrace();
				}

		ConnectionDB.close(rs);
		ConnectionDB.close(cn);
		ConnectionDB.close(st);
		return flag;
	}
}