testsel.java

来自「JSP编写的汽车门户系统」· Java 代码 · 共 26 行

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();
		}
	}
}