JSP elements

最新推荐文章于 2024-07-31 17:13:00 发布

weixin_30294709

最新推荐文章于 2024-07-31 17:13:00 发布

阅读量123

点赞数

文章标签：数据库 javascript java ViewUI

原文链接：http://www.cnblogs.com/52qin/articles/2308536.html

版权

1.html page

 1 <html>
 2 <head>
 3     <title>First Servlet</title>
 4     <script language="javascript">
 5 function IsEmp()
 6     {
 7 if(document.login.username.value=="")
 8     {
 9         alert("Please Enter Your name!");
10 return false;
11         }
12 else
13     {
14 return true;
15     }
16     }
17 </script>
18 </head>
19 <body bgColor="red">
20     <form name="login" action="doInset.jsp" method="get">
21     <input type="text" name="username"></input>
22     <input type="password" name="password"></input>
23     <input type="submit" value="Submit" onClick="return IsEmp();"></input>
24     </form>
25 </body>
26 </html>

2.JSP page

<%@ page import="java.sql.*" %>

<html><head>
<title>Demo</title></head>
<body>
    <%! 
    Connection conn;
    PreparedStatement pstmt;
    Statement stmt;
int rt;
    ResultSet rs;
    String username,password;

public void doInsertAndDisplay()
    {
try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            conn = DriverManager.getConnection(
                    "Jdbc:Oracle:thin:@localhost:1521:ORCL1","scott","tiger");
        }
catch(Exception e)
        {
            System.out.println(e);
        }
    }
    %>
    <% 
    doInsertAndDisplay();
try
    {
        username=request.getParameter("username");
int uid=Integer.parseInt(username);
        password=request.getParameter("password");
        pstmt = conn.prepareStatement("insert into userdetails values(?,?)");
        pstmt.setInt(1,uid);
        pstmt.setString(2,password);
        pstmt.executeUpdate();
        stmt=conn.createStatement();
        rs   = stmt.executeQuery("select * from userdetails");

while(rs.next())
        {
            out.println(rs.getInt(1)+" "+rs.getString(2));
        }
    }
catch(Exception e)
    {
        out.println(e);
    }
     %>
</body></html>

3.Oracle table

1 CREATE TABLE userdetails(userid number(16),password varchar2(16));

转载于:https://www.cnblogs.com/52qin/articles/2308536.html

weixin_30294709

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
JSP elements

1.html page 1 <html> 2 <head> 3 <title>First Servlet</title> 4 <script language="javascript"> 5 function IsEmp() 6 { 7 if(document.login.username.value=="...
复制链接

扫一扫