📄 register.java
字号:
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.io.*;
public class Register extends HttpServlet
{
public void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException,java.io.IOException
{
PrintWriter pw=resp.getWriter();
resp.setContentType("text/html");
pw.println("<html>");
pw.println("<head> <title> Online Banking </title></head>");
pw.println("<body>");
String fName=req.getParameter("txtfname");
String lName=req.getParameter("txtlname");
String addr=req.getParameter("txtaddr");
String type=req.getParameter("txttype");
float income=Float.parseFloat(req.getParameter("txtincome"));
String tel=req.getParameter("txttel");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection dbcon=DriverManager.getConnection("jdbc:odbc:MyDatabase","faculty","");
PreparedStatement ps=dbcon.prepareStatement("insert into registration values (?,?,?,?,?,?)");
ps.setString(1,fName);
ps.setString(2,lName);
ps.setString(3,addr);
ps.setString(4,type);
ps.setFloat(5,income);
ps.setString(6,tel);
int rows= ps.executeUpdate();
if (rows==0)
{
pw.println("Data base insert failure");
pw.println("</body></html>");
dbcon.close();
return;
}
ps = dbcon.prepareStatement("Select max(cregistration_id) from registration");
ResultSet rs=ps.executeQuery();
rs.next();
pw.println("thanks for your registration, and your registration ID is:" + rs.getString(1));
pw.println("</body></html>");
dbcon.close();
return;
}
catch(Exception e)
{
System.out.println(e);
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -