java基于jdbc对mysql数据库进行增删改查登陆注册的完整示例代码。新手入门代码,不足之处请评论指出。
用的是Scanner在控制面板输入参数和返回参数。
1、创建Java Project项目
2、导入Jar包
mysql-connector-java-5.0.8-bin.jar
3、创建数据库
//根据实体类创建数据库字段和类型
4、创建实体类(BankModel.java)
package com.model;
public class BankModel {
private int id;
private String users;
private String money;
private String telephone;
private int cardno;
private String address;
private String remark;
private int isok;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsers() {
return users;
}
public void setUsers(String users) {
this.users = users;
}
public String getMoney() {
return money;
}
public void setMoney(String money) {
this.money = money;
}
public String getTelephone() {
return telephone;
}
public void setTelephone(String telephone) {
this.telephone = telephone;
}
public int getCardno() {
return cardno;
}
public void setCardno(int cardno) {
this.cardno = cardno;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getRemark() {
return remark;
}
public void setRemark(String remark) {
this.remark = remark;
}
public int getIsok() {
return isok;
}
public void setIsok(int isok) {
this.isok = isok;
}
}
5、创建数据库驱动类(DBUtil.java)
package com.dbutil;
import java.sql.Connection;
import java.sql.DriverManager;
public class DBUtil {
public static Connection getConnection() {
Connection conn=null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/heizhu?useSSL=false","root","1234");
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
}
6、创建数据库操作类(BankDao.java)
package com.dao;
import java.sql.Connection;
import java.sql.PreparedSta