JDBC複寫上課程式碼（對岸的女生看過來篇）
這個demo我沒有關閉connection，需要借鑑的朋友注意自己關閉。關於這個demo大家有什麼意見請在下方留言或者私信我，謝謝各位。
程式程式碼如下：
女神類
package com.imooc.pojo;
import java.util.Date;
public class Goddness {
private int id;
private String user_name;
private String sex;
private int age;
private Date birthday;
private String email;
private String mobile;
private String create_user;
private Date create_date;
private String update_user;
private Date update_date;
private int isdel;
public Goddness() {
super();
// TODO Auto-generated constructor stub
}
public Goddness(int id, String user_name, int age, Date birthday,
String mobile) {
super();
this.id = id;
this.user_name = user_name;
this.age = age;
this.birthday = birthday;
this.mobile = mobile;
}
public Goddness( String user_name, String sex, int age,
Date birthday, String email, String mobile, String create_user,
Date create_date, String update_user, Date update_date, int isdel) {
super();
this.user_name = user_name;
this.sex = sex;
this.age = age;
this.birthday = birthday;
this.email = email;
this.mobile = mobile;
this.create_user = create_user;
this.create_date = create_date;
this.update_user = update_user;
this.update_date = update_date;
this.isdel = isdel;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUser_name() {
return user_name;
}
public void setUser_name(String user_name) {
this.user_name = user_name;
}
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;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getMobile() {
return mobile;
}
public void setMobile(String mobile) {
this.mobile = mobile;
}
public String getCreate_user() {
return create_user;
}
public void setCreate_user(String create_user) {
this.create_user = create_user;
}
public Date getCreate_date() {
return create_date;
}
public void setCreate_date(Date create_date) {
this.create_date = create_date;
}
public String getUpdate_user() {
return update_user;
}
public void setUpdate_user(String update_user) {
this.update_user = update_user;
}
public Date getUpdate_date() {
return update_date;
}
public void setUpdate_date(Date update_date) {
this.update_date = update_date;
}
public int getIsdel() {
return isdel;
}
public void setIsdel(int isdel) {
this.isdel = isdel;
}
@Override
public String toString() {
return "Goddness [id=" + id + ", user_name=" + user_name + ", sex="
+ sex + ", age=" + age + ", birthday=" + birthday + ", email="
+ email + ", mobile=" + mobile + ", create_user=" + create_user
+ ", create_date=" + create_date + ", update_user="
+ update_user + ", update_date=" + update_date + ", isdel="
+ isdel + "]";
}
}JDBC工具類
package com.imooc.JDBCUtil;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class JDBCUtil {
private final static String URL = "jdbc:mysql://localhost:3306/imooc?useUnicode=true&characterEncoding=gbk";
private final static String USERNAME = "dengdi";
private final static String PASSWORD = "root";
private static Connection connection = null;
static {
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection() {
return connection;
}
}dao層實現類
package com.imooc.dao;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.imooc.JDBCUtil.JDBCUtil;
import com.imooc.pojo.Goddness;
public class GoddnessDaoImp implements GoddessnDao {
/*
* (non-Javadoc)
*
* @see com.imooc.dao.GoddessnDao#insert(com.imooc.pojo.Goddness)
*/
@Override
public void insert(Goddness god) {
Connection con = JDBCUtil.getConnection();
String sql = "INSERT INTO imooc_goddess(user_name,sex,age,birthday,"
+ "email,mobile,create_user,create_date,"
+ "update_user,update_date,isdel) "
+ "VALUES(?,'女',?,?,?,?,'Administrator',CURRENT_DATE(),'Administrator',CURRENT_DATE(),1)";
PreparedStatement pre = null;
try {
pre = con.prepareStatement(sql);
pre.setString(1, god.getUser_name());
pre.setInt(2, god.getAge());
pre.setDate(3, new Date(god.getBirthday().getTime()));
pre.setString(4, god.getEmail());
pre.setString(5, god.getMobile());
pre.execute();
pre.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/*
* (non-Javadoc)
*
* @see com.imooc.dao.GoddessnDao#delete(int)
*/
@Override
public void delete(int id) {
Connection con = JDBCUtil.getConnection();
String sql = "DELETE FROM imooc_goddess WHERE id=? ";
PreparedStatement pre = null;
try {
pre = con.prepareStatement(sql);
pre.setInt(1, id);
pre.execute();
pre.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/*
* (non-Javadoc)
*
* @see com.imooc.dao.GoddessnDao#update(java.lang.String, int)
*/
@Override
public void update(String user_name, int id) {
Connection con = JDBCUtil.getConnection();
String sql = "UPDATE imooc_goddess SET user_name=? WHERE id=?";
PreparedStatement pre = null;
try {
pre = con.prepareStatement(sql);
pre.setString(1, user_name);
pre.setInt(2, id);
pre.executeUpdate();
pre.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/*
* (non-Javadoc)
*
* @see com.imooc.dao.GoddessnDao#find(int)
*/
@Override
public Goddness find(int id) {
Goddness goddness = null;
Connection con = JDBCUtil.getConnection();
String sql = "SELECT * FROM imooc_goddess WHERE id=?";
PreparedStatement pre = null;
ResultSet rs = null;
try {
pre = con.prepareStatement(sql);
pre.setInt(1, id);
rs = pre.executeQuery();
while (rs.next()) {
goddness = new Goddness(rs.getString("user_name"),
rs.getString("sex"), rs.getInt("age"),
rs.getDate("birthday"), rs.getString("email"),
rs.getString("mobile"), rs.getString("create_user"),
rs.getDate("create_date"), rs.getString("update_user"),
rs.getDate("update_date"), rs.getInt("isdel"));
}
rs.close();
pre.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return goddness;
}
/*
* (non-Javadoc)
*
* @see com.imooc.dao.GoddessnDao#get()
*/
@Override
public List query() {
List list = new ArrayList();
Connection con = JDBCUtil.getConnection();
String sql = "SELECT id,user_name,age,birthday,mobile FROM imooc_goddess";
PreparedStatement pre = null;
ResultSet rs = null;
try {
pre = con.prepareStatement(sql);
rs = pre.executeQuery();
while (rs.next()) {
Goddness goddness = new Goddness(rs.getInt("id"),
rs.getString("user_name"), rs.getInt("age"),
rs.getDate("birthday"), rs.getString("mobile"));
list.add(goddness);
}
rs.close();
pre.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
}
dao介面類
package com.imooc.dao;
import java.util.List;
import com.imooc.pojo.Goddness;
public interface GoddessnDao {
public abstract void insert(Goddness god);
public abstract void delete(int id);
public abstract void update(String user_name, int id);
public abstract Goddness find(int id);
public abstract List query();
} 服務層(也就是action層)實現類
package com.imooc.service;
import java.util.List;
import com.imooc.dao.GoddessnDao;
import com.imooc.dao.GoddnessDaoImp;
import com.imooc.pojo.Goddness;
public class GoddessnServiceImp implements GoddnessService {
private GoddessnDao gd;
public GoddessnServiceImp() {
gd=new GoddnessDaoImp();
}
/* (non-Javadoc)
* @see com.imooc.service.GoddnessService#insert(com.imooc.pojo.Goddness)
*/
@Override
public void insert(Goddness god) {
gd.insert(god);
}
/* (non-Javadoc)
* @see com.imooc.service.GoddnessService#delete(int)
*/
@Override
public void delete(int id) {
gd.delete(id);
}
/* (non-Javadoc)
* @see com.imooc.service.GoddnessService#update(java.lang.String, int)
*/
@Override
public void update(String user_name, int id) {
gd.update(user_name, id);
}
/* (non-Javadoc)
* @see com.imooc.service.GoddnessService#find(int)
*/
@Override
public Goddness find(int id) {
return gd.find(id);
}
/* (non-Javadoc)
* @see com.imooc.service.GoddnessService#get()
*/
@Override
public List query() {
return gd.query();
}
}
服務層介面類
package com.imooc.service;
import java.util.List;
import com.imooc.pojo.Goddness;
public interface GoddnessService {
public abstract void insert(Goddness god);
public abstract void delete(int id);
public abstract void update(String user_name, int id);
public abstract Goddness find(int id);
public abstract List query();
} 檢視層（在後臺輸出的）
package com.imooc.view;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import java.util.Scanner;
import com.imooc.pojo.Goddness;
import com.imooc.service.GoddessnServiceImp;
import com.imooc.service.GoddnessService;
public class GoddnessView {
private static final String CONTEXT = "歡迎來到女神禁區:n" + "下面是女神禁區的功能列表:n"
+ "[MIAN/M]主選單:n" + "[QUERY/Q]檢視全部女神的資訊:n"
+ "[GET/G]檢視某位女神的詳細資訊:n" + "[ADD/A]新增自己心儀的女神:n"
+ "[UPDATE/U]更新女神資訊:n" + "[DELETE/D]刪除女神資訊:n"
+ "[EXIT/E]退出女神禁區:";
private static final String OPERATION_MAIN = "MAIN";
private static final String OPERATION_QUERY = "QUERY";
private static final String OPERATION_GET = "GET";
private static final String OPERATION_ADD = "ADD";
private static final String OPERATION_UPDATE = "UPDATE";
private static final String OPERATION_DELETE = "DELETE";
private static final String OPERATION_SEARCH = "SEARCH";
private static final String OPERATION_EXIT = "EXIT";
public static void main(String[] args) {
System.out.println(CONTEXT);
GoddnessService gs=new GoddessnServiceImp();
Scanner sc = new Scanner(System.in);
String prenious=null;
Goddness goddness=new Goddness();
int step=1;
while (true) {
String in = sc.next();
if (OPERATION_MAIN.equals(in.toUpperCase())
|| OPERATION_MAIN.substring(0, 1).equals(in.toUpperCase())) {
System.out.println(CONTEXT);
}
else if (OPERATION_QUERY.equals(in.toUpperCase())
|| OPERATION_QUERY.substring(0, 1).equals(in.toUpperCase())) {
List list=gs.query();
for (Goddness goddness01 : list) {
System.out.println("ID:"+goddness01.getId());
System.out.println("姓名:"+goddness01.getUser_name());
System.out.println("年齡:"+goddness01.getAge());
System.out.println("生日:"+goddness01.getBirthday());
System.out.println("電話:"+goddness01.getMobile());
}
}
else if(OPERATION_GET.equals(in.toUpperCase())
|| OPERATION_GET.substring(0, 1).equals(in.toUpperCase())
|| OPERATION_GET.equals(prenious)){
prenious=OPERATION_GET;
int id=0;
if(step==1){
System.out.println("請輸入你想要查詢的女神ID:");
}
if(step==2){
id=Integer.valueOf(in);
Goddness g=gs.find(id);
System.out.println(g);
step=0;
prenious=null;
}
step++;
// System.out.println(step);
}
else if(OPERATION_ADD.equals(in.toUpperCase())
|| OPERATION_ADD.substring(0, 1).equals(in.toUpperCase())
|| OPERATION_ADD.equals(prenious)){
prenious=OPERATION_ADD;
if(step==1){
System.out.println("請輸入女神姓名:");
}
if(step==2){
goddness.setUser_name(in);
System.out.println("請輸入女神年齡:");
}
if(step==3){
goddness.setAge(Integer.valueOf(in));
System.out.println("請輸入女神生日(格式為:yyyy-MM-dd):");
}
if(step==4){
Date date=null;
try {
date=new SimpleDateFormat("yyyy-MM-dd").parse(in);
} catch (ParseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
goddness.setBirthday(date);
System.out.println("請輸入女神郵箱:");
}
if(step==5){
goddness.setEmail(in);
System.out.println("請輸入女神電話:");
}
if(step==6){
goddness.setMobile(in);
gs.insert(goddness);
System.out.println("建立女神成功！");
step=0;
prenious=null;
}
step++;
}
else if(OPERATION_UPDATE.equals(in.toUpperCase())
|| OPERATION_UPDATE.substring(0, 1).equals(in.toUpperCase())
|| OPERATION_UPDATE.equals(prenious)){
prenious=OPERATION_UPDATE;
int id=0;
String name;
if(step==1){
System.out.println("請輸入你想要修改的女神ID:");
}
if(step==2){
id=Integer.valueOf(in);
System.out.println("請輸入女神修改的名字:");
}
if(step==3){
name=in;
gs.update(name, id);
System.out.println("更新成功!");
step=0;
prenious=null;
}
step++;
}
else if(OPERATION_DELETE.equals(in.toUpperCase())
|| OPERATION_DELETE.substring(0, 1).equals(in.toUpperCase())
|| OPERATION_DELETE.equals(prenious)){
prenious=OPERATION_DELETE;
int id=0;
if(step==1){
System.out.println("請輸入你想要刪除的女神ID:");
}
if(step==2){
id=Integer.valueOf(in);
gs.delete(id);
System.out.println("刪除成功!");
step=0;
prenious=null;
}
step++;
}
else if (OPERATION_EXIT.equals(in.toUpperCase())
|| OPERATION_EXIT.substring(0, 1).equals(in.toUpperCase())) {
System.out.println("您已經成功退出女神禁區");
break;
}else{
System.out.println("您輸入的值出錯了！");
}
}
}
}
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/4822/viewspace-2807964/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 線上excel轉換成pdf，看過來！Excel
- 第12課：python 程式碼抒寫注意Python
- 看過喜歡的文章不讓複製小技巧及簡化if寫法
- PHP理想國--程式碼怎麼寫看的更舒服PHP
- 看雪線上公開課來襲！《安全編碼之SQL隱碼攻擊》，週日下午14:00SQL
- 用寫程式碼的方式來整理知識
- 通過編寫指令碼和程式來擴充套件SSIS包NZ指令碼套件
- 看promise教你如何優雅的寫js非同步程式碼PromiseJS非同步
- Spring 對JDBC的支援SpringJDBC
- Spring Boot中如何使用JDBC讀取和寫入資料，JDBC和JPA的對比，JdbcTemplate和SimpleJdbcInsert的用法對比Spring BootJDBC
- m序列的生成--閒來無事寫程式碼
- 給程式設計師的10堂寫作課(一)--30+的你，怎能錯過寫作？程式設計師
- PS指令碼篇--1.程式碼是什麼,寫程式碼幹嘛？指令碼
- 如何解決unity做遊戲面臨的重複程式碼過多 程式碼複用性差的問題Unity遊戲
- Mybatis原始碼分析（三）通過例項來看typeHandlersMyBatis原始碼
- [積德篇] 如何少寫PHP “爛”程式碼PHP
- [積德篇] 如何少寫PHP "爛"程式碼PHP
- 感悟篇：如何寫好函式式程式碼函式
- 程式猿，讓我來告訴你怎麼追女生！！！
- [看雪課程]首個體系課重磅上線！《CTF訓練營-Web篇》文末有抽獎哦～Web
- 經常半夜睡醒，爬起來寫程式碼
- 使用pycharm or vscode來編寫python程式碼？PyCharmVSCodePython
- 通過程式碼掛上物理頁
- XSS挑戰之旅（通過看程式碼解題）
- aardio教程五) 寫Python風格的aardio程式碼(字串篇)Python字串
- Amazon Aurora 讀寫能力擴充套件之 ShardingSphere-JDBC 篇套件JDBC
- 用7段程式碼來理解常用的寫作模式模式
- 好程式設計師寫出來的程式碼，就叫好程式碼嗎？你錯了！程式設計師
- 整理課程中將程式碼部署上線（Heroku）的內容
- 降低程式碼的圈複雜度——複雜程式碼的解決之道複雜度
- python基礎課程1（看程式碼看註釋）--基本操作和資料型別Python資料型別
- 每日10行程式碼52：編寫高質量python程式碼方法4——用輔助函式來取代複雜的表示式行程Python函式
- 笑話幾隻，網上看來的
- 雲遊戲，在沒有對岸的風口上架橋遊戲
- 如何寫一篇好的科研課題論文
- Kafka原始碼篇 --- 可能是你看過最詳細的RecordAccumulator解讀Kafka原始碼
- 寫給自己看的Element工程化構建原始碼學習之開篇原始碼
- 程式設計師修煉第一課 | 如何通過改善程式碼風格來消滅隱藏bug程式設計師