java 之连接mysql数据库

1：新建类：
完成对数据库的连接，并通过返回Connection。
在此之前要记得导入对MySQL数据库的驱动（jar包）。网上一搜很多。

import java.sql.DriverManager;
import java.sql.SQLException;

import com.mysql.jdbc.Connection;

public class MyConnection {
    private static Connection connection;
    public MyConnection() {
        // TODO Auto-generated constructor stub
    }
    public static Connection getConnection(){
        String urlString = "jdbc:mysql://localhost:3306/shcoolapp?user=root&password=ffffff&useUnicode=true&characterEncoding=gbk";
        //String usernameString = "root";
        //String pd = "maths_112357";
        try {
            Class.forName("com.mysql.jdbc.Driver");
            connection = (Connection) DriverManager.getConnection(urlString);
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return connection;
    }
    public static void closeCon() {
            try {
                if (connection!=null) {
                    connection.close();
                }
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
    }

2：新建操作类：
其中获得上一个连接类中的Connection

public class UserDao {

    private Connection connection;
    public UserDao() {
        // TODO Auto-generated constructor stub

    }
    public UserDao(Connection connection) {
        super();
        this.connection = connection;
    }

    //以上就是最主要的过程，接下来你就可以操作你的数据库了。
    //下面是我自己的一个例子，其中Students是我自己根据数据库表创建的实体类

    public List<Students> getUserList(){
        userList = new ArrayList<Students>();
        String string = "SELECT * FROM web_test";
        ResultSet resultSet = null;
        Statement statement = null;
        try {
            statement = connection.createStatement();
            resultSet = statement.executeQuery(string);
            while (resultSet.next()) {
                Students stu = new Students();
                stu.setIdString(resultSet.getString("id"));
                stu.setAge(resultSet.getString("age"));
                stu.setNameString(resultSet.getString("name"));
                stu.setSex(resultSet.getString("sex"));
                stu.setXuehaStringo(resultSet.getString("xuehao"));
                userList.add(stu);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally{
            try {
                resultSet.close();
                statement.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        return userList;
    }