?? registerservlet.java
字號:
package dcfs;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class for Servlet: RegisterServlet
*
*/
public class RegisterServlet extends javax.servlet.http.HttpServlet implements
javax.servlet.Servlet {
/**
*
*/
private static final long serialVersionUID = 1L;
public RegisterServlet() {
super();
}
public void destroy() {
super.destroy();
}
protected void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
// 從表單中獲得用戶注冊的信息，并將這些信息存入對應的變量中，以便執行數據操作
String id = request.getParameter("id");
String password = request.getParameter("password");
String username = new String(request.getParameter("username").getBytes(
"ISO-8859-1"), "GB2312");
String sex = request.getParameter("sex");
String school = new String(request.getParameter("school").getBytes(
"ISO-8859-1"), "GB2312");
String major = request.getParameter("major");
major = new String(major.getBytes("ISO-8859-1"), "GB2312");
String phone = request.getParameter("phone");
String email = request.getParameter("email");
// 處理復選框的信息
String[] hobby = request.getParameterValues("hobby");
StringBuffer temp = new StringBuffer("");
for (int i = 0; i < hobby.length; i++) {
temp = temp.append(hobby[i]+",");
}
String hobbies = temp.toString();
String address = new String(request.getParameter("address").getBytes(
"ISO-8859-1"), "GB2312");
String introduce = request.getParameter("introduce");
introduce = new String(introduce.getBytes("ISO-8859-1"), "GB2312");
// 設置頁面的屬性
response.setContentType("text/html");
response.setCharacterEncoding("GBK");
PrintWriter out = response.getWriter();
out.print("<html>");
out.print("<head>");
out.println("<title>信息發布</title>");
out.println("</head>");
out.println("<body>");
// 聲明數據庫連接的相關對象
Connection con;
Statement sql;
Statement sql_select;
ResultSet rs;
// 定義數據庫查詢操作語句
String stmt_select = "select * from user_info where ID號='" + id + "'";
// 定義數據庫更新操作語句
String stmt = "insert into user_info(ID號,密碼,姓名,性別,學校,專業,電話,郵箱,興趣,住址,自我簡介,上次登錄時間,登錄次數) values('"
+ id
+ "','"
+ password
+ "','"
+ username
+ "','"
+ sex
+ "','"
+ school
+ "','"
+ major
+ "','"
+ phone
+ "','"
+ email
+ "','"
+ hobbies
+ "','"
+ address
+ "','"
+ introduce + "',sysdate,1)";
// 加載數據庫驅動程序
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
System.out.println("ClassNotFound~~~~~~");
}
// 建立與數據庫的連接
try {
con = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:orcl", "hongshuai",
"hongshuai");
System.out.println("數據庫連接成功！");
sql_select = con.createStatement();
sql = con.createStatement();
// 執行數據庫SQL語句，查詢數據庫中是否為相同的id號用戶
rs = sql_select.executeQuery(stmt_select);
if (rs.next()) {
String id_db = rs.getString("ID號");
if (id.equals(id_db)) {
out.print("該用ID號已經被注冊，請換用其他的ID號！！<br>");
out.println("</body>");
out.println("</html>");
out.flush();
out.close();
}
} else {
// 執行數據庫SQL語句，向數據庫中插入注冊用戶的信息
sql.execute(stmt);
out.print("祝賀你已經注冊<br>");
out.print("你的ID號為：" + id + "<br>");
out.print("你的密碼為：" + password + "<br>");
out.println("</body>");
out.println("</html>");
out.close();
}
// 關閉數據庫連接
con.close();
System.out.println("數據庫已經關閉!~~~");
} catch (SQLException ex) {
System.out.println("SQL，注冊出錯！");
}
}
public void init() throws ServletException {
super.init();
}
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -