?? querytablestore.java
字號:
/**
* 查詢數(shù)據(jù)庫學(xué)生記錄
*/
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Date;
import java.util.Vector;
import java.util.HashMap;
public class QueryTableStore
{
/**
* 從表中查詢出所有記錄
*/
public HashMap getStudent(Connection con)
{
Vector vector = new Vector();//儲存學(xué)生對象
HashMap map = new HashMap();//儲存關(guān)鍵字/值對
StudentStore store = new StudentStore();
try
{
Statement st = con.createStatement();
String sql = "select * from student";
ResultSet rs = st.executeQuery(sql);
while(rs.next())
{
String name =rs.getString("姓名");
String number = rs.getString("學(xué)號");
String sex = rs.getString("性別");
Date date = rs.getDate("出生日期");
String speciality = rs.getString("專業(yè)");
String address = rs.getString("籍貫");
Student one = new Student(name, number);
one.setStudentSex(sex);
one.setStudentSpeciality(speciality);
one.setStudentAddress(address);
one.setStudentBirthday(date.toString());
vector.add(one);
}
st.close();
con.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
store.setStudentVec(vector);
map.put("student", store);
return map;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -