Java JDBC串連數庫簡單 分層操作

標籤：

這個包的只負責實現資料庫的操作

不採取其他動作

 

package com.zhidisoft.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import com.zhidisoft.entity.Dog;

//用來實現資料庫的操作 串連、釋放資料庫 通用的增刪改查
public class DatabaseAction {
Dog dog = new Dog();
Connection conn = null;

// 串連資料庫 張三
public Connection getConnection() {
String url = "jdbc:mysql://localhost:3306/test?"
+ "user=root&password=root&useUnicode=true&characterEncoding=UTF8";
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url);
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
} // 動態載入mysql驅動
return conn;
}

// 向資料庫插入資訊
public int zhuce(Dog dog) {
conn = this.getConnection();
String sql = "insert into dogs () values(" + dog.getNumber() + ",‘" + dog.getName() + "‘,‘" + dog.getSex()
+ "‘," + dog.getAge() + ",‘" + dog.getStrain() + "‘,‘" + dog.getBingqingzhuangtai() + "‘)";
Statement st;
int result = 0;
try {
st = conn.createStatement();
result = st.executeUpdate(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return result;
}

public int delete(int number) {
conn = this.getConnection();
String sql = "delete from dogs where number=" + number + "";
Statement st;
int result = 0;
try {
st = conn.createStatement();
result = st.executeUpdate(sql);
System.out.println(result);
} catch (SQLException e) {
e.printStackTrace();
}
return result;

}

public int genggai(String name, String bingqingzhuangtai) {
conn = this.getConnection();
String sql = "update dogs set bingqingzhuangtai=‘" + bingqingzhuangtai + "‘ where name=‘" + name + "‘";
Statement st;
int result = 0;
try {
st = conn.createStatement();
result = st.executeUpdate(sql);
System.out.println(result);
} catch (SQLException e) {
e.printStackTrace();
}
return result;

}

public void chaxun(String bingqingzhuangtai) throws SQLException {
conn = this.getConnection();
String sql = "select * from dogs where bingqingzhuangtai=‘" + bingqingzhuangtai + "‘";
Statement st;
ResultSet result;
st = conn.createStatement();
result = st.executeQuery(sql);
// System.out.println(result);
while (result.next()) {
System.out.println(result.getInt("number") + "\t" + result.getString("name") + "\t"
+ result.getString("sex") + "\t" + result.getInt("age") + "\t" + result.getString("strain") + "\t"
+ result.getString("bingqingzhuangtai"));
}

}

public void chaxun2(String name) throws SQLException {
conn = this.getConnection();
String sql = "select * from dogs where bingqingzhuangtai=‘" + name + "‘";
Statement st;
ResultSet result;
st = conn.createStatement();
result = st.executeQuery(sql);
while (result.next()) {
System.out.println(result.getInt("number") + "\t" + result.getString("name") + "\t"
+ result.getString("sex") + "\t" + result.getInt("age") + "\t" + result.getString("strain") + "\t"
+ result.getString("bingqingzhuangtai"));
}

}
}

 

這個包則是用來存放資料的屬性的包

例如這個動物Dogs類的屬性

 

package com.zhidisoft.entity;

public class Dog {
private int number;
private String name;
private String sex;
private int age;
private String strain;
private String bingqingzhuangtai;

public String getBingqingzhuangtai() {
return bingqingzhuangtai;
}

public int getNumber() {
return number;
}

public void setNumber(int number) {
this.number = number;
}

public void setBingqingzhuangtai(String bingqingzhuangtai) {
this.bingqingzhuangtai = bingqingzhuangtai;
}

public String getName() {
return name;
}

public void setName(String name) {
this.name = name;
}

public String getStrain() {
return strain;
}

public void setStrain(String strain) {
this.strain = strain;
}

public String getSex() {
return sex;
}

public void setSex(String sex) {
this.sex = sex;
}

public int getAge() {
return age;
}

public void setAge(int age) {
this.age = age;
}

}

 

還有一個包則是為了處理商務邏輯的包，此包不參與其他的事項

只是處理商務邏輯

package com.zhidisoft.UI;

import java.sql.SQLException;
import java.util.Scanner;
import com.zhidisoft.dao.DatabaseAction;
import com.zhidisoft.entity.Dog;

public class Test {
public static void main(String[] args) throws SQLException {
DatabaseAction dz=new DatabaseAction();
Dog dog=new Dog();
//專註於商務邏輯
System.out.println("歡迎來到寵物醫院，請選擇操作：1.註冊 2.刪除 3.更改資訊 4.根據病例資訊查詢 5.根據寵物名查詢資訊");
Scanner input=new Scanner(System.in);
String choice=input.next();
if(choice.equals("1")){
//進行註冊操作
//收集資料 調用資料庫的插入方法實現註冊
System.out.println("輸入寵物編號：");
dog.setNumber(Integer.parseInt(input.next()));
System.out.println("輸入寵物的名字：");
dog.setName(input.next());
System.out.println("輸入寵物的性別：");
dog.setSex(input.next());
System.out.println("輸入寵物的年齡：");
dog.setAge(Integer.parseInt(input.next()));
System.out.println("輸入寵物品種：");
dog.setStrain(input.next());
System.out.println("寵物的癥狀：");
dog.setBingqingzhuangtai(input.next());
//調用dao層的代碼實現資料的插入
dz.zhuce(dog);
}

if(choice.equals("2")){
System.out.println("輸入將要刪除的寵物編號：");
dog.setNumber(Integer.parseInt(input.next()));
dz.delete(dog.getNumber());
}

if (choice.equals("3")) {
System.out.println("輸入將要更改的寵物姓名：");
dog.setName(input.next());
System.out.println("請輸入要更改的病理狀態");
dog.setBingqingzhuangtai((input.next()));
dz.genggai(dog.getName(), dog.getBingqingzhuangtai());
}

if (choice.equals("4")) {
System.out.println("請輸入要查詢的病理狀態");
dog.setBingqingzhuangtai((input.next()));
dz.chaxun(dog.getBingqingzhuangtai());
}

if (choice.equals("5")) {
System.out.println("請輸入要查詢的寵物名稱");
dog.setName((input.next()));
dz.chaxun2(dog.getName());
}
////李四調用張三的代碼
//Connection conn=dz.getConnection();
}
}

這隻是一個初步的分層作業的雛形 ，這樣做有利於高效率的完成項目

 

Java JDBC串連數庫簡單 分層操作