studentsdao.java

一个struts的小例子

package com.egt.struts.dao;

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

import com.egt.struts.form.StudentsForm;
import com.egt.struts.subsidiary.DataConnection;

public class StudentsDao {
	
	private Connection conn = null;
	private Statement stmt = null;
	private PreparedStatement ps = null;
	private ResultSet rs = null;
	
	/**
	 * 查找所有学生
	 */
	public List findAll(){
		List list = new ArrayList();
		try{			
			conn = DataConnection.getConnection();
			stmt = conn.createStatement();
			rs = stmt.executeQuery("select * from Student");
			while(rs.next()){
				StudentsForm stu = new StudentsForm();
				stu.setId(rs.getInt("id"));
				stu.setName(rs.getString("name"));
				stu.setAddr(rs.getString("addr"));
				stu.setAge(rs.getInt("age"));
				stu.setSex(rs.getString("sex"));
				list.add(stu);
			}		
		}catch(SQLException e){
			e.printStackTrace();
		}finally{
			try{
				rs.close();
				stmt.close();
				conn.close();
			}catch(SQLException e){
				e.printStackTrace();
			}
		}
		return list;
	}
	
	
	
	/** 
	 * 增加学生
	 */
	public void createStu(StudentsForm stu){
		try{
			conn = DataConnection.getConnection();
			String sql = "insert into Student values(seq_student.nextval,?,?,?,?)";		
			ps = conn.prepareStatement(sql);		
			ps.setString(1, stu.getName());
			ps.setString(2, stu.getAddr());
			ps.setInt(3, stu.getAge());
			ps.setString(4, stu.getSex());			
			ps.executeUpdate();
		}catch(SQLException e){
			e.printStackTrace();
		}finally{
			try{
				ps.close();
				conn.close();
			}catch(SQLException e){
				e.printStackTrace();
			}
		}		
	}
}