testdao.java

dwr框架以及spring框架的整合

package dao;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import javax.xml.registry.infomodel.User;
/*
 * 
use pubs;
go
create table admin(id int identity(1,1) primary key,username varchar(33),pwd varchar(33))

insert into admin values('fadf','gofad');
 */
import vo.TestDto;

public class TestDao {
	
	public  String a(String test) {
		System.out.println("go....");
		return "hehe";
	}
	
	public TestDto b() {

		TestDto dto = new TestDto();
		dto.setUsername("中国人");
		dto.setPwd("奇强");
		return dto;
	}
	
	public  void c(TestDto d) {
		System.out.println(d.getUsername());
		System.out.println(d.getPwd());
	}
	
	
	public ArrayList d() {
		ArrayList arr = new ArrayList();
		ArrayList arr1 = new ArrayList();
		ArrayList arr2 = new ArrayList();
		arr1.add("小猪");
		arr1.add("jiajia");
		arr2.add("小猪22");
		arr2.add("jiajia22");
		arr.add(arr1);
		arr.add(arr2);
		return arr;
	}
	public void e(List mylist) {
		 for (int i = 0; i < mylist.size(); i++) {
			TestDto d = (TestDto) mylist.get(i);
			System.out.println(d.getUsername());
		}
	 
	}
	
    public ArrayList f() {
    	System.out.println("f");
		ArrayList list = new ArrayList();
		try {
			String sql = "select * from admin";
			
			System.out.print(sql);
			ResultSet rs = DbManage.newInstance().getRs(sql);

			while (rs.next()) {
				TestDto u = new TestDto();
				u.setUsername(rs.getString("username"));
				u.setPwd(rs.getString("pwd"));
				list.add(u);
			}
			return list;
		} catch (Exception e) {
			
			System.out.print(e.getMessage());
			// TODO: handle exception
		}
        return list;
    }   
    
	public  String g(String test) {
		System.out.println("go....");
		return "spring+dwr....hehe";
	}
    
}