import java.sql.*;public class TestMysql { public static void main(String[] args) throws Exception {
Connection conn = null;
Statement stmt = null;
ResultSet result = null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/?characterEncoding =utf8"; conn = DriverManager.getConnection(url, "root", "root");
stmt = conn.createStatement();
String creatDB = "CREATE DATABASE IF NOT EXISTS mydb DEFAULT CHARACTER SET=utf8";
stmt.execute(creatDB);
String droptable = "DROP TABLE IF EXISTS mydb.t_books";
String creatTable = "CREATE TABLE mydb.t_books(id int unsigned NOT NULL,"
+ "name varchar(50) NOT NULL,isbn varchar(20) NOT NULL,price int unsigned,"
+ "PRIMARY KEY(id)) ENGINE=InnoDB DEFAULT CHARSET utf8";
String inserData1 = "INSERT INTO mydb.t_books(id,name,isbn,price) values (1,'刚回家回家','677687',65)";
String inserData2 = "INSERT INTO mydb.t_books(id,name,isbn,price) values (2,'好','7687',45)";
stmt.execute(droptable);
stmt.execute(creatTable);
stmt.execute(inserData1);
stmt.execute(inserData2);
String select = "SELECT * FROM mydb.t_books";
result = stmt.executeQuery(select);
while (result.next()) {
System.out.print(result.getString("id") + " ");
System.out.print(result.getString("name")+ " ");
System.out.print(result.getString("isbn") + " ");
System.out.println(result.getString("price") + " ");
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if(result != null) {
result.close();
result = null;
}
if(result != null) {
stmt.close();
stmt = null;
}
if(result != null) {
conn.close();
conn = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
} }}
Connection conn = null;
Statement stmt = null;
ResultSet result = null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/?characterEncoding =utf8"; conn = DriverManager.getConnection(url, "root", "root");
stmt = conn.createStatement();
String creatDB = "CREATE DATABASE IF NOT EXISTS mydb DEFAULT CHARACTER SET=utf8";
stmt.execute(creatDB);
String droptable = "DROP TABLE IF EXISTS mydb.t_books";
String creatTable = "CREATE TABLE mydb.t_books(id int unsigned NOT NULL,"
+ "name varchar(50) NOT NULL,isbn varchar(20) NOT NULL,price int unsigned,"
+ "PRIMARY KEY(id)) ENGINE=InnoDB DEFAULT CHARSET utf8";
String inserData1 = "INSERT INTO mydb.t_books(id,name,isbn,price) values (1,'刚回家回家','677687',65)";
String inserData2 = "INSERT INTO mydb.t_books(id,name,isbn,price) values (2,'好','7687',45)";
stmt.execute(droptable);
stmt.execute(creatTable);
stmt.execute(inserData1);
stmt.execute(inserData2);
String select = "SELECT * FROM mydb.t_books";
result = stmt.executeQuery(select);
while (result.next()) {
System.out.print(result.getString("id") + " ");
System.out.print(result.getString("name")+ " ");
System.out.print(result.getString("isbn") + " ");
System.out.println(result.getString("price") + " ");
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if(result != null) {
result.close();
result = null;
}
if(result != null) {
stmt.close();
stmt = null;
}
if(result != null) {
conn.close();
conn = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
} }}
解决方案 »
- 求解答...关于Spring+Ibatis 重点是 如果再使用proxool配置数据源.
- 刚接触jsp,请问使用javabean的问题
- javax.servlet.*这个包,就是含.http***的类的包,java文档里怎么没有说啊?在线等!
- 如何组装数据库中的datetime类型数据?
- tomcat,servlet expert enter
- 在jbuilder里建的项目源码放在了那,
- jsp参数传递的乱马问题
- 我刚装了JDK和Tomcat,有谁能告诉我该怎么用吗?
- win98下可以运行那些jsp server???thinks
- 发布tomcat项目,搞了一个晚上没搞定!!!,急急急
- 如何将调用Webservice返回的图片流存入oracle数据库字段Blob中
- 关于GWT中Window.Location.replace的问题,求教····
String url = "jdbc:mysql://localhost/?characterEncoding=utf8";
改成
String url = "jdbc:mysql://localhost/?useUnicode=true&characterEncoding=utf8";
试试
另外,这是“UTF-8”的官方书写。
并且在创建数据库的时候可以先执行一下set names utf8;
改什么地方的 为什么我改的就不能运行mysql了
怎么改呢
另外,你编码里的utf8全部按官方形式“UTF-8”写,要是还有什么问题,加我Q799229025,这个问题,我前两天刚好遇到过,有经验
我电脑上是,计算机-管理-服务-mysql
在输入show variables like '%char%';这个命令之后,看这个character_set_system的编码,在你的mysql中显示是utf8,所以编码要改“utf8”而不是"UTF-8"。然后按14楼的操作。对此,我深表抱歉。
怪只怪网上乱七八糟的东西,东看看,西看看,结果也不知道对不对就给记住了,回头下来试试才知道不对。