📄 hello.java
字号:
/*
* Hello.java
*
* Created on 2001年12月11日, 上午10:23
*/
package com.huangdf.demo2;
import java.io.*;
import java.net.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
*
* @author Administrator
* @version
*/
public class Hello extends HttpServlet {
/** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=gb2312");
PrintWriter out = response.getWriter();
String firstname = request.getParameter("firstname");
String lastname = request.getParameter("lastname");
String address = request.getParameter("address");
String account = request.getParameter("account");
String income = request.getParameter("income");
String phonenumber = request.getParameter("phonenumber");
int rows =0;
Connection dbcon = null;
String sql = "insert into registration values(?,?,?,?,?,?)";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbcon= DriverManager.getConnection("jdbc:odbc:MyDataSource","stu1","");
PreparedStatement s = dbcon.prepareStatement(sql);
s.setString(1,firstname);
s.setString(2,lastname);
s.setString(3,address);
s.setString(4,account);
s.setDouble(5, Double.valueOf(income));
s.setString(6,phonenumber);
rows = s.executeUpdate();
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
} catch(SQLException e){
e.printStackTrace();
} catch(NumberFormatException nfe){
System.out.println("NumberFormatException");
}
if(rows==1){
System.out.println("The values have been inserted into the registration table");
}else{
System.out.println("Error inserting data in the registration table");
}
sql = "select max(cRegistration_id) from registration";
try {
PreparedStatement s = dbcon.prepareStatement(sql);
ResultSet rs = s.executeQuery();
rs.next();
int regno = rs.getInt(1);
out.println("<html><head><title>Online Banking with Earnest</title></head>");
out.println("<body bgcolor='pink'>");
out.println("Your registration ID is : <b>"+ regno + "</b>");
out.println("</body></html>");
} catch (SQLException ex) {
ex.printStackTrace();
}
out.close();
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/** Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Returns a short description of the servlet.
*/
public String getServletInfo() {
return "Short description";
}
// </editor-fold>
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -