admininfo.java

网上购物源代码

package com.chinaaccpDao;

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

import com.chinaaccpbean.AdminInfobeen;

import sun.awt.windows.WWindowPeer;

public class AdminInfo {
	public Statement getstmt() {
		Statement stmt = null;
		try {
			String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
			Class.forName(sDBDriver);
			String sConnStr = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=shopping";
			String name = "sa";
			Connection connshop = DriverManager.getConnection(sConnStr, name,"");
			stmt = connshop.createStatement();
			return stmt;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return stmt;
	}

	public boolean upadmin(int id, String Name, String password, String type) {
		try {
			Statement stmt = this.getstmt();

			String sql = "update AdminInfo set Name='"+Name+"',password='"+password+"',type='"+type+"' where ID='"+id+"'";
			int rs = stmt.executeUpdate(sql);
			if (rs == 1) {
				return true;
			} else {
				return false;
			}
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
	}

	public boolean addadmin(String name, String password, String type) {
		try {
			Statement stmt = this.getstmt();
			String sql = "insert into Admininfo(Name,password,type) values('"
					+ name + "','" + password + "','" + type + "')";
			int rs = stmt.executeUpdate(sql);
			if (rs == 1) {
				return true;
			} else {
				return false;
			}
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
	}

	public boolean select(String name)
	{
		boolean bool=true;
		try {
			Statement stmt = this.getstmt();
			String sql = "select name from AdminInfo where name='" + name + "'";
			ResultSet rs = stmt.executeQuery(sql);
				while (rs.next()) 
				{
					String names = rs.getString(1);
	
					if (name.equals(names))
						bool=false;
				}
			}
		catch (Exception e)
		{
			e.printStackTrace();
			return true;
		}
		return bool;

	}

	public boolean delete(int id) {
		try {
			Statement stmt = this.getstmt();
			String sql = "delete from AdminInfo where id='" + id + "'";
			int rs = stmt.executeUpdate(sql);
			if (rs == 1)
				return true;
			else
				return false;
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
	}

	public ArrayList<AdminInfobeen> getAllAdminInfo() {
		ArrayList<AdminInfobeen> list = new ArrayList<AdminInfobeen>();
		try {
			Statement stmt = this.getstmt();
			String sql = "select ID, Name,password,type from AdminInfo";
			ResultSet rs = stmt.executeQuery(sql);
			while (rs.next()) {
				AdminInfobeen ca = new AdminInfobeen();
				ca.setID(rs.getString(1));
				ca.setName(rs.getString(2));
				ca.setPassword(rs.getString(3));
				ca.setType(rs.getString(4));
				list.add(ca);
			}
			rs.close();
			stmt.close();

		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}

	public AdminInfobeen getAllAdmin(int id) {
		AdminInfobeen ca = new AdminInfobeen();
		try {
			Statement stmt = this.getstmt();
			String sql = "select ID, Name,password,type from AdminInfo where ID='"
					+ id + "'";
			ResultSet rs = stmt.executeQuery(sql);
			while (rs.next()) {
				ca.setID(rs.getString(1));
				ca.setName(rs.getString(2));
				ca.setPassword(rs.getString(3));
				ca.setType(rs.getString(4));
			}
			rs.close();
			stmt.close();

		} catch (Exception e) {
			e.printStackTrace();
		}
		return ca;
	}

	public int getadm(String username, String password) {
		try {
			String uname = username;
			String pw = password;
			Statement stmt = this.getstmt();
			String sql = "select type from AdminInfo where Name='" + uname
					+ "'and password='" + pw + "'";
			ResultSet rs = stmt.executeQuery(sql);
			if (rs.next()) {
				int type = rs.getInt(1);
				return type;

			} else {
				return 0;
			}

		} catch (Exception e) {
			e.printStackTrace();

		}
		return 0;

	}
}