searchdb.java

自己写的一个网站,学生管理系,还有带自己写开发文档,可以用于高校学生管理,具体见文档

package Search;

import java.sql.*;
public class SearchDB{

		private static String driverName;
		private String dbURL ;
		private String userName ;
		private String userPwd;
		private Connection dbConn;
		private ResultSet result;
		private Statement sql;

		public  void getConnect(){						//构造函数
			dbURL = "jdbc:odbc:student";		//university为数据源
			driverName = "sun.jdbc.odbc.JdbcOdbcDriver";	//设置驱动程序
			userName = "";
			userPwd = "";
			result=null;
			try{
					Class.forName(driverName);
					dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
					sql = dbConn.createStatement();
					//return sql;
			}

			catch(Exception e) {
					e.printStackTrace();
					//return null;
			}
		}

		public ResultSet getResult(String tableName){		//查找表名为的信息,该表的列数不清为numOfColumn
			try{
					String query = "select * from ";
					query=query+tableName;
					result = sql.executeQuery(query);
					return result;

			}
			catch(Exception e) {
					e.printStackTrace();
					return null;
			}
		}

		public Statement getSql(){
			return sql;
		}

		public boolean getUser(String tableName,String userid,String pwd){

			try{
					String query = "select * from ";
					query=query+tableName;
					result = sql.executeQuery(query);
				}
			catch(Exception e){
					e.printStackTrace();
			}

			try{
					while(result.next()){
						String tempID=result.getString(1);
						String tempPwd=result.getString(2);
						if((userid.equals(tempID))&&(pwd.equals(tempPwd)))
								return true;				//找查到学号是studentID的学生
					}
			}

			catch(SQLException ex){
					System.err.println("SQLException:" + ex.getMessage());
			}

			return false;							//没找到该学生的
		}
		public void close(){
			try{
				dbConn.close();
				sql.close();
			}
			catch(SQLException ex){
								System.err.println("SQLException:" + ex.getMessage());
			}

		}

}