【Java开源代码栏目提醒】:网学会员Java开源代码为您提供From_Teacher.java参考,解决您在From_Teacher.java学习中工作中的难题,参考学习。
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;
class From_Teacher {
public Vector getteacher(Connection con, String sql) {
Vector v = new Vector();
try {
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);
/**
* 通过结果集中的getString方法从数据库中表中提取表字段的数据 再将提取出来的数据赋值给教师对象。
* 最后将学生对象存储到vector数据结构中
*/
while (rs.next()) {
String name = rs.getString(1);
String code = rs.getString(2);
String sexy = rs.getString(3);
String age = rs.getString(4);
String address = rs.getString(5);
String birthday = rs.getString(6);
String salary = rs.getString(7);
String major = rs.getString(8);
String duty = rs.getString(9);
teacherBean ss = new teacherBean(name, code);
ss.setsexy(sexy);
ss.setmajor(major);
ss.setbirthday(birthday);
ss.setaddress(address);
ss.setage(age);
ss.setsalary(salary);
ss.setduty(duty);
v.add(ss);
}
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
return v;
}
public teacherBean getobject(Connection con, String stname) {
teacherBean sst = null;
try {
Statement st = con.createStatement();
// String sql="select * from studentinfo where name='"+stname+"'";
ResultSet rs = st
.executeQuery("select * from studentinfo where class='二班'and major='英语系'");
while (rs.next()) {
String code = rs.getString(2);
String sexy = rs.getString(3);
String age = rs.getString(4);
String address = rs.getString(5);
String birthday = rs.getString(6);
String salary = rs.getString(7);
String major = rs.getString(8);
String duty = rs.getString(9);
sst = new teacherBean(stname, code);
sst.setsexy(sexy);
sst.setmajor(major);
sst.setbirthday(birthday);
sst.setaddress(address);
sst.setage(age);
sst.setsalary(salary);
sst.setduty(duty);
}
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
return sst;
}
// /通过设置数据库的URL,密码,用户名来建立与数据库的连接
public Connection getConnection() {
Connection con = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// 加载odbc数据驱动
con = DriverManager.getConnection("jdbc:odbc:myodbc", "", "");
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
return con;
}
}