about JDBC

-
JDBC -
    JDBC terms used for java database connectivity. Java has java.sql package which support  java database connectivity (jdbc). This api provides the facility to manage database through java code.
   
With in the java.sql package, Java API has seven classes.
   
1.Date
2.DriverManager
3.DriverPropertyInfo
4.SQLPermission
5.Time
6.Timestamp
7.Types
   
and have 22 interfaces

1.Array
2.Blob
3.CallableStatement
4.Clob
5.Connection
6.DatabaseMetaData
7.Driver
8.NClob
9.ParameterMetaData
10.PreparedStatement
11.Ref
12.ResultSet
13.ResultSetMetaData
14.RowId
15.Savepoint
16.SQLData
17.SQLInput
18.SQLOutput
19.SQLXML
20.Statement
21.Struct
22.Wrapper

and have 17 exceptions.

1.BatchUpdateException
2.DataTruncation
3.SQLClientInfoException
4.SQLDataException
5.SQLException
6.SQLFeatureNotSupportedException
7.SQLIntegrityConstraintViolationException
8.SQLInvalidAuthorizationSpecException
9.SQLNonTransientConnectionException
10.SQLNonTransientException
11.SQLRecoverableException
12.SQLSyntaxErrorException
13.SQLTimeoutException
14.SQLTransactionRollbackException
15.SQLTransientConnectionException
16.SQLTransientException
17.SQLWarning

Comments

Post a Comment

Recent Post

Recent Posts Widget

Popular posts from this blog

Capture image from webcam java code, examples

-
import java.applet.Applet; import java.awt.BorderLayout; import java.awt.Component; import java.awt.Dimension; import java.awt.Frame; import java.awt.Graphics; import java.awt.Graphics2D; import java.awt.Image; import java.awt.Panel; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import java.awt.image.BufferedImage; import java.io.FileOutputStream; import java.net.MalformedURLException; import java.net.URL; import javax.media.Buffer; import javax.media.CaptureDeviceInfo; import javax.media.CaptureDeviceManager; import javax.media.Manager; import javax.media.MediaLocator; import javax.media.Player; import javax.media.control.FrameGrabbingControl; import javax.media.format.VideoFormat; import javax.media.util.BufferToImage; import javax.swing.JButton; import javax.swing.JComponent; import com.sun.image.codec.jpeg.JPEGCodec; import com.sun.image.codec.jpeg.JPEGE
Read more

Use of req.query, req.params and req.body in NODE JS

-
Image
I am writing this article for beginners. Because, at the time of learning node js, this is very confusing where and how we need to use req.query, req.params and req.body . I am going to explain these three req method below. 1.        Req.query 2.        Req.params 3.        Req.body Req.query: When request is coming in key and value pair, for example, if your URL looks like below URL http://localhost:3000/search?name=xyz&age=16 In the above URL, you can see that request is coming in key and value pair . First key is name and value is xyz, second key is age and value is 16. In the node js programing, if you want to parse this url then use req.query. Below is the code snippet to parse this URL. router.get('/search', function(req, res, next) {   var name = req.query.name;   console.log(`Name :  ${name}`)   var age = req.query.age;   console.log(`Age :  ${age}`)   res.send('Request has parsed see console');   }); Req.param
Read more

How to capture finger prints in java

-
Java code for capture finger prints. NBioBSPJNI.FIR_HANDLE hSavedFIR; hSavedFIR = bsp.new FIR_HANDLE(); bsp.Enroll(hSavedFIR, null); // Enroll bsp.Capture(hSavedFIR); // Capture // Get Text FIR if (bsp.IsErrorOccured() == false) { NBioBSPJNI.FIR_TEXTENCODE textSavedFIR; textSavedFIR = bsp.new FIR_TEXTENCODE(); bsp.GetTextFIRFromHandle(hSavedFIR, textSavedFIR); } // Get Binary FIR if (bsp.IsErrorOccured() == false) { NBioBSPJNI.FIR fullSavedFIR; fullSavedFIR = bsp.new FIR(); bsp.GetFIRFromHandle(hSavedFIR, fullSavedFIR); } You can capture both type in your database and file. 1)textFIR 2)BinaryFIR
Read more