MySQL中的布尔值,怎么存储false或true
MySQL布尔值,存储false或true
简明说，数据库存储的布尔值是0和1，相当于一个字节的INT型整数
具体操作如果是可视化界面，可以直接选择Boolean，长度设置为1。其最终显示的效果等价于TINYINT(1)
所以，zero == false；nonzero == true
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
以上为个人经验，希望能给大家一个参考，也希望大家多多支持软件开发网。
相关文章
Katherine
2020-07-31
Talia
2021-04-07
Dara
2021-07-23
Olathe
2023-07-20
Talia
2023-07-20
Serafina
2023-07-20
Hazel
2023-07-20
Ebony
2023-07-20
Olga
2023-07-20
Elizabeth
2023-07-20
Ianthe
2023-07-20
Valora
2023-07-20
Phemia
2023-07-20
Tia
2023-07-20
Summer
2023-07-20
Fredrica
2023-07-20
Maha
2023-07-21
Edie
2023-07-21
Bonnie
2023-07-21