operation.java

是一个javabean,里面封装了对象。然后调用这个类里面的属性

package com.wj.Operation;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import com.wj.DBconnection.Connections;
import com.wj.DataBean.Jobs;

public class Operation {
	Connection con=null;
	PreparedStatement ps=null;
	ResultSet rs=null;
	String sql=null;
	//实例化类
	Connections tion=new Connections();
	//查询所有的方法
	public List selectJobs()
	{
		List list=new ArrayList();
		Connections tion=new Connections();
		try {
			con=tion.getCon();
			sql="select * from jobs";
			ps=con.prepareStatement(sql);
			rs=ps.executeQuery();
			while (rs.next()) {
				Jobs job=new Jobs();
				job.setJob_id(rs.getInt(1));
				job.setJob_desc(rs.getString(2));
				job.setMin_lvl(rs.getInt(3));
				job.setMax_lvl(rs.getInt(4));
				list.add(job);
			}
			//关闭连接
			rs.close();
			ps.close();
			con.close();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
		
	}
	//添加数据
	public boolean addJobs(Jobs job)
	{
		try {
			con=tion.getCon();
			sql="insert into jobs values(?,?,?)";
			ps=con.prepareStatement(sql);
			ps.setString(1, job.getJob_desc());
			ps.setInt(2, job.getMin_lvl());
			ps.setInt(3, job.getMax_lvl());
			int i=ps.executeUpdate();
			if(i>0)
			{
				return true;
			}
			//关闭连接
			rs.close();
			con.close();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return false;
	}
	//修改数据
	public boolean updateJobs()
	{
		return false;
	}
	
}