標籤：
package com.hanqi;import java.io.IOException;import java.sql.Connection;import java.sql.DriverManager;import java.sql.*;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class saveuser extends HttpServlet { private static final long serialVersionUID = 1L; public saveuser() { super(); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); //設定字元集 response.setContentType("text/html; charset=UTF-8"); String strUserid = request.getParameter("userid"); //擷取傳遞過來的參數 String strUsername = request.getParameter("username"); String strPW = request.getParameter("password"); if(strUserid == null||strUserid.trim().length()==0) { //判斷擷取的參數是否為空白 response.getWriter().append("使用者ID不可為空"); } else if(strUsername == null||strUsername.trim().length()==0) { response.getWriter().append("使用者名稱稱不可為空"); } else { try { Class.forName("oracle.jdbc.driver.OracleDriver"); //註冊Oracle String url = "jdbc:oracle:thin:@localhost:1521:orcl"; //設定串連oracle資料庫 Connection conn = DriverManager.getConnection(url, "test1204", "1234"); //登入oracle, 串連oracle使用者 if(conn!=null) { //操作資料庫 String sql = "insert into T_Test (user_id, user_name, password)"+"values(?,?,?)"; //設定oracle語句的命令 //執行語句的類 PreparedStatement ps = conn.prepareStatement(sql); //建立類ps, 並下達執行命令 strUsername = new String(strUsername.getBytes("iso-8859-1"),"utf-8"); //轉碼 ps.setString(1, strUserid); //設定寫入oracle表中的值 ps.setString(2, strUsername); ps.setString(3, strPW); int row = ps.executeUpdate(); //執行語句的命令並返回資料行數 if(row>0) { response.getWriter().append("儲存資料成功, 儲存"+row+"條資料成功!"); } else { response.getWriter().append("儲存資料失敗"); } ps.close(); conn.close(); } else { response.getWriter().append("串連資料庫失敗"); } } catch (Exception e) { e.printStackTrace(); response.getWriter().append(e.getMessage()); } } } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); }}
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Strict//EN" "http://www.w3.org/TR/html4/strict.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Insert title here</title></head><body><form id="uform" action="saveuser" method="post">使用者代碼：<input id="userid" type="text" name="userid" width=30 /><br><br>使用者名稱稱：<input id="username" type="text" name="username" width=30 /><br><br>登入密碼：<input id="password" type="password" name="password" width=30 /><br><br>確認密碼：<input id="queren" type="password" name="queren" width=30 /><br><br><input type="submit" value="提交" /></form></body></html>
使用java代碼編輯oracle資料庫
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
