以前初學時收集的一些代碼（JSP）

最後更新：2018-12-05 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

下面的程式是test.jsp檔案：
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>測試頁</title>

function test_onsubmit() {
if (document.test.name.value=="")
{
alert("Sorry，姓名沒有輸入！")
document.test.name.focus()
return false
}
else if(document.test.password.value=="" || document.test.password.value.toUpperCase()=="HTTP://")
{
alert("Sorry，密碼沒有輸入！")
document.test.password.focus()
return false
}
}

//-->
</script>
<link rel="stylesheet" href="css/style.css"> _fcksavedurl=""css/style.css">"
</head>
<body>
<div align="center">
<p> </p>
<p>測試頁</p>
<form name="test" method="post" LANGUAGE="javascript" onsubmit="return test_onsubmit()" action="doadd.jsp">
<p>姓名：
<input name="name" type="text" size="16" maxlength="16">
</p>
<p>密碼：
<input name="password" type="text" size="16" maxlength="16">
</p>
<p>
<input type="submit" name="Submit" value="提交">
</p>
</form>
<p> </p>
</div>
</body>
</html>

下面是doadd.jsp檔案：
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%! String name,password;%>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
//test為資料庫
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
request.setCharacterEncoding("GB2312");
name=request.getParameter("name")[0].trim();
password=request.getParameter("password")[0].trim();
stmt.executeUpdate("insert into test1(name,password) values("+name+","+password+")");
%>
<%
stmt.close();
conn.close();
%>

我在 servlet 中用 response 重新定向用戶端
父表單為：aa.jsp
servlet 中定向代碼為： response.rendRedirect("bb.jsp");

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn=DriverManager.getConnection"jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=MYDATA","sa","123");

<%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:@myoracle";
String uid="system";
String pwd=" manager ";
Connection con = DriverManager.getConnection(url,uid,pwd);
Statement stmt=con.createStatement();
ResultSet rst=stmt.executeQuery("select * from book");
while(rst.next())
{
out.println("<tr>");
out.println("<td>"+rst.getString("BOOKID")+"</td>");
out.println("<td>"+rst.getString("bookname")+"</td>");
out.println("<td>"+rst.getString("publisher")+"</td>");
out.println("<td>"+rst.getFloat("price")+"</td>");
out.println("</tr>");

}
rst.close();
stmt.close();
con.close();
%>
</table>
</body>
</html>

<%@page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<html>
<head>
<title>
讀資料庫
</title>
</head>
<body>
<%
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){
%>
<%=e%>
<%
}
try{
Connection con=DriverManager.getConnection("jdbc:odbc:test2");
Statement sql=con.createStatement();
ResultSet rs=sql.executeQuery("select * from table1");
while(rs.next())
{
%>
<%=rs.getString("name")%>
<%=rs.getString("password")%>
<%
}
rs.close();
sql.close();
con.close();
}catch(SQLException ee){
%>
<%=ee%>
<%
}
%>
nihao!
</body>
</html>

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More