testdb.java

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

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

public class testdb {
	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 = "update subject set choosed = 1,studentId = 5  where id = 6";
			stmt.executeUpdate(sql); 
			
			
		} 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){
	testdb oa = new testdb();
	oa.setUpDB();
	}
}