Problem:
How to create jsp create table pages using JSP
Code:
Creating Table in Database:
<%@page import="java.io.*" %>
<%@page import="java.util.*" %>
<%@page import="java.sql.*" %>
<html>
<body>
<%
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("Jdbc:Odbc:orcl","system","orcl");
out.write("Connection to the database successful");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("create table hemanth(name varchar(20),password varchar(20),email varchar(50),phno varchar(20))");
}
catch(Exception e)
{
System.out.println("Error" +e);
}
%>
<p>Table created</p>
</body>
</html>
Creating form using HTML:
<html>
<body>
<table>
<form name="f1" action="http://localhost:2014/project/insert.jsp">
<tr><td>Name:<input type="text" name="t1"/> </td></tr>
<tr><td>Password:<input type="password" name="t2"/> </td></tr>
<tr><td>Email:<input type="text" name="t3"/> </td></tr>
<tr><td>PhoneNO:<input type="text" name="t4"/> </td></tr>
<tr><td><input type="submit" value="insert"/></td>
<td><input type="reset" value="clear"/></td></tr>
</form>
</table>
</body>
</html>
Inserting values into Table:
<%@page import="java.io.*" %>
<%@page import="java.util.*" %>
<%@page import="java.sql.*" %>
<html>
<body>
<table border=1 align="center">
<tr>
<th>Name</th>
<th>Password</th>
<th>Email</th>
<th>Phoneno</th>
</tr>
<%
String s1=request.getParameter("t1");
String s2=request.getParameter("t2");
String s3=request.getParameter("t3");
String s4=request.getParameter("t4");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("Jdbc:Odbc:orcl","system","orcl");
Statement stmt=con.createStatement();
PreparedStatement pstmt=con.prepareStatement("insert into hemanth(name,password,email,phno) values(?,?,?,?)");
pstmt.setString(1,s1);
pstmt.setString(2,s2);
pstmt.setString(3,s3);
pstmt.setString(4,s4);
pstmt.executeUpdate();
ResultSet rs=stmt.executeQuery("select * from hemanth");
while(rs.next())
{
%>
<tr><td><%=rs.getString(1)%>
<td><%=rs.getString(2)%>
<td><%=rs.getString(3)%>
<td><%=rs.getString(4)%>
</tr>
<%
}
}
catch(Exception e)
{
System.out.println("Error" +e);
}
%>
</table>
</body>
</html>
How to create jsp create table pages using JSP
Code:
Creating Table in Database:
<%@page import="java.io.*" %>
<%@page import="java.util.*" %>
<%@page import="java.sql.*" %>
<html>
<body>
<%
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("Jdbc:Odbc:orcl","system","orcl");
out.write("Connection to the database successful");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("create table hemanth(name varchar(20),password varchar(20),email varchar(50),phno varchar(20))");
}
catch(Exception e)
{
System.out.println("Error" +e);
}
%>
<p>Table created</p>
</body>
</html>
Creating form using HTML:
<html>
<body>
<table>
<form name="f1" action="http://localhost:2014/project/insert.jsp">
<tr><td>Name:<input type="text" name="t1"/> </td></tr>
<tr><td>Password:<input type="password" name="t2"/> </td></tr>
<tr><td>Email:<input type="text" name="t3"/> </td></tr>
<tr><td>PhoneNO:<input type="text" name="t4"/> </td></tr>
<tr><td><input type="submit" value="insert"/></td>
<td><input type="reset" value="clear"/></td></tr>
</form>
</table>
</body>
</html>
Inserting values into Table:
<%@page import="java.io.*" %>
<%@page import="java.util.*" %>
<%@page import="java.sql.*" %>
<html>
<body>
<table border=1 align="center">
<tr>
<th>Name</th>
<th>Password</th>
<th>Email</th>
<th>Phoneno</th>
</tr>
<%
String s1=request.getParameter("t1");
String s2=request.getParameter("t2");
String s3=request.getParameter("t3");
String s4=request.getParameter("t4");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("Jdbc:Odbc:orcl","system","orcl");
Statement stmt=con.createStatement();
PreparedStatement pstmt=con.prepareStatement("insert into hemanth(name,password,email,phno) values(?,?,?,?)");
pstmt.setString(1,s1);
pstmt.setString(2,s2);
pstmt.setString(3,s3);
pstmt.setString(4,s4);
pstmt.executeUpdate();
ResultSet rs=stmt.executeQuery("select * from hemanth");
while(rs.next())
{
%>
<tr><td><%=rs.getString(1)%>
<td><%=rs.getString(2)%>
<td><%=rs.getString(3)%>
<td><%=rs.getString(4)%>
</tr>
<%
}
}
catch(Exception e)
{
System.out.println("Error" +e);
}
%>
</table>
</body>
</html>
No comments:
Post a Comment