JDBC链接MySQL

package JDBCDEMO;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;




public class JdbcDemo {


/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
      try {
     /**
      * 创建一个映射
      */
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
      
     try {
Connection conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/mytest?useUnicode=true&characterEncoding=utf8","root","root");
Statement ste = conn.createStatement();
ste.executeUpdate("insert into userinfo values(3,'按时','asd')");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
     
     try {
  Connection conn2 = DriverManager.getConnection(
  "jdbc:mysql://localhost:3306/mytest?useUnicode=true&characterEncoding=utf8","root","root");
  Statement ste2 = conn2.createStatement();
 
      ResultSet rt = ste2.executeQuery("select * from userinfo");
      while(rt.next())
      {
        System.out.println("id = " + rt.getInt(1) + "sex = " + rt.getString(2));
      }
  } catch (SQLException e) {
 
  // TODO Auto-generated catch block
  e.printStackTrace();
  }
  
}


}