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();
}