Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
1
I need this SQL database to speak with a user interface JSP, perhaps MVC pattern. How can I do it? An example will help.
S3 SQL file
-- Table `S3_db`.`Recruit_Contact`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `s3_db`.`recruit_contact` (
`idRecruit_Contact` INT(11) NOT NULL ,
`Recruit_Name` VARCHAR(45) NULL DEFAULT NULL ,
`Recruit_Phone` INT(11) NULL DEFAULT NULL ,
`Recruit_Address` VARCHAR(45) NULL DEFAULT NULL ,
`Recruit_Citizenship` VARCHAR(45) NULL DEFAULT NULL ,
`Recruit_JobSearch` VARCHAR(45) NULL DEFAULT NULL ,
`Recruit_JobFilled` VARCHAR(45) NULL DEFAULT NULL ,
`Recruit_JobApplied` VARCHAR(45) NULL DEFAULT NULL ,
PRIMARY KEY (`idRecruit_Contact`) )
JSP mainpage file
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@include file="/header.jsp" %>
<%@include file="/left_column.jsp" %>
<%@include file="header.jsp" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Staffing 3</title>
</head>
<body>
<td width="404" valign="top">
<h1>Hello Staffing 3 Recruiters</h1>
<td>
</body>
<%@include file="/right_column.jsp" %>
<%@include file="/footer.jsp" %>
</html>
No replies to this topic
Back to top
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users
