sqldemo.java

Java程序设计实用案例教程源代码

package database;

import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

public class SQLDemo {


	public static void main(String[] args) {
		JDBCConn demo = new JDBCConn();
		String input = null;
		List<User> list = new ArrayList<User>();
		list = demo.searchByStatement(input);
		// 列出数据表中所有的数据
		System.out.println("所有的数据：");
		Iterator<User> it = list.iterator();
		while (it.hasNext()) {
			User u = (User)it.next();
			System.out.println("username:" + u.getUsername() + 
					"  password: " + u.getPassword() + 
					"  age: " + u.getAge());
		}
		// 列出所有年龄为22的用户的资料
		System.out.println("年龄等于22的用户");
		list = demo.searchByPS(22);
		it = list.iterator();
		while (it.hasNext()) {
			User u = (User)it.next();
			System.out.println("username:" + u.getUsername() + 
					"  password: " + u.getPassword() + 
					"  age: " + u.getAge());
		}
		// 新建User对象,并设置相关的属性
		User user = new User();
		user.setId(4);
		user.setAge(22);
		user.setPassword("123");
		user.setUsername("xiaoming");
		// 将这个对象插入数据表中
		demo.Insert(user);
		// 列出所有数据
		System.out.println("所有的数据：");
		list = demo.searchByStatement(input);
		it = list.iterator();
		while (it.hasNext()) {
			User u = (User)it.next();
			System.out.println("username:" + u.getUsername() + 
					"  password: " + u.getPassword() + 
					"  age: " + u.getAge());
		}
		// 删除id为4的用户资料
		demo.Delete(4);
		System.out.println("删除ID为4的数据后：");
		// 列出删除ID为4的数据后的数据
		list = demo.searchByStatement(input);
		it = list.iterator();
		while (it.hasNext()) {
			User u = (User)it.next();
			System.out.println("username:" + u.getUsername() + 
					"  password: " + u.getPassword() + 
					"  age: " + u.getAge());
		}
		
	}

}