开发者社区> 问答> 正文

求解 java GUI写的界面按钮编写

public class Jdbc {
public static Connection getConn(){
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test"", "root", "root");
if (!conn.isClosed()) {
System.out.println("成功连接数据库");
java.sql.PreparedStatement ps = conn.prepareStatement("select * from users");
ResultSet rs = ps.executeQuery();
while (rs.next()) {
System.out.println("id : " + rs.getInt(1) + " name : " + rs.getString(2) + " role : " + rs.getString(3)
" password: " + rs.getString(4)); }}} catch (Exception e) { e.printStackTrace(); } return conn; } }
这是连接数据库的代码 
JButton button_3 = new JButton("查询");

button_3.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
}
});

怎么使输入查询信息后点击这个按钮使数据库信息显示出来

展开
收起
蛮大人123 2016-06-02 15:15:46 2584 0
1 条回答
写回答
取消 提交回答
  • 我说我不帅他们就打我,还说我虚伪
    public void selectUser(){
    Connection conn = null;
    try {
    Class.forName("com.mysql.jdbc.Driver").newInstance();
    conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test"", "root", "root");
    if (!conn.isClosed()) {
    System.out.println("成功连接数据库");
    java.sql.PreparedStatement ps = conn.prepareStatement("select * from users");
    ResultSet rs = ps.executeQuery();
    while (rs.next()) {
    System.out.println("id : " + rs.getInt(1) + " name : " + rs.getString(2) + " role : " + rs.getString(3)
    " password: " + rs.getString(4)); }}} catch (Exception e) { e.printStackTrace(); } return conn; } }
    
    }
    
    接着:
    JButton button_3 = new JButton("查询");
    
    button_3.addActionListener(new ActionListener() {
    public void actionPerformed(ActionEvent arg0) {
    
    selectUser();
    }
    });
    2019-07-17 19:24:58
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
Spring Cloud Alibaba - 重新定义 Java Cloud-Native 立即下载
The Reactive Cloud Native Arch 立即下载
JAVA开发手册1.5.0 立即下载