odbcaccess.java

来自「毕业论文选题系统 学生可以通过次系统在网上进行选题 老师可以布置任务 我写」· Java 代码 · 共 61 行

package org.aaron.db;
import java.util.ArrayList;
import java.util.List;
import java.sql.*;

public class ODBCAccess {
	Connection conn = null;
	Statement stmt = null;
	ResultSet rs = null;
	List<Student> result = new ArrayList<Student>();
	
	public List<Student> setUpDB(){
		String url = "jdbc:odbc:ChooseSubject";
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn = DriverManager.getConnection(url,"admin","admin");
			stmt = conn.createStatement();
			
			//下面是查询语句
			String sql = "select * from Student";
			rs = stmt.executeQuery(sql); 
			
			while (rs.next()){
				Student stu = new Student();
				stu.setId(rs.getString(1));
				stu.setStudentNo(rs.getString(2));
				stu.setPhone(rs.getString(3));
				stu.setName(rs.getString(4));
				stu.setPassword(rs.getString(5));
				stu.setSubjectId(rs.getString("subjectId"));
				stu.setChooosed(rs.getBoolean("choosed"));
				stu.setEmail(rs.getString("email"));
				result.add(stu);
			}
			
			
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if (rs!=null)
				rs.close();
				if (stmt!=null)
				stmt.close();
				if (conn!=null)
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			
		}
		return result;
	}
	public static void main (String [] args){
	ODBCAccess oa = new ODBCAccess();
	oa.setUpDB();
	}
}