ajaxdao.java

来自「这是本人最初练习ajax时的小程序,是用ＪＳＰ写的」· Java 代码 · 共 49 行

package com.chinasoft.servlet;

import java.sql.*;
import java.sql.SQLException;
import java.util.*;

public class AjaxDAO {
private Connection conn=null;
private final static String querystring="select id,name from ajaxtable1 where levelid=0";
protected void getConn(){
	try {
		this.conn=DataSourceFactory.getDataSource().getConnection();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}
protected void freeConn(){
	try {
		this.conn.close();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}
public List getMenu(){
	List list=new ArrayList();
	getConn();
	try {
		PreparedStatement psmt=conn.prepareStatement(querystring);		
		ResultSet rs=psmt.executeQuery();
	while(rs.next()){
		AjaxDTO ajaxdto=new AjaxDTO();
		ajaxdto.setId(rs.getInt("id"));
		ajaxdto.setName(rs.getString("name"));
		list.add(ajaxdto);
		}
	rs.close();
	psmt.close();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}finally{
		freeConn();
	}
	return list;
}
}