MISY350 Lecture Notes - Lecture 10: Javaserver Pages Standard Tag Library, Java Database Connectivity, Boilerplate Code

• School: University of Delaware
• Department: Management Information Systems
• Course: MISY350
• Professor: Mark Serva

Document Summary

Log into pma. lerner. udel. edu (with ur own misy username & pw) Create new table: right click on left sidebar on misy053, ai auto increment to automatically supply a value for us, select proper index, if u use multiple tables, storage engine must be. Add records click on table: click insert, fill in shit, click sql and u will see the sql code of the records. Create project: accessemployee: need 2 libraries: jstl 1. 2. 1 and mysql jdbc driver. Add an entity class a class that acts as a go-b/w from relational db and your application: db has different data types as java, there is no bit type (mysql) in java, the equivalent is. Boolean (java: this file does the mapping in java and mysql. Right click on db, add new connection: driver: should be mysql j driver, host: serva-mysql. lerner. udel, db: name of ur account (misy053, username: misy053, pw: 9991696e, check box remember password , input connection name: lerner mysql.