Hey guys after week i had a problem again whwn i execute thos in netbens following errors occor
this is the source
in my next button i want to go next recode heres da nxt button code
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:'
try{
if(rs.next()){
String id = rs.getString("BookId");
String booktitle = rs.getString("Title");
String pub = rs.getString("publisher");
String auth = rs.getString("author");
t1.setText(booktitle);
t2.setText(id);
t3.setText(auth);
t4.setText(pub);
}
else{
rs.previous();
JOptionPane.showMessageDialog(data.this, "End Of the records");
}
}
catch(SQLException err){
JOptionPane.showMessageDialog(data.this, err.getMessage());
}
}
the error is this
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at dbconnect.data.jButton3ActionPerformed(data.java:205)
at dbconnect.data.access$400(data.java:19)
at dbconnect.data$5.actionPerformed(data.java:101)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6504)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
at java.awt.Component.processEvent(Component.java:6269)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4860)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4686)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2713)
at java.awt.Component.dispatchEvent(Component.java:4686)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:707)
at java.awt.EventQueue.access$000(EventQueue.java:101)
at java.awt.EventQueue$3.run(EventQueue.java:666)
at java.awt.EventQueue$3.run(EventQueue.java:664)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:680)
at java.awt.EventQueue$4.run(EventQueue.java:678)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:677)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
BUILD SUCCESSFUL (total time: 4 seconds)
Lets find solution guys!!!!!!!!!!!!!!!!!!!
this is a DoConnect method in the coding
ReplyDeletepublic void DoConnect() {
try {
Class.forName("com.mysql.jdbc.Driver");
try {
String host = "jdbc:mysql://localhost:3306/my";
String uName = "root";
String uPass= "";
Connection con = DriverManager.getConnection(host,uName,uPass);
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE );
String SQL = "Select * from books";
ResultSet rs = stmt.executeQuery(SQL);
rs.next();
String id = rs.getString("BookId");
String booktitle = rs.getString("Title");
String pub = rs.getString("publisher");
String auth = rs.getString("author");
t1.setText(booktitle);
t2.setText(id);
t3.setText(auth);
t4.setText(pub);
}
catch (SQLException ex) {
JOptionPane.showMessageDialog(this,ex.getMessage());
}
}
catch (ClassNotFoundException ex) {
Logger.getLogger(data.class.getName()).log(Level.SEVERE, null,ex);
}
}
}