When writing to the statements rs.last() and rs.beforeFirst() that are used when querying data from a database, these methods return an error because Microsoft SQL does not have this method and requires additional statements to be added.
String SQL =”select * from stu_info”;// query key code
PreparedStatement PSTMT = dbConn. PrepareStatement (SQL,
the ResultSet. TYPE_SCROLL_INSENSITIVE, ResultSet. CONCUR_READ_ONLY); .
ResultSet rs = PSTMT executeQuery ();
Add the key code for the scarlet letter, and rs.last() will work.
However, the ResultSet.CONCUR_UPDATETABLE in the reference article will return an error. I don’t know why…
Refer to the article links: https://blog.csdn.net/pzasdq/article/details/52602730
String SQL =”select * from stu_info”;// query key code
PreparedStatement PSTMT = dbConn. PrepareStatement (SQL,
the ResultSet. TYPE_SCROLL_INSENSITIVE, ResultSet. CONCUR_READ_ONLY); .
ResultSet rs = PSTMT executeQuery ();
Add the key code for the scarlet letter, and rs.last() will work.
However, the ResultSet.CONCUR_UPDATETABLE in the reference article will return an error. I don’t know why…
Refer to the article links: https://blog.csdn.net/pzasdq/article/details/52602730
Read More:
- failed to open usb interface: 0, error: RS2_USB_STATUS_ACCESS
- Error reporting – the project directly introduces the error reporting and solution of. SCSS file
- About idea reporting error “cannot access class”
- about jQuery.js The solution to always reporting errors
- Unity Android solves the problem of information flow advertisement closing and error reporting
- Eslint error reporting and resolution
- Ultimate solution to error reporting of sudo rosdep init of ROS
- Error reporting processing of pyinstaller packaging geopandas environment
- Error reporting: java.lang.nullpointerexception solution
- Error reporting when Lombok @ data and @ builder are used together
- Error reporting of uncapped XML character
- Introduce vuex error reporting solution
- Error reporting of eslint in webstorm
- After matlab2017b is activated, open the error reporting license manager error – 8
- Hadoop cluster: about course not obtain block: error reporting
- Error reporting using PM2 management application
- Error reporting UI hierarchy using uiautomatorviewer
- Brief introduction of idea Lombok and solutions for reporting red and wrong
- Installing qt5.8.0 error reporting during installation process
- Error reporting of OpenCV and Darknet under Python 2.7