If you can findout in your computer if it install otherwise install required software Required software and API for JDBC
You can use CTRL + Shift + N as a shortcut
Please see the screenshot
Please see the screenshot for more verification
Now next step is to add MySql connector in Libraries for jdbc connectivity
MYSQL CONNECTOR FOR JAVA
https://drive.google.com/file/d/14vmjSj3LQ_ZKg7rcZgqPKlCEpC4hVDZ_/view?usp=sharing
use rkmishradb
create table covidtest
( medicalid varchar(100) primary key,
pname varchar(100),
covidresult varchar(100)
)
Now you cursor will start blinking on jButtonActionPerformed()
try{
// Loading Driver
Class.forName("com.mysql.jdbc.Driver");
//Creating Connection
Connection con=DriverManager.getConnection("jdbc:mysql://172.16.100.8/rkmishradb","rkmishra","a");
// Create Statement
Statement stmt =con.createStatement();
// Storing Values to String avraible
String mid=jTextField1.getText();
String pname=jTextField2.getText();
String result =jTextField3.getText();
// Execute Query
stmt.executeUpdate("insert into covidtest(medicalid,pname,covidresult)values('"+mid+"','"+pname+"','"+result+"')");
JOptionPane.showMessageDialog(null, "Data Successfully Saved");
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null, "Something Wrong" + e);
}
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
try{
// Loading Driver
Class.forName("com.mysql.jdbc.Driver");
//Creating Connection
Connection con=DriverManager.getConnection("jdbc:mysql://172.16.100.8/rkmishradb","rkmishra","a");
// Create Statement
Statement stmt =con.createStatement();
// Execute Query
ResultSet rs= null;
rs=stmt.executeQuery("select *from covidtest");
DefaultTableModel tm=(DefaultTableModel)jTable1.getModel();
tm.setRowCount(0);
while(rs.next())
{
Object o[]={rs.getString(1),rs.getString(2),rs.getString(3)};
tm.addRow(o);
}
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null, "Something Wrong" + e);
}
}