mysql数据库存储布尔值

在Java编程中，我们经常会遇到将boolean值写入到mysql数据库的情况。但是，mysql数据库是没有boolean类型的，它的boolean值是用数字0和1来表示的。下面，我们用Java演示一下怎样将boolean值保存到mysql数据库。

---

package database;

import java.sql.PreparedStatement;
import java.sql.SQLException;
import com.qs.database.DBConnection;

public class JavaMysqlBoolean {
	
	public static void main(String[] args) {
		if(DBConnection.conn==null){
			DBConnection.openConn();
		}
		PreparedStatement ps = null;
		try {
			String sql = "insert into testboolean(name,password,isAdult) values(?,?,?)";
			ps = DBConnection.conn.prepareStatement(sql);
			
			ps.setString(1, "lisi");
			ps.setString(2, "1");
			ps.setBoolean(3, false);
			
			ps.executeUpdate();
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}

---

package com.qs.database;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class DBConnection {
	public static Connection conn = null;
	public static String driverClass = "";
	public static String dbURL = "";
	public static String dbUser = "";
	public static String dbPwd = "";

	static {
		loadProperty();
	}

	// 读取配置文件
	public static boolean loadProperty() {
		Properties properties = new Properties();
		try {
			properties.load(DBConnection.class.getResourceAsStream("db.properties"));
			driverClass = properties.getProperty("drivername");
			dbURL = properties.getProperty("dburl");
			dbUser = properties.getProperty("username");
			dbPwd = properties.getProperty("password");
		} catch (IOException e) {
			System.out.println("读取配置文件失败");
			e.printStackTrace();
			return false;
		}
		return true;
	}

	public static void openConn() {
		// 加载驱动类
		try {
			Class.forName(driverClass).newInstance();
		} catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) {
			System.out.println("驱动类没有找到，加载失败");
			return;
		}
		// 获得与指定数据库的连接
		try {
			conn = DriverManager.getConnection(dbURL, dbUser, dbPwd);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public void closeConn() {
		if (conn != null) {
			try {
				conn.close();
				conn = null;
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}

---

属性文件db.properties

drivername=org.gjt.mm.mysql.Driver
dburl=jdbc:mysql://localhost:3306/mydatabase?useUnicode=true&characterEncoding=utf-8
username=root
password=root

---