Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@page import="java.sql.DriverManager"%>
- <%@page import="java.io.PrintWriter"%>
- <%@page import="java.sql.ResultSet"%>
- <%@page import="java.sql.Connection"%>
- <%@page import="java.sql.DatabaseMetaData"%>
- <%@page import="java.sql.PreparedStatement"%>
- <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
- pageEncoding="ISO-8859-1"%>
- <!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=ISO-8859-1">
- <title>Insert title here</title>
- </head>
- <body>
- <form method="post" action="AddQueWithDept.jsp">
- <CENTER>
- <%! String dat; %>
- Department: <select name="dep">
- <%
- Class.forName("com.mysql.jdbc.Driver");
- Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");
- PreparedStatement ps=con.prepareStatement("select * from deptTopics");
- ResultSet x=ps.executeQuery();
- while(x.next())
- {
- dat = x.getString("DepartmentName");
- %>
- <option value="<%=dat%>"> <%=dat%> </option>
- <%
- }
- %>
- </select><br>
- Topic Name <select name="TopicName">
- <%
- PreparedStatement ps1=con.prepareStatement("select * from deptTopics where DepartmentName = '"+dat+"'");
- ResultSet xy=ps1.executeQuery();
- while(xy.next())
- {
- String datx = xy.getString("TopicName");
- %>
- <option value="<%=datx%>"> <%=datx%> </option>
- <%
- }
- %>
- </select>
- Question<input type="text" name="Question"><br>
- Answer<input type="text" name="Answer">
- <input type="submit" value="submit">
- </CENTER>
- </form>
- </body>
- </html>
Add Comment
Please, Sign In to add comment