mysql数据库存储布尔值

灰太狼 2023-10-17 08:44 103阅读 0赞

> 在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

--------------------

![这里写图片描述][20160910104309801]  
![这里写图片描述][20160910104318848]

[20160910104309801]: https://img-blog.csdn.net/20160910104309801
[20160910104318848]: https://img-blog.csdn.net/20160910104318848