adminmanager.java

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

package com.wish;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

public class AdminManager {

	@SuppressWarnings("unchecked")
	public Vector getAdmin()
	{
		Vector v =new Vector();
		Connection cn=ConnectionDB.getCon();
		Statement st=null;
		ResultSet rs=null;
		
		try {
			String sql="select * from adminlist";
			st=cn.createStatement();
			rs=st.executeQuery(sql);
			while(rs.next())
			{	Admin admin=new Admin();
				String admin_id=rs.getString("admin_id");
				String admin_name=rs.getString("admin_name");
				String admin_pwd=rs.getString("admin_pwd");
				
				admin.setAdmin_id(admin_id);
				admin.setAdmin_name(admin_name);
				admin.setAdmin_pwd(admin_pwd);
				
				v.add(admin);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
			ConnectionDB.close(rs);
			ConnectionDB.close(st);
			ConnectionDB.close(cn);
		return v;
	}
	
//	删除方法
	public boolean delAdmin(String admin_id)
	   {
		   boolean flag = false;
		   Connection cn = ConnectionDB.getCon();
		   String delSql = "delete from adminlist where admin_id= ?";
		   try {
			PreparedStatement ps = cn.prepareStatement(delSql);
			ps.setString(1,admin_id);
			int n=ps.executeUpdate();
			if(n>0)flag = true;
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return flag;
	   }
	//插入方法
	public boolean addAdmin(String[]data)
	   {
		   boolean flag = false;
		   Connection cn = ConnectionDB.getCon();
		   String addSql = "insert into adminlist values(?,?,?)";
		   try {
			PreparedStatement ps = cn.prepareStatement(addSql);
			for(int i=1;i<=3;i++)
			ps.setString(i,data[i-1]);
			int n=ps.executeUpdate();
			if(n>0)flag = true;
		} catch (SQLException e) {
			e.printStackTrace();
		}
		   return flag;
	   }
	   //更新方法
	   public void updateAdmin(Admin admin)
	   {
		   Connection con = ConnectionDB.getCon();
		   String updSql = "update adminlist set admin_name=?,admin_pwd=? where admin_id=?";
		   try {
			PreparedStatement ps = con.prepareStatement(updSql);
			ps.setString(1,admin.getAdmin_name());
			ps.setString(2,admin.getAdmin_pwd());
			ps.setString(3,admin.getAdmin_id());
			ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	   }
}