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() {
  // 加載驅(qū)動(dòng)類
  try {
   Class.forName(driverClass).newInstance();
  } catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) {
   System.out.println("驅(qū)動(dòng)類沒有找到，加載失敗");
   return;
  }
  // 獲得與指定數(shù)據(jù)庫的連接
  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();
   }
  }
 }
}

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