?? querytable.java
字號:
/**
* 查詢數據庫學生記錄
*/
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Date;
import java.util.Vector;
public class QueryTable
{
/**
* 從表中查詢出所有記錄
*/
public Vector getStudent(Connection con)
{
Vector vector = new Vector();
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("學號");
String sex = rs.getString("性別");
Date date = rs.getDate("出生日期");
String speciality = rs.getString("專業");
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();
}
return vector;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -