?? personquery.java
字號:
package com.itsv.gankao.database;import java.sql.*;import java.util.*;import com.itsv.gankao.common.*;public class PersonQuery extends Query { public PersonQuery() { } public void searchByDepartId(Connection conn, String periodId, String departId) throws SQLException{ String sql = "SELECT " + PersonTable.wholeSql + " FROM " + PersonTable.TABLE_NAME + "," + ScoreTable.TABLE_NAME + "," + DepartmentTable.TABLE_NAME + " WHERE " + DepartmentTable.FULL_COL_ID + "=" + PersonTable.FULL_COL_DEP_ID + " AND " + ScoreTable.FULL_COL_PERSON_ID + "=" + PersonTable.FULL_COL_ID + " AND " + ScoreTable.FULL_COL_PERIOD_ID + " =? " + " AND " + DepartmentTable.FULL_COL_ID + "=?"; PreparedStatement statement = conn.prepareStatement(sql); statement.setString(1, periodId); statement.setString(2, departId); statement_ = statement; result_ = statement.executeQuery(); } public String getID() throws SQLException{ return result_.getString(PersonTable.COL_ID); } public String getName() throws SQLException{ return result_.getString(PersonTable.COL_NAME); }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -