DBconn

数据库的连接

public class DBConn {
    public static final String DBDRIVER="com.mysql.jdbc.Driver";
    public static final String DBURL="jdbc:mysql://localhost:3306/pet_shop?useUnicode=true&characterEncoding=UTF-8";
    public static final String DBUSER="root";
    public static final String DBPWD="root";    
       public static Connection getConnection(){
        Connection conn=null;
        try {
   Class.forName("com.mysql.jdbc.Driver");
   conn=DriverManager.getConnection(DBURL,DBUSER ,DBPWD);
  } catch (Exception e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }     
         
        
           return conn;
       }

导入包

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

根据自己的代码编写下面的代码。