citydao.java

这是本人最初练习ajax时的小程序,是用ＪＳＰ写的

package com.chinasoft.servlet;

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

public class CityDAO {
private Connection conn=null;
private final static String querymenu="select name from ajaxtable1 where parentid=?";
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 getcity(){
	getConn();
	try {
		PreparedStatement psmt=conn.prepareStatement(querymenu);
		
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	List menulist=new ArrayList();
	
	return menulist;
	
}
}