Javatpoint Logo

jsp code

By: ksarah*** On: Fri Apr 06 13:18:06 IST 2018     Question Reputation0 Answer Reputation0 Quiz Belt Series Points0  0Blank User
how to connect jsp with oracle 11g.actually i wanna designn a discussion forum jsp based. Up0Down

 
<%@page import="java.sql.*"%>
<%@page import="oracle.jdbc.driver.*;" %>
<%@page import="oracle.sql.*;" %>
<%@page import="oracle.jdbc.driver.OracleDriver;"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<html>
<head>
<title>Auto Refresh Header Example</title>
</head>
<body>
<form>
<center>
<h1>Program Start</h1>
FirstName:<input type ="text" name ="firstName" id="firstName"> <br>

LastName:<input type="text" name ="lastname" id="lastname"> <br>

<input type="submit" value="Submit">
</form>
<%
String username=request.getParameter("username");
String password =request.getParameter("username");

try {


Connection con = null;
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "hr", "hr");
Statement st = null;
PreparedStatement ps=null;
ResultSet rs =null;
String query = "insert into Test (username, username)values ('"+username+"','"+password+"')";

ps.executeUpdate(query);

} catch(Exception ex){

}

%>
</center>
</body>
Image Created0Down

By: [email protected] On: Fri Apr 06 17:19:02 IST 2018 Question Reputation0 Answer Reputation0 Belt Series Points0 0User Image
Are You Satisfied :0Yes0No