updata.java

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

package Updata;

import java.sql.*;
public class Updata{

		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;
		}


}