public class Test1 {
@Test
public void test() throws SQLException {
try (Connection conn = DriverManager.getConnection("jdbc:mariadb://localhost/test?characterEncoding=UTF-8", "root", "root")) {
conn.prepareStatement("CREATE TABLE table1 (column1 blob ) DEFAULT CHARSET=utf8").execute();
String str = "\u4f60\u597d(hello in Chinese)";
try {
try (PreparedStatement ps = conn.prepareStatement("insert into table1 values
"))
try (PreparedStatement ps = conn.prepareStatement("select * from table1");
ResultSet rs = ps.executeQuery()) {
while (rs.next())
}
} finally
}
}
}