?
創(chuàng)建數(shù)據(jù)庫
指定數(shù)據(jù)庫字符集和校對(duì)規(guī)則：
mysql> create database it315 default character set gb2312 collate gb2312_chinese_ci;
?
進(jìn)入剛創(chuàng)建的數(shù)據(jù)庫:
mysql> use it315;
Database changed
?
創(chuàng)建表:
mysql> create table student (id int primary key,name varchar(20),address varchar(20));
?
寫一個(gè)屬性文件: jdbc_mysql.properties,此文件存儲(chǔ)一些連接相關(guān)的信息:
driver=com.mysql.jdbc.Driver???????????? //驅(qū)動(dòng)名稱
url=jdbc:mysql://localhost:3306/it315??? //指定URL
user=root???????????????????????????????????????????????? //用戶名
password=??????????????????????????????????????? //密碼
characterEncoding=gb2312???????????????? //指定字符編碼
?
寫java源文件: JdbcMySql.java
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;
?
public class JdbcMySql {
?
?????? public static Properties getProperties() {
????????????? Properties props = new Properties();
????????????? InputStream is = null;
????????????? try {
???????????????????? is = JdbcMySql.class
?????????????????????????????????? .getResourceAsStream("/jdbc_mysql.properties");
???????????????????? props.load(is);
????????????? } catch (Exception ex) {
???????????????????? ex.printStackTrace();
return null;
????????????? } finally {
???????????????????? if (is != null)
??????????????????????????? try {
?????????????????????????????????? is.close();
??????????????????????????? } catch (IOException e) {
?????????????????????????????????? e.printStackTrace();
??????????????????????????? }
????????????? }
????????????? return props;
?????? }
?
?????? public static void main(String[] args) {
????????????? Connection conn = null;
????????????? Statement stmt = null;
????????????? ResultSet rs = null;
?
????????????? Properties props = getProperties();
????????????? if (props != null){
????????????? ????? //
讀取出屬性文件里面的內(nèi)容
????????????? ????? String driver = props.getProperty("driver");
????????????? ????? String url = props.getProperty("url");
????????????? ?????? String user = props.getProperty("user");
????????????? ????? String password = props.getProperty("password");
????????????? ????? String characterEncoding = props.getProperty("characterEncoding");
?
????????????? ????? try {
???????????????????? ?????? Class.forName(driver);//
加載驅(qū)動(dòng)
?
???????????????????? ?????? conn = DriverManager.getConnection(url + "?characterEncoding="
?????????????????????????????????? ?????? + characterEncoding, user, password);//
建立連接
???????????????????? ?????? stmt = conn.createStatement();
?
???????????????????? ?????? String sql = "insert into student values(1,'
張三','湖南')";
???????????????????? ?????? stmt.executeUpdate(sql);//
執(zhí)行sql語句
?
???????????????????? ?????? sql = "select * from Student";
???????????????????? ?????? rs = stmt.executeQuery(sql);
?
???????????????????? ?????? while (rs.next()) {//
從結(jié)果集中取出數(shù)據(jù)
??????????????????????????? ?????? System.out.print(rs.getInt(1) + "\t");
??????????????????????????? ?????? System.out.print(rs.getString(2) + "\t");
?????? ???????????????????? ?????? System.out.print(rs.getString(3) + "\n");
???????????????????? ?????? }
?
????????????? ?????? } catch (Exception e) {
???????????????????? ?????? e.printStackTrace();
????????????? ?????? } finally {//
釋放連接
???????????????????? ?????? try {
??????????????????????????? ?????? if (rs != null)
?????????????????????????????????? ?????? rs.close();
??????????????????????????? ?????? if (stmt != null)
?????????????????????????????????? ?????? stmt.close();
??????????????????????????? ?????? if (conn != null)
?????????????????????????????????? ?????? conn.close();
???????????????????? ?????? } catch (Exception ex) {
??????????????????????????? ?????? ex.printStackTrace();
???????????????????? ?????? }
????????????? ?????? }
}
?????? }
}
?
編譯運(yùn)行:
C:\ >javac JdbcMySql.java
?
C:\ >java JdbcMySql
1????????????????????????
張三?湖南
?
進(jìn)數(shù)據(jù)庫查詢剛剛插入的信息:
mysql> select * from student;
+----+------+---------+
| id | name | address |
+----+------+---------+
| 1?| ????| ????? |
+----+------+---------+
我們看到中文變成了問號(hào).別急!退出mysql
mysql> quit;
Bye
?
再進(jìn)去:
C:\ >mysql -uroot --default-character-set=gb2312
?
查詢:
mysql> use it315;
Database changed
mysql> select * from student;
+----+--------+---------+
| id | name?? | address |
+----+--------+---------+
| 1?|張三?| 湖南?|
+----+--------+---------+
OK!一切正常了….