java家庭记账代码_Java的家庭记账本程序（B）

package sql.mysql;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import basic.people.Member;

public class MySqlForMembers {

//=======================================================================================【数据区】

//JDBC 驱动名

private final String JDBC_DRIVER = "com.mysql.jdbc.Driver";

//数据库 URL

private final String DB_URL = "jdbc:mysql://localhost:3306/familycash?useSSL=false";

//用户名

private final String USER = "root";

//密码

private final String PASS = "123456";

//构造器

private Connection conn = null;

private Statement stmt = null;

private PreparedStatement pstmt = null;

private ResultSet rs = null;

//=======================================================================================【方法区】

//-------《返回是否存在名称为name的数据》

public boolean exist(String name){

ReSetResult("SELECT name from member");

try {

while(rs.next())

{

String t = rs.getString("name");

if(name.compareTo(t)==0)

return true;

}

} catch (SQLException e) {

System.out.println("爷爷！你的数据库连接出现问题啦！");

}

return false;

}

//-------《返回是否存在型号为n的数据》

public boolean exist(int code){

ReSetResult("SELECT code from member");

try {

while(rs