import java.sql.*;
public
class
Test
{
public
static
void main(String[] args) throws Exception
{
Class.forName(
"com.mysql.jdbc.Driver"
);
String url =
"jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8"
;
Connection conn = DriverManager.getConnection(url,
"root"
,
"123456"
);
Statement stat = conn.createStatement();
stat.executeUpdate(
"create database hello"
);
stat.close();
conn.close();
url =
"jdbc:mysql://localhost:3306/hello?useUnicode=true&characterEncoding=utf-8"
;
conn = DriverManager.getConnection(url,
"root"
,
"123456"
);
stat = conn.createStatement();
stat.executeUpdate(
"create table test(id int, name varchar(80))"
);
stat.executeUpdate(
"insert into test values(1, '张三')"
);
stat.executeUpdate(
"insert into test values(2, '李四')"
);
ResultSet result = stat.executeQuery(
"select * from test"
);
while
(result.next())
{
System.out.println(result.getInt(
"id"
) +
" "
+ result.getString(
"name"
));
}
result.close();
stat.close();
conn.close();
}
}