?? bookcount.java
字號:
package Bean;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class BookCount {
int count = 0;
public int getBookCount()
{
count = 0;
Connection conn=new DBConn().getConn();
Statement stmt = null;
ResultSet sqlRst = null;
// String sql = "select * from users where username = '" + username + "' and password = '" + password + "' and usertype = 'user'";
// String sql = "select * from users where username = '" + username + "' and password = '" + password + "'";
String sql = "select * from book";
System.out.println(sql);
try {
stmt = conn.createStatement();
sqlRst=stmt.executeQuery(sql); //結(jié)果集對象
while(sqlRst.next())
{
count ++;
}
count ++;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally
{
if(sqlRst != null)
{
try {
sqlRst.close();
stmt.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
return count;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -