📄 updt.java
字号:
/*Assign NO:2
Roll No :J 20
Prob Statmt:Write a Servlet program to update database on some transactions (fields :- Name,Acc.No.,Amount, City, Password)
*/
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
public class updt extends HttpServlet
{
public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
{
Connection con =null;
ResultSet rs =null;
res.setContentType("text/html");
PrintWriter out =res.getWriter();
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:as2");
out.println("<html><head><title>database</title></head>");
String acc_no = req.getParameter("acc_no");
String name = req.getParameter("name");
String amt = req.getParameter("amt");
String city = req.getParameter("city");
String passwd = req.getParameter("passwd");
Statement stmt = con.createStatement();
stmt.executeUpdate("Update Table2 SET acc_no=('"+acc_no+"') where acc_no=('"+acc_no+"')");
stmt.executeUpdate("Update Table2 SET name=('"+name+"') where acc_no=('"+acc_no+"')");
stmt.executeUpdate("update Table2 SET amt=('"+amt+"') where acc_no=('"+acc_no+"')");
stmt.executeUpdate("update Table2 SET city=('"+city+"') where acc_no=('"+acc_no+"')");
stmt.executeUpdate("update Table2 SET passwd=('"+passwd+"') where acc_no=('"+acc_no+"')");
stmt=con.createStatement();
rs=stmt.executeQuery("select acc_no,name,amt,city,passwd from Table2");
out.println("<body>");
out.println("Updated database");
out.println("<font style=Small Fonts>");
out.println("<table border=1>");
out.println("<td><b>acc_no</td></b>");
out.println("<td><b>name</td></b>");
out.println("<td><b>amt</td></b></br>");
out.println("<td><b>city</td></b></br>");
out.println("<td><b>passwd</td></b></br>");
out.println("<td></td></br>");
while(rs.next())
{
out.println("<tr>");
out.println("<td>");
out.println(rs.getString("acc_no")+" ");
out.println("</td>");
out.println("<td>");
out.println(rs.getString("name")+" ");
out.println("</td>");
out.println("<td>");
out.println(rs.getString("amt")+" ");
out.println("</td>");
out.println("<td>");
out.println(rs.getString("city")+" ");
out.println("</td>");
out.println("<td>");
out.println(rs.getString("passwd")+" ");
out.println("</td>");
out.println("</tr>");
}
out.println("</table>");
out.println("</body></html>");
}
catch(ClassNotFoundException e)
{
out.println("couldnt load db driver"+e.getMessage());
}
catch(SQLException sqle)
{
out.println("sql exception"+sqle);
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -