testsel.java

学校期间做的实践项目

package com.sw06701.test;

import java.sql.ResultSet;
import java.sql.SQLException;

import com.sw06701.dao.Linkdb;

public class TestSel {
	public static void main(String[] args) {
		try {
			Linkdb linkdb = new Linkdb();
			String sql = "select a.userid,a.username,a.email,b.privname "
					+ "from tabsysuser a ,basepriv b where a.basepriv = b.privid;";
			ResultSet rs = linkdb.executeQuery(sql);
			while (rs.next()) {
				System.out.println(rs.getString("userid"));
				System.out.println(rs.getString("username"));
				System.out.println(rs.getString("email"));
				System.out.println(rs.getString("privname"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}