maven项目中操作mysql数据库案例

MAVEN_HOME D:\Program File\apache-maven-3.3.9
PATH;%MAVEN_HOME%\bin



project object model
pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.myproject</groupId>
    <artifactId>learning-java</artifactId>
    <version>1.0-SNAPSHOT</version>

    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.6</version>
            <scope>runtime</scope>
        </dependency>
    </dependencies>
</project>

放在msql/下的jar没找到，它自己创建了一个目录远程下载了一个

package com.test;

import com.sun.org.apache.xml.internal.serialize.LineSeparator;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class Test {
    public static void main(String[] args) throws Exception {
        System.out.println("Hello");
        StuDao stuDao=new StuDaoImp();
        List<Stu> stus=stuDao.findAll();
        System.out.println("Hello");
        for(Stu stu:stus){
            System.out.println(stu.getSname()+" "+stu.getScore());
        }
    }
}

class Stu{
    public Float getScore() {
        return score;
    }

    public void setScore(Float score) {
        this.score = score;
    }

    String sname;
    Float score;

    public String getSname() {
        return sname;
    }

    public void setSname(String sname) {
        this.sname = sname;
    }
}

interface StuDao{
    public List<Stu> findAll() throws Exception;
}

class StuDaoImp implements StuDao{
    public List<Stu> findAll() throws Exception{
        Connection conn=null;
        PreparedStatement ps=null;
        ResultSet rs=null;
        List<Stu> stus=new ArrayList<Stu>();
       try {
           //加连预执释
           Class.forName("com.mysql.jdbc.Driver");
           conn = DriverManager.getConnection("jdbc:mysql:///maven","root","tingwei");
           ps = conn.prepareCall("select * from stu");
           rs = ps.executeQuery();
           while(rs.next()){
               Stu stu=new Stu();
               stu.setSname(rs.getString("sname"));
               stu.setScore(rs.getFloat("score"));
               stus.add(stu);
           }
       }catch(Exception e){

       }finally{
           try{
               if(rs!=null){rs.close();}
               if(ps!=null){ps.close();}
               if(conn!=null){conn.close();}
           }catch (Exception e){
               e.printStackTrace();;
           }
        }
        return stus;
    }
}