📄 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();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -