Home
Answers
Viewqa
Java-Beginners
i written the program in the files but in adding whole file is writing once again
QuestionAsk Questions?
niharika
i written the program in the files but in adding whole file is writing once again
4 Answer(s) 4 years and 6 months ago
Posted in : Java Beginners
4 Answer(s) 4 years and 6 months ago
Posted in : Java Beginners
View Answers
November 17, 2008 at 3:37 AM
Hi friend,
<html>
<head>
<title>User information</title>
</head>
<body>
<br><br><br>
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" width="400px" height="69">
<tr>
<td width="859" height="69">
<form method="POST" action="userInfomAction.jsp">
<h1 align="center"> User Information Form</h1>
<div align="left">
<table border="1" cellpadding="0" cellspacing="0" width="400px">
<tr>
<td width="50%"><b>Name:</b></td>
<td width="50%"><input type="text" name="name" size="20"></td>
</tr>
<tr>
<td width="50%"><b>Last Name:</b></td>
<td width="50%"><input type="text" name="lsname" size="20">
</td>
</tr>
</table>
</div>
<p align="center"><input type="submit" value="Submit" name="submit">
<input type="reset" value="Reset" name="B2"></p>
</form>
<a href="showDataAction.jsp"><b>Click for Show Data</a></b>
</td>
</tr>
</table>
</center>
</div>
</body>
</html>
----------------------------------------
<html>
<head>
<title>User information</title>
</head>
<body>
<br><br><br>
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" width="400px" height="69">
<tr>
<td width="859" height="69">
<form method="POST" action="userInfomAction.jsp">
<h1 align="center"> User Information Form</h1>
<div align="left">
<table border="1" cellpadding="0" cellspacing="0" width="400px">
<tr>
<td width="50%"><b>Name:</b></td>
<td width="50%"><input type="text" name="name" size="20"></td>
</tr>
<tr>
<td width="50%"><b>Last Name:</b></td>
<td width="50%"><input type="text" name="lsname" size="20">
</td>
</tr>
</table>
</div>
<p align="center"><input type="submit" value="Submit" name="submit">
<input type="reset" value="Reset" name="B2"></p>
</form>
<a href="showDataAction.jsp"><b>Click for Show Data</a></b>
</td>
</tr>
</table>
</center>
</div>
</body>
</html>
----------------------------------------
November 17, 2008 at 3:38 AM
<%@page language="java" import="java.sql.*" %>
<%
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String pass="amar123";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,pass);
try{
Statement st = con.createStatement();
String name = request.getParameter("name");
String lsname = request.getParameter("lsname");
int val = st.executeUpdate("insert into userinform(name,lsname) values('"+name+"','"+lsname+"')");
con.close();
out.println("Successfully insert data into Database");
}
catch(SQLException ex){
System.out.println("SQL satatment not found");
}
}
catch(Exception e){
e.printStackTrace();
}
%>
<br>
<a href="userInform.jsp">Home Page</a>
<%
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String pass="amar123";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,pass);
try{
Statement st = con.createStatement();
String name = request.getParameter("name");
String lsname = request.getParameter("lsname");
int val = st.executeUpdate("insert into userinform(name,lsname) values('"+name+"','"+lsname+"')");
con.close();
out.println("Successfully insert data into Database");
}
catch(SQLException ex){
System.out.println("SQL satatment not found");
}
}
catch(Exception e){
e.printStackTrace();
}
%>
<br>
<a href="userInform.jsp">Home Page</a>
November 17, 2008 at 3:40 AM
Display record
<%@ page language="java" import="java.io.*, java.sql.*" %>
<html>
<head>
<title>display data</title>
</head>
<body>
<center>
<H1>Display Record From Database<H1>
<br>
<table border="1" cellpadding="0" cellspacing="0" width="500px" height="69">
<tr>
<td></td>
</tr>
<tr>
<td><b>Id<b></td>
<td><b>Name<b></td>
<td><b>Last Name<b></td>
<td><b>Delete<b></td>
</tr>
<%
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String username = "amar";
String password = "amar123";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,username,password);
try{
Statement st = con.createStatement();
String sqlQuery = "Select * from userinform";
ResultSet rs = st.executeQuery(sqlQuery);
int sno = 0;
while(rs.next()){
sno++;
%>
<tr style="background-color:#CCFFFF;">
<td><%=sno%></td>
<td><%=rs.getString("name")%></td>
<td><%=rs.getString("lsname")%></td>
<td><a href = "deleteAction.jsp?id=<%=rs.getInt("id")%>">Delete</a></td>
</tr>
<%
}
rs.close();
con.close();
st.close();
}
catch(SQLException ex){
System.out.println("SQL satatment not found");
}
}
catch(Exception e){
e.printStackTrace();
}
%>
</table>
<a href="userInform.jsp">Home Page</a>
</center>
</body>
</html>
<%@ page language="java" import="java.io.*, java.sql.*" %>
<html>
<head>
<title>display data</title>
</head>
<body>
<center>
<H1>Display Record From Database<H1>
<br>
<table border="1" cellpadding="0" cellspacing="0" width="500px" height="69">
<tr>
<td></td>
</tr>
<tr>
<td><b>Id<b></td>
<td><b>Name<b></td>
<td><b>Last Name<b></td>
<td><b>Delete<b></td>
</tr>
<%
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String username = "amar";
String password = "amar123";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,username,password);
try{
Statement st = con.createStatement();
String sqlQuery = "Select * from userinform";
ResultSet rs = st.executeQuery(sqlQuery);
int sno = 0;
while(rs.next()){
sno++;
%>
<tr style="background-color:#CCFFFF;">
<td><%=sno%></td>
<td><%=rs.getString("name")%></td>
<td><%=rs.getString("lsname")%></td>
<td><a href = "deleteAction.jsp?id=<%=rs.getInt("id")%>">Delete</a></td>
</tr>
<%
}
rs.close();
con.close();
st.close();
}
catch(SQLException ex){
System.out.println("SQL satatment not found");
}
}
catch(Exception e){
e.printStackTrace();
}
%>
</table>
<a href="userInform.jsp">Home Page</a>
</center>
</body>
</html>
November 17, 2008 at 3:41 AM
Delete record code.
<%@page language="java" import="java.sql.*" %>
<%
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String pass="amar123";
String id=request.getParameter("id");
System.out.println("id:"+id);
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,pass);
try{
Statement st = con.createStatement();
String sqlQuery = "delete from userinform where id="+id;
int delete = st.executeUpdate(sqlQuery);
con.close();
out.println("Successfully Delete data into Database");
}
catch(SQLException ex){
System.out.println("SQL satatment not found");
}
}
catch(Exception e){
e.printStackTrace();
}
%>
----------------------------------------
Read for more information.
http://www.roseindia.net/jsp/
Thanks.
Amardeep
<%@page language="java" import="java.sql.*" %>
<%
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String pass="amar123";
String id=request.getParameter("id");
System.out.println("id:"+id);
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,pass);
try{
Statement st = con.createStatement();
String sqlQuery = "delete from userinform where id="+id;
int delete = st.executeUpdate(sqlQuery);
con.close();
out.println("Successfully Delete data into Database");
}
catch(SQLException ex){
System.out.println("SQL satatment not found");
}
}
catch(Exception e){
e.printStackTrace();
}
%>
----------------------------------------
Read for more information.
http://www.roseindia.net/jsp/
Thanks.
Amardeep
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
