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

时间:2021-03-28 15:12:01

1.

 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();
} }

2.

 package mypack;
import java.io.*;
import java.util.*;
import java.sql.*; public class BusinessService{
private String dbUrl ="jdbc:mysql://localhost:3306/SAMPLEDB";
private String dbUser="root";
private String dbPwd="1234"; static{
try{
Class.forName("com.mysql.jdbc.Driver");
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
}catch(Exception e){throw new RuntimeException(e);}
} /** 持久化一个Monkey对象 */
public void saveMonkey(Monkey monkey){
Connection con=null;
try {
//建立数据库连接
con = java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
//创建一个SQL声明
Statement stmt = con.createStatement();
//向MONKEYS表插入记录
stmt.executeUpdate("insert into MONKEYS(NAME,AGE,GENDER) values( "
+"'"+monkey.getName()+"',"
+monkey.getAge()+","
+"'"+monkey.getGender()+"')");
stmt.close();
}catch(Exception e) {
throw new RuntimeException(e);
} finally {
try{
if(con!=null)con.close();
}catch(Exception e){e.printStackTrace();}
}
} }

3.

 package mypack;

 public class Monkey{
private Long id;
private String name;
private int age;
private char gender; public Monkey(){} public Long getId(){
return id;
} private void setId(Long id){
this.id = id;
} public String getName(){
return name;
} public void setName(String name){
this.name=name;
} public int getAge(){
return age;
} public void setAge(int age){
this.age =age ;
} public char getGender(){
return gender;
} public void setGender(char gender){
this.gender =gender ;
}
}

4.

 drop database if exists SAMPLEDB;
create database SAMPLEDB DEFAULT CHARACTER SET utf8;
use SAMPLEDB; create table MONKEYS (
ID bigint not null auto_increment primary key,
NAME varchar(30) not null,
AGE int,
GENDER char(1)
);

5.build.xml

 <?xml version="1.0"?>
<project name="Learning Hibernate" default="prepare" basedir="."> <!-- Set up properties containing important project directories -->
<property name="source.root" value="src"/>
<property name="class.root" value="classes"/>
<property name="lib.dir" value="lib"/> <!-- Set up the class path for compilation and execution -->
<path id="project.class.path">
<!-- Include our own classes, of course -->
<pathelement location="${class.root}" />
<!-- Include jars in the project library directory -->
<fileset dir="${lib.dir}">
<include name="*.jar"/>
</fileset>
</path> <!-- Create our runtime subdirectories and copy resources into them -->
<target name="prepare" description="Sets up build structures">
<delete dir="${class.root}"/>
<mkdir dir="${class.root}"/> <!-- Copy our property files and O/R mappings for use at runtime -->
<copy todir="${class.root}" >
<fileset dir="${source.root}" >
<include name="**/*.properties"/>
<include name="**/*.hbm.xml"/>
<include name="**/*.xml"/>
</fileset>
</copy>
</target> <!-- Compile the java source of the project -->
<target name="compile" depends="prepare"
description="Compiles all Java classes">
<javac srcdir="${source.root}"
destdir="${class.root}"
debug="on"
optimize="off"
deprecation="on">
<classpath refid="project.class.path"/>
</javac>
</target> <target name="rungui" description="Run a Hibernate sample"
depends="compile" >
<java classname="mypack.MonkeyGui" fork="true">
<classpath refid="project.class.path"/>
</java>
</target> </project>

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

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

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();  }   }