Java通过JDBC访问MYSQL示例

/**
 * mysql连接数据库
 * 当然首先得配置好驱动程序，保证程序可以正常操作数据库
 * 驱动程序下载地址： http://mysql.ntu.edu.tw/Downloads/Connector-J/mysql-connector-java-5.0.6.zip
 */
import java.sql.*;
public class Test4 {
 public Connection getConn()
 {
  Connection C=null;
  try {
   Class.forName("org.gjt.mm.mysql.Driver").newInstance();
   C= DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=admin&useUnicode=true&characterEncoding=8859_1");
  } catch (Exception e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return C;
 }
 public static void main(String[] arg)
 {
  Test4 test=new Test4();
  Connection conn=test.getConn();
  try {
   Statement st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
   st.execute("insert into test values(2,'FLB2',25)");
  } catch (Exception e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  finally
  {
   if(conn!=null)
   {
    try {
     conn.close();
    } catch (SQLException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
    }
   }
  }
  System.exit(0);
 }
}