join.java

来自「实现网上选课等相关功能 建立两个用户 管理员和普通用户」· Java 代码 · 共 41 行

package tom.jiafei;
import java.sql.*;
public class join {
	String hwDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	Connection connect = null;
	ResultSet rs = null;
	public join() {
		try {
			Class.forName(hwDriver); 
		}
		catch(java.lang.ClassNotFoundException e) {
			System.err.println( e.getMessage());
		}
	}
	
	public ResultSet executeQuery(String sql) {
		try {
			connect = DriverManager.getConnection("jdbc:odbc:sun","sa",""); 
			Statement sjk = connect.createStatement();
			rs = sjk.executeQuery(sql);
		} 
		catch(SQLException ex) { 
			System.err.println(ex.getMessage());
		}
		return rs;
	}
	
	public int executeUpdate(String sql) {
		int result = 0;
		try {
			connect = DriverManager.getConnection("jdbc:odbc:sun","sa",""); 
			Statement sjk = connect.createStatement();
			result = sjk.executeUpdate(sql);
		} 
		catch(SQLException ex) { 
			System.err.println(ex.getMessage());
		}
		return result;
	}
}