datemanger.java

个人办公平台,用JAVA开发的TOMCAT的服务器

package conn.skyhawk.control_2;

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

import conn.skyhawk.vo.Card;

public class DateManger {
	private ResultSet rs=null;
	private Statement sta=null;
	private Connection conn=null;
	
	
public ArrayList getView(String b,String a){
		ArrayList list=new ArrayList();
		Card card=new Card(); 		
		DateBase cn=new DateBase();
		System.out.println(a);
		
	String t = "select o_card.* ,o_cardkind.* from o_card,o_cardkind where o_card.empid='"+a+"'and o_card.name='"+b+"' and o_cardkind.empid=O_card.empid and o_cardkind.cardkindid=o_card.cardkindid"; 
		rs=cn.getSet(t);
						
			try {
			while(rs.next()){				
					System.out.println(rs.getString("name"));
					System.out.println(rs.getInt("cardkindid"));
					System.out.println(rs.getInt("empid"));
					System.out.println(rs.getString("position"));
					System.out.println("0"+rs.getLong("officephone"));
					System.out.println(rs.getLong("perphone"));
					System.out.println(rs.getInt("fix"));
					System.out.println(rs.getString("mailbox"));
					card.setName(rs.getString("name"));
					card.setCardkindid(rs.getString("cardkindid"));
					card.setEmpid(rs.getInt("empid"));
					card.setOfficephone(rs.getLong("officePhone")); 
				card.setCompany(rs.getString("company"));
				System.out.println(rs.getString("company"));
					card.setPosition(rs.getString("position"));
					card.setPerphone(rs.getLong("perphone"));
					card.setFix(rs.getInt("fix"));
				 	card.setSex(rs.getInt("sex"));
				    System.out.println(card.getSex()+"1111111111");
					card.setDepartment(rs.getString("department"));
					card.setMailbox(rs.getString("mailbox"));
					card.setKindname(rs.getString("kindname"));
					System.out.println(rs.getString("kindname"));
					list.add(card);
				}
			} catch (SQLException e) {
	
				e.printStackTrace();
			}finally{
				DateBase.CloseObject(rs,sta,conn);
			}
			return list;
		}
	public ArrayList getView1(String b){
			ArrayList list=new ArrayList();
			Card card=new Card(); 		
			DateBase cn=new DateBase();
			
		
		String t = "select o_card.* ,o_cardkind.* from o_card,o_cardkind where  o_card.name='"+b+"'and o_cardkind.sharer='1'and o_cardkind.empid=o_card.empid and o_cardkind.cardkindid=o_card.cardkindid"; 
			rs=cn.getSet(t);
						
				try {
				while(rs.next()){				
						System.out.println(rs.getString("name"));
						System.out.println(rs.getInt("cardkindid"));
						System.out.println(rs.getInt("empid"));
						System.out.println(rs.getString("position"));
						System.out.println("0"+rs.getLong("officephone"));
						System.out.println(rs.getLong("perphone"));
						System.out.println(rs.getInt("fix"));
						System.out.println(rs.getString("mailbox"));
						card.setName(rs.getString("name"));
						card.setCardkindid(rs.getString("cardkindid"));
						card.setEmpid(rs.getInt("empid"));
						card.setOfficephone(rs.getLong("officePhone")); 
					card.setCompany(rs.getString("company"));
					System.out.println(rs.getString("company"));
						card.setPosition(rs.getString("position"));
						card.setPerphone(rs.getLong("perphone"));
						card.setFix(rs.getInt("fix"));
						card.setSex(rs.getInt("SEX"));	    
						card.setDepartment(rs.getString("department"));
						card.setMailbox(rs.getString("mailbox"));
						card.setKindname(rs.getString("kindname"));
						System.out.println(rs.getString("kindname"));
					   
						list.add(card);
					}
				} catch (SQLException e) {
	
					e.printStackTrace();
				}finally{
					DateBase.CloseObject(rs,sta,conn);
				}
				return list;
			}

		public void addCard(){
			DateBase d=new DateBase();
			
			String t="insert into O_PERSONALCARD(name,cardkindid,empid,position,officephone,perphone,fix,mailbox)values('雯雯','2','2','百领','123','123','2','[e-mail]')";
			d.setInsert(t);
			
		}
	
		
		public void deletCard(){
			DateBase d=new DateBase();
		}
public ArrayList viewCard(){
	
	return null;
}
	public static void main(String[] args) {
		DateManger d=new DateManger();
		//d.addCard();
		d.getView("d","10021");
	}

}