医药销售电站课题.docVIP

摘 要 随着计算机技术的迅猛发展ABSTRACT Fly along with the fast development in computer technology, we have got ten big progresses in school science and information management. So it needs equal development in every part. The school will be building an information management and educational plat from hardware and software two sides. I developed this system is in order to reduce the teachers pressure, enhance the work efficiency, optimize the process of students testing, enhance the student’s identity and papers secrecy. It can save more people money and time thantraditionmethods. This paper gives the basic design idea of the Browser/Server structure based online course elect system by analyzing the characteristic of the Browser/Server structure and combining with the actual public elective courses conditions of our school．It introduces the function module and database design briefly，followed by a discussion on database accessing technology and the active page technology of the course elect system based on JSP and Mysql．By using this system，students can elect courses online efficiently．This Browser/Server structure system is developed under Myeclipse platform in Windows XP operating system, using Java as JSP development language and Mysql as the database. This system is of higher security and better performance. The character string, which is used to connecting to the database, can be modified at any time in the file “web.config”. The string is encoded and encrypted, increasing flexibility of the system and security of the database. In code, making use of stored procedure and minimizing the database opening time to improve performance of the system.. KEYWORDS： 目 录 摘 要 I ABSTRACT II 1 绪 论 1 1.1引言 1 1.2 南京艾斯医药系统构架 1 1.2.1 南京艾斯医药系统需求分析 1 1.2.2 类似网上购物系统 1 2 JSP技术综述 3 2.1 Tomcat6.0与JSP的结合 3 2.2 JSP的内部特点 3 2.2.1 JSP内部9特点 3 2.3 利用JDBC访问数据库 4 2.3.1 装入JDBC驱动程序 4 2.3.2 定义ＪＤＢＣ　ＵＲＬ 5 2.3.3 建立连接 5 2.3.4 创建语句并操作数据库 5 2.3.5 关闭数据对象和链