Java-Netbeans , SQL

How to joint two tables using SQL for java:

Use below program:

import java.sql.*;

public class jdbcConn

{

public static void main(String[] args) throws Exception

{

Class.forName("org.apache.derby.jdbc.ClientDriver");

Connection con = DriverManager.getConnection ( "jdbc:derby://localhost:1527/testDb","username", "password");

Statement stmt = con.createStatement();

String query ="SELECT fname,lname,isbn from author inner join books on author.AUTHORID = books.AUTHORID";

ResultSet rs = stmt.executeQuery(query);

System.out.println("Fname Lname ISBN");

while (rs.next())

{

String fname = rs.getString("fname");

String lname = rs.getString("lname");

int isbn = rs.getInt("isbn");

System.out.println(fname + " " + lname+" "+isbn); }

System.out.println();

}

how to control one jframe to another jframe buttons

btnLogin.addActionListener(new ActionListener()

{

public void actionPerformed(ActionEvent e)

{

this.setVisible(false);

new FrmMain().setVisible(true);

// Main Form to show after the Login Form..

}

});

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manali Kadam7y ago
How to joint two tables using SQL for java:

Use below program:

import java.sql.*;
public class jdbcConn
{
public static void main(String[] args) throws Exception
{
Class.forName("org.apache.derby.jdbc.ClientDriver");
Connection con = DriverManager.getConnection ( "jdbc:derby://localhost:1527/testDb","username", "password");
Statement stmt = con.createStatement();
String query ="SELECT fname,lname,isbn from author inner join books on author.AUTHORID = books.AUTHORID";
ResultSet rs = stmt.executeQuery(query);
System.out.println("Fname Lname ISBN");
while (rs.next())
{
String fname = rs.getString("fname");
String lname = rs.getString("lname");
int isbn = rs.getInt("isbn");
System.out.println(fname + " " + lname+" "+isbn); }
System.out.println();
System.out.println();
}
}

how to control one jframe to another jframe buttons

btnLogin.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
this.setVisible(false);
new FrmMain().setVisible(true);
// Main Form to show after the Login Form..
}
});
Rajkiran Swain8y ago
https://www.codeproject.com/Questions/464024/Java-swings-displaying-JPanel-on-button-click-in-t