Server Technology PPNT Instrukcja Użytkownika Pobierz pdf (Strona 71)

Java Servlets: Database Manipulation(3/5)

Connection connection = DriverManager.getConnection(

"jdbc:mysql://" + dbms_host_ + "/" + dbms_db_,

dbms_username_,

dbms_password_);

Statement statement = connection.createStatement();

int row = statement.ex ecut eUpd ate(

"INSERT INTO " + dbms_db_table _ + " VALUES(’" +

name + "’,’" + second_name + "’,’" + nr + "’,’" +

study_field + "’,’null’)");

Inserting data with Java (source):

http://coronet.iicm.edu/mmis/examples/java /mys ql/

RegisterStudentServlet.java

(71/95)

1 2 ... 66 67 68 69 70 71 72 73 74 75 76 ... 94 95

Server-side Technologies 1
CGI, PHP, Java Servlets, JSP 1
CGI Speciﬁcation(4/4) 11
CGI Examples(1/7) 12
Example 1: 12
Write HTML to st dout 12
CGI Examples(2/7) 13
Example 1 (continued): 13
Example: 13
CGI Examples(3/7) 14
Example 2: 14
CGI Examples(6/7) 17
Example 4: 17
CGI Examples(7/7) 18
Example 4 (continued): 18
Another CGI example: 18
CGI Applications(1/2) 19
WWW gateways! 19
CGI Applications(2/2) 20
Finger gateway: 20
Mail gateway: 20
1 while s/[(][^()]*[)] //;) 22
... </script> 24
<% ... %> 24
PHP: Hello World(2/3) 25
PHP: Hello World(3/3) 26
PHP: Handling Forms(1/8) 29
PHP: Handling Forms(2/8) 30
PHP: Handling Forms(3/8) 31
Example with GET: 31
Example with POST: 31
Example PHP: 31
Source PHP: 31
PHP: Handling Forms(4/8) 32
PHP: Handling Forms(5/8) 33
PHP: Handling Forms(7/8) 35
>=PHP4.2.0 by default oﬀ 36
Retrieving data with PHP: 40
PHP: XML Manipulation(2/3) 43
PHP: XML Manipulation(3/3) 44
PHP: Image Manipulation(1/3) 45
PHP: Image Manipulation(2/3) 46
PHP: Image Manipulation(3/3) 47
Convinient 52
Huge Java software libraries 52
Servlet Container 55
Apache software foundation 55
Java Servlets - Internal(2/2) 59
Example: Hello World! 60
Hello World: 63
Source code: 63
ECSHelloWorldServlet.java 64
CGI Variables: 66
HTTP Headers: 66
Form for inserting data: 70
Retrieving data with Java 72
XMLRegistrationServlet.java 75
Java Server Pages (JSP) 77
HelloWorld JSP: 77
JSP Elements(1/7) 79
JSP expression 79
</jsp:expression> 79
JSP Elements(3/7) 81
JSP Declaration 81
</jsp:declaration> 81
JSP Elements(4/7) 82
JSP Page Directive 82
JSP Elements(5/7) 83
JSP comments 83
JSP Elements(7/7) 85
Possible solution 87
Session Tracking(1/5) 90
Session Tracking(3/5) 92
Session Tracking(4/5) 93
SessionServlet.java 94
Very hot topic right now 95
.NET from Microsoft 95
Web services 95

Komentarze do niniejszej Instrukcji

Brak uwag

Server Technology PPNT Instrukcja Użytkownika Strona 71

Komentarze do niniejszej Instrukcji