mbean.java

会务管理系统

package com;
import java.sql.*;
import com.userbean;
public class mbean
{
	int num=9;
static String title;
	String touch_man;
	String touch_tel;
	String touch_address;
	String begin_time;
	String end_time;
	String place;
	String remark;
static String email;
	Statement stmt;
	ResultSet rs;
	String sql;	
	public void setNum(int n)
	{
		num=n;
	}
	public int getNum()
	{
		return num;
	}
	public void setTitle(String t)
	{
		title=t;
	}
	public String getTitle()
	{
		return title;
	}
	public void setTouch_man(String tm)
	{
		touch_man=tm;
	}
	public String getTouch_man()
	{
		return touch_man;
	}
	public void setTouch_tel(String tt)
	{
		touch_tel=tt;
	}
	public String getTouch_tel()
	{
		return touch_tel;
	}
	public void setTouch_address(String ta)
	{
		touch_address=ta;
	}
	public String getTouch_address()
	{
		return touch_address;
	}
	public void setBegin_time(String bt)
	{
	    begin_time=bt;
	}
	public String getBegin_time()
	{
		return begin_time;
	}
	public void setEnd_time(String et)
	{
		end_time=et;
	}
	public String getEnd_time()
	{
		return end_time;
	}
	public void setPlace(String p)
	{
		place=p;
	}
	public String getPlace()
	{
		return place;
	}
	public void setRemark(String r)
	{
		remark=r;
	}
	public String getRemark()
	{
		return remark;
	}
	public void setEmail(String e)
	{
		email=e;
	}
	public String getEmail()
	{
		return email;
	}
	public void update()throws SQLException
	{	
		userbean u=new userbean();
		u.getRecord();
		sql="update meeting set title='"+title+"',touch_man='"+touch_man+"',touch_tel='"
		+touch_tel+"',touch_address='"+touch_address+"',begin_time='"+begin_time+"',end_time='"
		+end_time+"',place='"+place+"',remark='"+remark+"',email='"+email+"' where num="+num;
	    stmt=u.getCon().createStatement();
	    stmt.executeUpdate(sql);
	    stmt.close();
	    u.getCon().close();
	}
	public void select()throws SQLException
	{
	    userbean u=new userbean();
		u.getRecord();
		sql="select * from meeting where num="+num;
		stmt=u.getCon().createStatement();
	    rs=stmt.executeQuery(sql);
	    while(rs.next())
	    {
	    	title=rs.getString("title");
	    	touch_man=rs.getString("touch_man");
	    	touch_tel=rs.getString("touch_tel");
	    	touch_address=rs.getString("touch_address");
	    	begin_time=rs.getString("begin_time");
	    	end_time=rs.getString("end_time");
	    	place=rs.getString("place");
	    	remark=rs.getString("remark");
	    	email=rs.getString("email");	    	
	    }
	    rs.close();
	    stmt.close();
	    u.getCon().close();	
	}
	public void select1()throws SQLException
	{
	    userbean u=new userbean();
		u.getRecord();	
	}
	public void delete()throws SQLException
	{
		userbean u=new userbean();
		u.getRecord();
		sql="delete meeting where num="+num;
		stmt=u.getCon().createStatement();
		stmt.executeUpdate(sql);
		stmt.close();
		u.getCon().close();
	}	
	/*public static void main(String args[])throws SQLException
	{
		mbean m=new mbean();
		//m.select();
		//System.out.println(title);
		//System.out.println(email);
		//m.delete();
		while(m.select1().next())
		{
			String s=m.select1().getString("title");
			System.out.println(s);
		}
	}*/	
}