Hibernate逍遥游记-第1章-JDBC访问数据库

1.

 1 package mypack;
 2 
 3 import java.awt.*;
 4 import java.awt.event.*;
 5 import javax.swing.*;
 6 import javax.swing.table.*;
 7 import java.util.*;
 8 
 9 public class MonkeyGui implements ActionListener{
10   private BusinessService businessService=new BusinessService();
11 
12   //界面的主要窗体组件
13   protected JFrame frame;
14   protected Container contentPane;
15 
16   //主面板上的组件
17   protected JPanel custPan=new JPanel();
18   protected JLabel nameLb=new JLabel("猴子姓名");
19   protected JLabel genderLb=new JLabel("性别");
20   protected JLabel ageLb=new JLabel("年龄");
21   protected JLabel logLb=new JLabel("");
22 
23   protected JTextField nameTf=new JTextField(25);
24   protected JTextField genderTf=new JTextField(25);
25   protected JTextField ageTf=new JTextField(25);
26   protected JButton addBt=new JButton("保存");
27 
28   
29   /** 构造方法 */
30   public MonkeyGui(){
31     buildDisplay();
32   }
33   
34   /** 创建图形界面 */
35   private void buildDisplay(){
36    frame=new JFrame("花果山信息管理系统");
37    buildCustPanel();
38       
39    //向主窗体中加入custPan面板
40    contentPane=frame.getContentPane();
41    contentPane.setLayout(new BorderLayout());
42    contentPane.add(custPan,BorderLayout.CENTER);
43  
44    frame.pack();
45    frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
46    frame.setVisible(true);
47 
48   }
49  
50   
51   /**　创建custPan面板 */
52   private void buildCustPanel(){
53    custPan.setLayout(new GridLayout(4,2,5,5));
54    custPan.add(nameLb);
55    custPan.add(nameTf);
56    custPan.add(genderLb);
57    custPan.add(genderTf);
58    custPan.add(ageLb);
59    custPan.add(ageTf);
60 
61    custPan.add(addBt);
62    custPan.add(logLb);
63  
64    addBt.addActionListener(this);
65 
66   }
67   
68   public void actionPerformed(ActionEvent event){
69     try{
70       Monkey monkey=new Monkey();
71       monkey.setName(nameTf.getText().trim());
72       monkey.setAge(Integer.parseInt(ageTf.getText().trim()));
73       monkey.setGender(genderTf.getText().trim().charAt(0));
74       businessService.saveMonkey(monkey);  
75       logLb.setText("猴子信息已经保存成功。");
76     }catch(Exception e){
77       logLb.setText("猴子信息保存失败。");
78       e.printStackTrace();
79     }
80     
81   }
82  
83   public static void main(String args[]){
84     new MonkeyGui();
85   } 
86   
87 }

 

2.

 1 package mypack;
 2 import java.io.*;
 3 import java.util.*;
 4 import java.sql.*;
 5 
 6 public class BusinessService{
 7   private String dbUrl ="jdbc:mysql://localhost:3306/SAMPLEDB";
 8   private String dbUser="root";
 9   private String dbPwd="1234";
10   
11   static{
12     try{ 
13       Class.forName("com.mysql.jdbc.Driver");
14       DriverManager.registerDriver(new com.mysql.jdbc.Driver()); 
15     }catch(Exception e){throw new RuntimeException(e);}
16   }
17 
18   /** 持久化一个Monkey对象 */
19   public void saveMonkey(Monkey monkey){
20     Connection con=null;
21     try {
22       //建立数据库连接
23       con = java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
24       //创建一个SQL声明
25       Statement stmt = con.createStatement();
26       //向MONKEYS表插入记录
27       stmt.executeUpdate("insert into MONKEYS(NAME,AGE,GENDER) values( "
28          +"'"+monkey.getName()+"',"
29          +monkey.getAge()+","
30          +"'"+monkey.getGender()+"')");
31       stmt.close();
32     }catch(Exception e) {
33       throw new  RuntimeException(e);
34     } finally {
35       try{
36         if(con!=null)con.close();
37       }catch(Exception e){e.printStackTrace();}  
38     }
39   }
40 
41 }

 

3.

 1 package mypack;
 2 
 3 public class Monkey{
 4   private Long id;
 5   private String name;
 6   private int age;
 7   private char gender;
 8 
 9   public Monkey(){}
10 
11   public Long getId(){
12     return id;
13   }
14 
15   private void setId(Long id){
16     this.id = id;
17   }
18 
19   public String getName(){
20     return name;
21   }
22 
23   public void setName(String name){
24     this.name=name;
25   }
26 
27   public int getAge(){
28     return age;
29   }
30 
31   public void setAge(int age){
32     this.age =age ;
33   }
34 
35   public char getGender(){
36     return gender;
37   }
38 
39   public void setGender(char gender){
40     this.gender =gender ;
41   }
42 }

 

4.

 1 drop database if exists SAMPLEDB;
 2 create database SAMPLEDB DEFAULT CHARACTER SET utf8;
 3 use SAMPLEDB;
 4 
 5 create table MONKEYS (
 6   ID bigint not null auto_increment primary key,
 7   NAME varchar(30) not null,
 8   AGE int,  
 9   GENDER char(1) 
10 );

 

5.build.xml

 1 <?xml version="1.0"?>
 2 <project name="Learning Hibernate" default="prepare" basedir=".">
 3 
 4   <!-- Set up properties containing important project directories -->
 5   <property name="source.root" value="src"/>
 6   <property name="class.root" value="classes"/>
 7   <property name="lib.dir" value="lib"/>
 8 
 9   <!-- Set up the class path for compilation and execution -->
10   <path id="project.class.path">
11       <!-- Include our own classes, of course -->
12       <pathelement location="${class.root}" />
13       <!-- Include jars in the project library directory -->
14       <fileset dir="${lib.dir}">
15         <include name="*.jar"/>
16       </fileset>
17   </path>
18  
19   <!-- Create our runtime subdirectories and copy resources into them -->
20   <target name="prepare" description="Sets up build structures">
21     <delete dir="${class.root}"/>
22     <mkdir dir="${class.root}"/>
23 
24     <!-- Copy our property files and O/R mappings for use at runtime -->
25     <copy todir="${class.root}" >
26       <fileset dir="${source.root}" >
27         <include name="**/*.properties"/>
28         <include name="**/*.hbm.xml"/>
29         <include name="**/*.xml"/>
30       </fileset>
31     </copy>
32   </target>
33 
34   <!-- Compile the java source of the project -->
35   <target name="compile" depends="prepare"
36           description="Compiles all Java classes">
37     <javac srcdir="${source.root}"
38            destdir="${class.root}"
39            debug="on"
40            optimize="off"
41            deprecation="on">
42       <classpath refid="project.class.path"/>
43     </javac>
44   </target>
45 
46 
47   <target name="rungui" description="Run a Hibernate sample"
48     depends="compile" >
49     <java classname="mypack.MonkeyGui" fork="true">
50        <classpath refid="project.class.path"/>
51     </java>
52   </target>
53 
54 </project>

 

6.在命令行中输入 ant rungui,会编译代码后运行MonkeyGui类的main()方法

7.

 

package mypack;
import java.awt.*;import java.awt.event.*;import javax.swing.*;import javax.swing.table.*;import java.util.*;
public class MonkeyGui implements ActionListener{  private BusinessService businessService=new BusinessService();
  //界面的主要窗体组件  protected JFrame frame;  protected Container contentPane;
  //主面板上的组件  protected JPanel custPan=new JPanel();  protected JLabel nameLb=new JLabel("猴子姓名");  protected JLabel genderLb=new JLabel("性别");  protected JLabel ageLb=new JLabel("年龄");  protected JLabel logLb=new JLabel("");
  protected JTextField nameTf=new JTextField(25);  protected JTextField genderTf=new JTextField(25);  protected JTextField ageTf=new JTextField(25);  protected JButton addBt=new JButton("保存");
    /** 构造方法 */  public MonkeyGui(){    buildDisplay();  }    /** 创建图形界面 */  private void buildDisplay(){   frame=new JFrame("花果山信息管理系统");   buildCustPanel();         //向主窗体中加入custPan面板   contentPane=frame.getContentPane();   contentPane.setLayout(new BorderLayout());   contentPane.add(custPan,BorderLayout.CENTER);    frame.pack();   frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);   frame.setVisible(true);
  }     /**　创建custPan面板 */  private void buildCustPanel(){   custPan.setLayout(new GridLayout(4,2,5,5));   custPan.add(nameLb);   custPan.add(nameTf);   custPan.add(genderLb);   custPan.add(genderTf);   custPan.add(ageLb);   custPan.add(ageTf);
   custPan.add(addBt);   custPan.add(logLb);    addBt.addActionListener(this);
  }    public void actionPerformed(ActionEvent event){    try{      Monkey monkey=new Monkey();      monkey.setName(nameTf.getText().trim());      monkey.setAge(Integer.parseInt(ageTf.getText().trim()));      monkey.setGender(genderTf.getText().trim().charAt(0));      businessService.saveMonkey(monkey);        logLb.setText("猴子信息已经保存成功。");    }catch(Exception e){      logLb.setText("猴子信息保存失败。");      e.printStackTrace();    }      }   public static void main(String args[]){    new MonkeyGui();  }   }

 

转载于:https://www.cnblogs.com/shamgod/p/5296096.html