managerdao.java

程序为银行管理系统,分为四个子模块,分别为人事管理系统,计算机管理系统,机构管理系统和bbs论坛

package org.xjtu.BankManager.zdao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.xjtu.BankManager.zdb.BankMessage;
import org.xjtu.BankManager.zvo.EmployeeVO;
import org.xjtu.BankManager.zvo.MessagerVO;


public class ManagerDAO {
	private BankMessage dbacess;
	   private Connection con;
	   private PreparedStatement stmt;
//	   String strlogin="select * from article where sname=? and password=?";
	   String stradd="insert into article values (?,?,?,?,?,?,?)";
	   String strselectall="select * from article";
	   String strdelete="delete from article where art_id=?";
	   String strdetail="select * from article where art_id=?";
	   String strupdate="update article set art_title=?,art_title2=?,art_abstract=?,art_content=? where art_id=?";
	   String strauname="select * from emp where ID=?";	   
	   private ResultSet sr;
//	   public MessagerVO login(MessagerVO vo)
//	   {
//		   dbacess=new BankMessage();
//		   dbacess.getCnn();
//		   con=dbacess.cnnDB();
//		   try {
//			stmt=con.prepareStatement(strlogin);
//			stmt.setString(1,vo.getSname());
//			stmt.setString(2,vo.getPassword());
//			sr=stmt.executeQuery();
//			while(sr.next())
//			{
//				studentvo svo=new studentvo();
//				svo.setSname(sr.getString("sname"));
//				svo.setPassword(sr.getString("password"));
//				return svo;
//			}
//		} catch (SQLException e) {
//			e.printStackTrace();
//		}
//		return null;
//	   }
	   
	   
//	   public void deleteMessager(MessagerVO vo)
//	   {
//		   dbacess=new BankMessage();
//		   dbacess.getCnn();
//		   con=dbacess.cnnDB();
//		   try {
//			stmt=con.prepareStatement(strdelete);
//			stmt.setLong(1,vo.getArt_id());
//			stmt.executeUpdate();
//		} catch (SQLException e) {
//			e.printStackTrace();
//		}
//	   }
	   
	   public MessagerVO findMess(int i)
	   {
		   MessagerVO vo = null;
		   dbacess=new BankMessage();
		   dbacess.getCnn();
		   con=dbacess.cnnDB();		   
		   try {
				stmt=con.prepareStatement(strdetail);
				stmt.setInt(1, i);				
				sr=stmt.executeQuery();
				while(sr.next())
				{
					if(sr.getInt("art_id")==i)
					{
						vo = new MessagerVO();
						vo.setArt_id(sr.getInt("art_id"));
						vo.setArt_title(sr.getString("art_title"));
						vo.setArt_title2(sr.getString("art_title2"));
						vo.setArt_abstract(sr.getString("art_abstract"));
						vo.setAuthor_id(sr.getInt("author_id"));
						vo.setAuthor_name(sr.getString("author_name"));
						vo.setDeliver_time(sr.getDate("deliver_time"));
						vo.setArt_content(sr.getString("art_content"));
						break;
					}
				}
				
		   }catch (SQLException e) {
				e.printStackTrace();
			}
		   return vo;		   
	   }
	   
	   public String Srch_authname(int unum)
	   {
		   EmployeeVO evo=new EmployeeVO();
		   dbacess=new BankMessage();
		   dbacess.getCnn();
		   con=dbacess.cnnDB();
		   try {
			stmt=con.prepareStatement(strauname);
			stmt.setInt(1,unum);
//			stmt.executeUpdate();
			sr=stmt.executeQuery();
			while(sr.next())
			{				
				evo.setName(sr.getString("Name"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		String auname = "";
		auname=auname+evo.getName();
		return auname;
	   }
	   
	   public void deleteMessager(int i)
	   {
		   dbacess=new BankMessage();
		   dbacess.getCnn();
		   con=dbacess.cnnDB();
		   try {
			stmt=con.prepareStatement(strdelete);
			stmt.setInt(1,i);
			stmt.executeUpdate();
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
	   }
	   
	   public List selectall()
	   {
		   dbacess = new BankMessage();
		   dbacess.getCnn();
		   con=dbacess.cnnDB();
		   List list = new ArrayList();
		   try {
			stmt=con.prepareStatement(strselectall);
			sr=stmt.executeQuery();
			while(sr.next())
			{
				MessagerVO tvo=new MessagerVO();
				tvo.setArt_id(sr.getInt("art_id"));
				tvo.setArt_title(sr.getString("art_title"));
				tvo.setArt_title2(sr.getString("art_title2"));
				tvo.setArt_abstract(sr.getString("art_abstract"));
				tvo.setAuthor_id(sr.getInt("author_id"));
				tvo.setAuthor_name(sr.getString("author_name"));
				tvo.setDeliver_time(sr.getDate("deliver_time"));
				tvo.setArt_content(sr.getString("art_content"));
				list.add(tvo);
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	   }
	   
	   public List selectal(int k)
	   {
		   dbacess = new BankMessage();
		   dbacess.getCnn();
		   con=dbacess.cnnDB();
		   List list = new ArrayList();
		   try {
			stmt=con.prepareStatement(strselectall);
			sr=stmt.executeQuery();
			while(sr.next())
			{
				if(k==sr.getInt("author_id"))
				{
					MessagerVO tvo=new MessagerVO();
					tvo.setArt_id(sr.getInt("art_id"));
					tvo.setArt_title(sr.getString("art_title"));
					tvo.setArt_title2(sr.getString("art_title2"));
					tvo.setArt_abstract(sr.getString("art_abstract"));
					tvo.setAuthor_id(sr.getInt("author_id"));
					tvo.setAuthor_name(sr.getString("author_name"));
					tvo.setArt_content(sr.getString("art_content"));
					tvo.setDeliver_time(sr.getDate("deliver_time"));
					list.add(tvo);
				}
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	   }
	   
	   
	   public void addMessage(MessagerVO vo)
	   {
		   dbacess = new BankMessage();
		   dbacess.getCnn();
		   con=dbacess.cnnDB();
		   try {
			stmt=con.prepareStatement(stradd);
			stmt.setString(1, vo.getArt_title());
			stmt.setString(2, vo.getArt_title2());
			stmt.setString(3, vo.getArt_abstract());
			stmt.setInt(4,vo.getAuthor_id());
			stmt.setString(5, vo.getAuthor_name());
			stmt.setDate(6,new java.sql.Date(vo.getDeliver_time().getTime()));
			stmt.setString(7,vo.getArt_content());
//			stmt.setString(1,vo.getSname());
//			stmt.setString(2, vo.getPassword());
			stmt.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	   }
	   
	   public void updateMessage(MessagerVO zvo)
	   {
		   dbacess=new BankMessage();
		   dbacess.getCnn();
		   con=dbacess.cnnDB();
		   try {
			stmt=con.prepareStatement(strupdate);
			stmt.setString(1, zvo.getArt_title());
			stmt.setString(2, zvo.getArt_title2());
			stmt.setString(3, zvo.getArt_abstract());
			stmt.setString(4, zvo.getArt_content());
			stmt.setInt(5,zvo.getArt_id());
			stmt.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	   }
	   
	   
	
	   public static void main(String args[])
	   {
		   ManagerDAO dao=new ManagerDAO();
		   MessagerVO svo=null;
		   svo = dao.findMess(1);
		   System.out.println(svo.getArt_title());
		   svo = new MessagerVO();
		  //更新
//		   svo.setArt_title("aupdatea");
//		   svo.setArt_title2("update");
//		   svo.setArt_abstract("updateaa");
//		   svo.setArt_content("aaupdatea");
//		   svo.setArt_id(12);
//		   
//		   dao.updateMessage(svo);
		  //登陆
//		   svo.setSname("xjtu");
//		   svo.setPassword("198701");
//		   if(dao.login(svo)!=null)
//		   {
//			   System.out.println("登陆成功");
//		   }
//		   else
//		   {
//			   System.out.println("登陆失败");
//		   }
		   //注册
//		   svo.setSname("jin");
//		   svo.setPassword("198701");
//		   dao.zhuce(svo);
		   //查找所有
//		   svo.setArt_title("aaaaaa");
//		   svo.setArt_title2("aaaaa");
//		   svo.setArt_abstract("aaaaa");
//		   svo.setAuthor_id(7);
//		   svo.setAuthor_name("aaaa");
//		   svo.setDeliver_time("2008-7-22");
//		   svo.setArt_content("aaaaaaaaaaaa");
//		   dao.addMessage(svo);
//		   
//		   dao.deleteMessager(2);
//		   System.out.println("1234567890");
//		   System.out.println(dao.Srch_authname(8));
		  List list=dao.selectall();
//		  System.out.println("ffffffffffff");
		  for(int i=0;i<list.size();i++)
		  {
			  System.out.println("ffffffffffff");
			  svo=(MessagerVO)list.get(i);
			  System.out.println(svo.getArt_title());
		  }
	   }
}