📄 dbasefinal.java
字号:
/*Assign NO:1
Roll No :J 30
Prob Statmt:Write a Servlet program to add information in the database from an HTML form (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 dbasefinal 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:data");
out.println("<html><head><title>database</title></head>");
String name = req.getParameter("name");
String acc_no = req.getParameter("acc_no");
String amt = req.getParameter("amt");
String city = req.getParameter("city");
String passwd = req.getParameter("passwd");
Statement stmt = con.createStatement();
stmt.executeUpdate("insert into Table1 values ('"+name+"','"+acc_no+"','" +amt+ "','" +city+ "','" + passwd + "')");
stmt=con.createStatement();
rs=stmt.executeQuery("select name,acc_no,amt,city,passwd from Table1");
out.println("<body bgcolor=yellow>");
out.println("Complete database");
out.println("<font style=Small Fonts>");
out.println("<table border=1>");
out.println("<td>name</td>");
out.println("<td>acc_No</td></br>");
out.println("<td>amt</td></br>");
out.println("<td>city</td></br>");
out.println("<td>passwd</td></br>");
out.println("<td></td></br>");
while(rs.next())
{
out.println("<tr>");
out.println("<td>");
out.println(rs.getString("name")+" ");
out.println("</td>");
out.println("<td>");
out.println(rs.getString("acc_no")+" ");
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 se)
{
out.println("sql exception"+se);
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -