PowerPoint プレゼンテーション

Size: px

Start display at page:

Download "PowerPoint プレゼンテーション"

せぴあにばし
4 years ago
Views:

1 1

2 2

3 3

4 4

5 HTML 5

6 HTML 6

7 7

8 8

9 9 ( )

10 10

11 11 ( )

12 Switch(state) case STATE_xxxx : int op_state = opponent.getstate(); switch (op_state) { case STATE_yyyy : < > player.setstate(state_zzzz); 12

13 13

14 14

15 15

16 16

17 17

18 request name password String PlayerName = request. getparameter( yourname"); <input type="text" name="yourname"><br><br> <input type="password" name="password"> <input type="hidden" name="operation" value="registrate"> 18

19 String operation = request. getparameter("operation"); <input type="text" name="yourname"><br><br> <input type="password" name="password"> <input type="hidden" name="operation" value="registrate"> 19

20 request.setattribute("player_name",game.getplayer().getname()); <% String player = (String)request.getAttribute( "player_name"); %> <%= player %> 20

21 <head> <meta http-equiv="refresh" content="20"> <title> </title> </head> 21

22 next_operation: player_name: opponent_name: my_bingocard: op_bingocard: records: next_operation win think wait_fig loose draw 22

23 ( )

24 request String figure = (String)request.getPara meter("figure"); <select name="figure"> <option value= 1">1 <option value= 2">2 <option value= 3">3 <option value= 4">4 <option value= 5">5 </select> <select name="figure"> <% for(int i=0;i< gameorder[0];i++){%> <option value="<%= i+1 %>"> <%= i+1 %> <% }%> </select> 24

25 init() bingocontrol implement HttpServlet doget(request, response) 25

26 bingo Control 26

27 bingo Control 27

28 28

29 private String name; private String password; private bingoplayer opponent; private int state; STATE_NULL private String figure; private int gameorder; private String bingocard; private String gamerecords; private int playerid; 29

30 tomcat tomcat bingo bingo Control Control 30

31 31 bingo Control bingo Player <bingoplayers newplayer bingo Control bingo Player <bingoplayers invalidate

32 bingo Control bingo bingogame Player 32

33 33

34 34 < Players > < games >

35 JAVA 35

36 create table players (player_id serial primary key, name varchar(64) not null, passwd varchar(64) not null unique); create table games (game_id serial primary key, date date, winner integer not null references players, looser integer not null references players, draw boolean not null); 36

37 37

38 private static Connection conn; void init() void initdb( URL ) { : Class.forName(dbDriver); conn = DriverManager.getConnection( URL ); 38

39 int getplayerid(...) int insertgamerecord(...) String getgamerecord(...) 39

40 String selectsql = "select player_id from players where name='" +name+"' and passwd='"+password+"'"; Statement stmt = conn.createstatement(); ResultSet rslt = stmt.executequery(selectsql); if(rslt.next()){ int playerid = rslt.getint(1); 40

41 select, join, etc. 41

43 43

44 _.gifu-keizai.ac.jp /tom_yyy /servlet/bingo 44

45 web.xml /tom_yyy /servlet/bingo 45

46 web.xml 46

47 47

48 48

49 cd ~yyy/tomcat/web-inf/classes/bingo javac Bingo/bingoControl.java 49

50 50

51 51

52 logger.fine( #D# "); var log tomcat4 bingo_yyy_log0.log (yyy ) cd /var/log/tomcat4 less bingo_yyy0.log 52

53 java.util.logging.logger logger.fine ( #D# "); import java.util.logging.logger; import java.util.logging.level; import java.util.logging.logmanager; 53

54 LogManager.getLogManager().readConfigurat ion(inputstream); 54

55 55

tkk0408nari

tkk0408nari SQLStatement Class Sql Database SQL Structured Query Language( ) ISO JIS http://www.techscore.com/tech/sql/02_02.html Database sql Perl Java SQL ( ) create table tu_data ( id integer not null, -- id aid