操作MySQL



  try {
   Class.forName("com.mysql.jdbc.Driver");

//打开通道
   co = DriverManager.getConnection
     ("jdbc:mysql://localhost:3306/wmcrm?characterEncoding=utf-8","root","zhang");
   ps = con.prepareStatement("MySQL语句");
  } catch (Exception e) {
   
   e.printStackTrace();
  } try {

//关闭通道
    if(rs != null) rs.close();
    if(ps != null) ps.close();
    if(co != null) co.close();
   } catch (SQLException e) {
    
    e.printStackTrace();
   }