testdata.java

来自「spring 源码,用于spring框架学习者以及spring框架的爱好者学习」· Java 代码 · 共 35 行

package coma;
import java.util.*;
import java.sql.*;
public class TestData {
	public List select()
	{
		String sql = "select * from demojdbc";
		DataBasePool dbp = new DataBasePool();
		ResultSet rs = dbp.search(sql);
		List list = new ArrayList();
		try {
			while(rs.next())
			{
				User u = new User();
				u.setId(rs.getInt("id"));
				u.setName(rs.getString("name"));
				u.setPassword(rs.getString("password"));
				list.add(u);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	public void delete(int id)
	{
		String sql = "delete from demojdbc where id = "+id+"";
		DataBasePool dbp = new DataBasePool();
		dbp.update(sql);
		
	}

}