📄 userdbopreation.java
字号:
package xinwen;import java.sql.*;public class UserDbOpreation { Connection dbConnection = null; PreparedStatement pStatement = null; ResultSet res = null; public int UsersInsert(User name) throws SQLException { int result = 0; try { dbConnection = ConnectionManager.getConnection(); String sqlStr = "insert into User (loginname,password) values(?,?)"; pStatement = dbConnection.prepareStatement(sqlStr); pStatement.setString(1, name.getName()); pStatement.setString(2, name.getPassWord()); pStatement.executeUpdate(); sqlStr = "select count(*) from User "; pStatement = dbConnection.prepareStatement(sqlStr); res = pStatement.executeQuery(); } catch (Exception e) { e.printStackTrace(); } finally { ConnectionManager.closeResultSet(res); ConnectionManager.closeStatement(pStatement); ConnectionManager.closeConnection(dbConnection); } return result; }}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -