欧美性猛交XXXX免费看蜜桃,成人网18免费韩国,亚洲国产成人精品区综合,欧美日韩一区二区三区高清不卡,亚洲综合一区二区精品久久

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52

<%@page contentType="text/html;charset=Big5"%>
                        <%@page language="java"%>
                        <%@page import="java.sql.*"%>
                        <%@page import="java.util.Date"%>
                        <%@include file="connection.jsp"%>
                        <%
                        String style, date, subject, content, img_name, img_size, img_type, useraccount, username, usermail;
                        String query_diary,query_register;
                        Date today;
                        ResultSet rs_register = null;
                        request.setCharacterEncoding("big5");
                        style = request.getParameter("public");
                        date = request.getParameter("date");
                        username = null;
                        usermail = null;
                         
                        query_diary = "SELECT * FROM diary where public = ‘"+style+"‘ and write_date = ‘"+date+"‘";
                        MySQL_Open();
                        try
                        {
                        rs = stmt.executeQuery(query_diary);
                        while(rs.next())
                        {
                        useraccount = rs.getString("user_account");
                        subject = rs.getString("diary_subject");
                        content = rs.getString("diary_content");
                        img_name = rs.getString("img_name");
                        img_type = rs.getString("img_type");
                        img_size = rs.getString("img_size");
                        today = rs.getDate("write_date");
                        query_register = "SELECT * FROM register where useraccount = ‘"+useraccount+"‘";
                        try
                        {
                        rs_register = stmt.executeQuery(query_register);
                        rs_register.next();
                        username = rs_register.getString("username");
                        usermail = rs_register.getString("usermail");
                        }
                        catch(SQLException sqle)
                        {
                        out.print(sqle);
                        }
                        //上面這段是重點(diǎn)~~~%>
                        以html來(lái)呈現<%=username%><%=usermail%>等等的各東西
                        <%
                        }//end while
                        }
                        catch(SQLException sqle)
                        {
                        out.print(sqle);
                        }
                        %>
                        

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45

<%!
                        String ip = "127.0.0.1";
                        String db = "diarybook_db";
                        String MySQLuser = "root";
                        String password = "******";
                        Connection conn = null;
                        Statement stmt = null;
                        ResultSet rs = null;
                        ResultSetMetaData rsmd = null;
                        public void MySQL_Close()
                        {
                        try
                        {
                        rs.close();
                        stmt.close();
                        conn.close();
                        }
                        catch(Exception e)
                        {
                        System.out.println(e);
                        }
                        }
                        public void MySQL_Open()
                        {
                        String url = "jdbc:mysql://"+ip+":3306/"+db+"?useUnicode=true&characterEncoding=Big5";
                        try
                        {
                        Class.forName("com.mysql.jdbc.Driver");
                        }
                        catch(Exception e)
                        {
                        System.out.println("can not loadin Driver");
                        }
                        try
                        {
                        conn =  DriverManager.getConnection(url,MySQLuser,password);
                        stmt = conn.createStatement();
                        }
                        catch(SQLException sqle)
                        {
                        System.out.println("SQLException:"+sqle);
                        }
                        }
                        %>