JAVA實(shí)驗(yàn)報(bào)告-數(shù)據(jù)庫(kù)編程.docx

JAVA實(shí)驗(yàn)報(bào)告班級(jí)：GOT7姓名： 鳥(niǎo)寶寶 學(xué)號(hào)：i got7指導(dǎo)老師：魯鳴鳴實(shí)驗(yàn)三 數(shù)據(jù)庫(kù)絡(luò)編程一、實(shí)驗(yàn)?zāi)康?1. 了解和掌握J(rèn)ava基本概念和語(yǔ)法2了解和掌握J(rèn)ava圖形界面編程的基本概念和用法 3. 了解和掌握J(rèn)ava事件編程的基本概念和用法4. 了解和掌握J(rèn)ava IO基本功能和用法5. 了解和掌握J(rèn)ava 數(shù)據(jù)庫(kù)編程基本功能和用法 二、實(shí)驗(yàn)開(kāi)發(fā)環(huán)境和工具可以在Linux或者Windows操作系統(tǒng)上搭建開(kāi)發(fā)環(huán)境，可使用集成開(kāi)發(fā)環(huán)境Eclipse，使用Java語(yǔ)言，工具包使用JDK1.6、1.7或1.8。三、實(shí)驗(yàn)內(nèi)容 在實(shí)驗(yàn)一、二的基礎(chǔ)上，拓展所實(shí)現(xiàn)的小軟件，增加與數(shù)據(jù)庫(kù)通信的功能。要就能有查詢(xún)、增加、刪除、更新數(shù)據(jù)的功能。4 實(shí)驗(yàn)過(guò)程 要實(shí)現(xiàn)JAVA程序和數(shù)據(jù)庫(kù)的通信，首先要熟悉數(shù)據(jù)庫(kù)，MySQL的基本語(yǔ)法，例如建立數(shù)據(jù)庫(kù)，創(chuàng)建修改查詢(xún)刪除表的操作，這些都清楚以后再來(lái)實(shí)現(xiàn)JAVA和數(shù)據(jù)庫(kù)的連接，讓JAVA程序去做上述事情，最后實(shí)現(xiàn)他們之間的相互響應(yīng)，達(dá)到通信的目的。5 程序清單/服務(wù)器端代碼package zjq;import .*;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.io.*;public class MyServer public static void main(String args) try /服務(wù)器在8000端口監(jiān)聽(tīng) ServerSocket ss = new ServerSocket(8000) ; System.out.println(服務(wù)器正在8000端口監(jiān)聽(tīng).) ; Socket s = ss.accept() ; /接受用戶(hù)名和密碼 InputStream is = s.getInputStream() ; InputStreamReader isr = new InputStreamReader(is) ; BufferedReader br = new BufferedReader(isr) ; String uandpandc = br.readLine();/檢驗(yàn)點(diǎn)System.out.println(uandpandc);String u = ;String p = ;String c = ;tryu = uandpandc.split(%)0;p = uandpandc.split(%)1;c = uandpandc.split(%)2;catch(Exception ee)OutputStream os = s.getOutputStream();OutputStreamWriter osw = new OutputStreamWriter(os);PrintWriter pw = new PrintWriter(osw, true);Class.forName(org.gjt.mm.mysql.Driver);Connection cn = DriverManager.getConnection(jdbc:mysql:/:3306/user,root,951003);PreparedStatement ps = cn.prepareStatement(select *from users where username =? and password =?);ps.setString(1, u);ps.setString(2, p);ResultSet rs = ps.executeQuery();switch(c)case login:if(rs.next()/發(fā)送正確信息到客戶(hù)端pw.println(ok);else/發(fā)送錯(cuò)誤信息到客戶(hù)端pw.println(err); break;caseregister:if(rs.next()/發(fā)送正確信息到客戶(hù)端pw.println(ok);elsepw.println(err);PreparedStatement ps2 = cn.prepareStatement(insert into users values(?,?,?);ps2.setString(1, u);ps2.setString(2, p);ps2.setString(3, 0);ps2.executeUpdate();break;case delete:if(rs.next()/發(fā)送正確信息到客戶(hù)端pw.println(ok);PreparedStatement ps3 = cn.prepareStatement(delete from users where username = ?);ps3.setString(1, u);ps3.executeUpdate();elsepw.println(err);break; catch(Exception e) /登陸界面代碼package zjq;import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.io.* ;import .* ;public class login extends JFrame implements ActionListener JTextField txtUser = new JTextField() ;JPasswordField txtPass = new JPasswordField();public login() this.setSize(250 , 125) ;/new組件JLabel labUser = new JLabel(用戶(hù)名) ;JLabel labPass = new JLabel(密碼) ;JButton btnLogin = new JButton(登陸) ;JButton btnReg = new JButton(注冊(cè)) ;JButton btnCancel = new JButton(注銷(xiāo)) ;/注冊(cè)事件監(jiān)聽(tīng)btnLogin.addActionListener(this) ;btnReg.addActionListener(this) ;btnCancel.addActionListener(this) ;/布置輸入面板JPanel panInput = new JPanel() ;panInput.setLayout(new GridLayout(2 , 2) ;panInput.add(labUser) ;panInput.add(txtUser) ;panInput.add(labPass) ;panInput.add(txtPass) ; /布置按鈕面板 JPanel panButton = new JPanel() ; panButton.setLayout(new FlowLayout() ; panButton.add(btnLogin) ; panButton.add(btnReg) ; panButton.add(btnCancel) ;/布置窗體 this.setLayout(new BorderLayout() ; this.add(panInput , BorderLayout.CENTER) ; this.add(panButton , BorderLayout.SOUTH) ; public static void main(String args) login w = new login() ; w.setVisible(true) ; public void actionPerformed(ActionEvent arg0) switch(arg0.getActionCommand()case 登錄:try/發(fā)送用戶(hù)名和密碼到服務(wù)器端String user = txtUser.getText();String pass = txtPass.getText();String com = login;Socket s = new Socket(localhost,8000);OutputStream os = s.getOutputStream();OutputStreamWriter osw = new OutputStreamWriter(os);PrintWriter pw = new PrintWriter(osw, true);pw.println(user+%+pass+%+com);/接收服務(wù)器發(fā)送回來(lái)的確認(rèn)信息InputStream is = s.getInputStream();InputStreamReader isr = new InputStreamReader(is);BufferedReader br = new BufferedReader(isr);String yorn = br.readLine();/顯示主窗體if(yorn.equals(ok)zjt m=new zjt(); m.setVisible(true); this.setVisible(false); elseJOptionPane.showMessageDialog(null, 用戶(hù)名或密碼出錯(cuò), 登錄失敗 , JOptionPane.ERROR_MESSAGE);catch(Exception e)e.printStackTrace() ; break;case 注冊(cè):try/發(fā)送用戶(hù)名和密碼到服務(wù)器端String user = txtUser.getText();String pass = txtPass.getText();String com = register;Socket s = new Socket(localhost,8000);OutputStream os = s.getOutputStream();OutputStreamWriter osw = new OutputStreamWriter(os);PrintWriter pw = new PrintWriter(osw, true);pw.println(user+%+pass+%+com);/接收服務(wù)器發(fā)送回來(lái)的確認(rèn)信息InputStream is = s.getInputStream();InputStreamReader isr = new InputStreamReader(is);BufferedReader br = new BufferedReader(isr);String yorn = br.readLine();/顯示主窗體if(yorn.equals(ok)JOptionPane.showMessageDialog(null, 用戶(hù)已經(jīng)注冊(cè)！, 失敗 , JOptionPane.ERROR_MESSAGE);elseJOptionPane.showMessageDialog(null, 用戶(hù)注冊(cè)成功！, 成功 , JOptionPane.ERROR_MESSAGE);catch(Exception e1)e1.printStackTrace() ;break;case 注銷(xiāo):try/發(fā)送用戶(hù)名和密碼到服務(wù)器端String user = txtUser.getText();String pass = txtPass.getText();String com = delete;Socket s = new Socket(localhost,8000);OutputStream os = s.getOutputStream();OutputStreamWriter osw = new OutputStreamWriter(os);PrintWriter pw = new PrintWriter(osw, true);pw.println(user+%+pass+%+com);/接收服務(wù)器發(fā)送回來(lái)的確認(rèn)信息InputStream is = s.getInputStream();InputStreamReader isr = new InputStreamReader(is);BufferedReader br = new BufferedReader(isr);String yorn = br.readLine();/顯示主窗體if(yorn.equals(ok)JOptionPane.showMessageDialog(null, 該用戶(hù)已注銷(xiāo)！, 注銷(xiāo)成功 , JOptionPane.ERROR_MESSAGE);elseJOptionPane.showMessageDialog(null, 該用戶(hù)不存在, 注銷(xiāo)失敗 , JOptionPane.ERROR_MESSAGE);catch(Exception e1)e1.printStackTrace() ;break;default:break;/游戲界面代碼package zjq;import java.awt.BorderLayout;import java.awt.Color;import java.awt.Container;import java.awt.FlowLayout;import java.awt.Graphics;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.awt.event.MouseAdapter;import java.awt.event.MouseEvent;import .Socket;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;public class zjt extends JFrame int x = 0, y = 0;int a = 0;int x1 = 0, y1 = 0, x2 = 0, y2 = 0, x3 = 0, y3 = 0, x4 = 0, y4 = 0;boolean fa = true, huatu = true, yin = false; int a1 = 0, a2 = 0, a3 = 0, a4 = 0, a5 = 0, a6 = 0, a7 = 0, a8 = 0, a9 = 0; int s = new int10, jj = new int10; JButton congxin, huanse; JLabel jl; public zjt() Container c = getContentPane(); c.setLayout(new FlowLayout(); congxin = new JButton(紅隊(duì)先下); c.add(congxin); huanse = new JButton(藍(lán)隊(duì)先下); c.add(huanse); jl = new JLabel(); c.add(jl, BorderLayout.SOUTH); addMouseListener(new MouseAdapter() public void mousePressed(MouseEvent event) if (event.isAltDown() repaint(); x = event.getPoint().x; y = event.getPoint().y; int a = mm(x, y); if (yin) jl.setForeground(Color.RED); jl .setText(游戲已結(jié)束,請(qǐng)重新開(kāi)始); else if (sa = 1) jl.setForeground(Color.RED); jl.setText( 此位置有棋子,請(qǐng)另選位置重新下棋 ); else fa = false; if (a = 1) a1 = 1; if (a = 2) a2 = 1; if (a = 3) a3 = 1; if (a = 4) a4 = 1; if (a = 5) a5 = 1; if (a = 6) a6 = 1; if (a = 7) a7 = 1; if (a = 8) a8 = 1; if (a = 9) a9 = 1; jl.setText(); repaint(); sa = 1; );congxin.addActionListener(new ActionListener() public void actionPerformed(ActionEvent arg0) for (int i = 0; i s.length; i+) si = 0; jji = 0; fa = true; repaint(); yin = false; huatu = true; jl.setForeground(Color.black); jl.setText(紅隊(duì)先下); ); huanse.addAction