冲刺成果演示

package com.example.kaoyanpai;

public class school {
    private String name;
    private String fenshu;
    private String bili;
    private String jingyan;
    private String taolunzu;

    public school(String name, String fenshu, String bili, String jingyan, String taolunzu) {
        this.name = name;
        this.fenshu = fenshu;
        this.bili = bili;
        this.jingyan = jingyan;
        this.taolunzu = taolunzu;
    }

    public school() {
    }

    public String getName() {
        return name;
    }

    public String getFenshu() {
        return fenshu;
    }

    public String getBili() {
        return bili;
    }

    public String getJingyan() {
        return jingyan;
    }

    public String getTaolunzu() {
        return taolunzu;
    }

    public void setName(String name) {
        this.name = name;
    }

    public void setFenshu(String fenshu) {
        this.fenshu = fenshu;
    }

    public void setBili(String bili) {
        this.bili = bili;
    }

    public void setJingyan(String jingyan) {
        this.jingyan = jingyan;
    }

    public void setTaolunzu(String taolunzu) {
        this.taolunzu = taolunzu;
    }
}

package com.example.kaoyanpai;

public class CostBean {
    private String name;
    private String password;

    public String getName() {
        return name;
    }

    public String getPassword() {
        return password;
    }

    public void setName(){

    }

    public void setName(String name) {
        this.name = name;
    }

    public void setPassword(String password) {
        this.password = password;
    }
    public  CostBean(){

    }

    public CostBean(String name, String password) {
        this.name = name;
        this.password = password;
    }
}

package com.example.kaoyanpai;

import android.util.Log;

import com.mysql.jdbc.Connection;

import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class db {

    private static String driver = "com.mysql.jdbc.Driver";//MySQL 驱动
    private static String url = "jdbc:mysql://192.168.1.5:3306/yanhu?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull";
    private static String user = "root";//用户名
    private static String password = "zhangziyi1670";//密码
//192.168.1.5
    /**
     * 连接数据库
     * */

    public static Connection getConn(){
        Connection conn = null;
        try {
            Class.forName(driver);//获取MYSQL驱动
            conn = (Connection) DriverManager.getConnection(url, user, password);//获取连接
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return conn;
    }

    /**
     * 关闭数据库
     * */

    public static void closeAll(Connection conn, PreparedStatement ps){
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (ps != null) {
            try {
                ps.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

    }

    /**
     * 关闭数据库
     * */

    public static void closeAll(Connection conn, PreparedStatement ps, ResultSet rs){
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (ps != null) {
            try {
                ps.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
public static void main(String[] args){
    if(getConn()!=null){
        Log.i("message","ok");
    }
    else {
        Log.i("m","no");
    }
}
}

package com.example.kaoyanpai;

import android.util.Log;

import com.mysql.jdbc.Connection;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class DBService {
    private Connection conn = null; //打开数据库对象
    private PreparedStatement ps = null;//操作整合sql语句的对象
    private ResultSet rs = null;//查询结果的集合

    /**
     * 获取要发送短信的患者信息    查
     */

    public boolean  getUserData(String name){
        //结果存放集合
        List<CostBean> list=new ArrayList<CostBean>();
        boolean flag=false;
        //MySQL 语句
        String sql="select * from yanhu where name = ‘"+name+"‘";
        //获取链接数据库对象
        conn= db.getConn();
        try {
            if(conn!=null&&(!conn.isClosed())){
                ps= (PreparedStatement) conn.prepareStatement(sql);
                if(ps!=null){
                    rs= ps.executeQuery();
                    if(rs!=null){
                        flag=true;
                    }
                    else flag=false;
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        db.closeAll(conn,ps,rs);//关闭相关操作
        return flag;
    }
//查学校
public List<school>  searchschool(String name){
    //结果存放集合
    List<school> list=new ArrayList<school>();
    //MySQL 语句
    String sql="select * from school where name = ‘"+name+"‘";
    //获取链接数据库对象
    conn= db.getConn();
    try {
        if(conn!=null&&(!conn.isClosed())){
            ps= (PreparedStatement) conn.prepareStatement(sql);
            if(ps!=null){
                rs= ps.executeQuery();
                if(rs.next()){
                    school school=new school();
                    school.setName(name);
                    school.setFenshu(rs.getString("fenshu"));
                    school.setBili(rs.getString("bili"));
                    school.setJingyan(rs.getString("jingyan"));
                    school.setTaolunzu(rs.getString("taolun"));
                    list.add(school);
                }
            }
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
    db.closeAll(conn,ps,rs);//关闭相关操作
    return list;
}
    /**
     * 修改数据库中某个对象的状态   改
     * */

    /*public int updateUserData(String phone){
        int result=-1;
        if(!StringUtils.isEmpty(phone)){
            //获取链接数据库对象
            conn= DBOpenHelper.getConn();
            //MySQL 语句
            String sql="update user set state=? where phone=?";
            try {
                boolean closed=conn.isClosed();
                if(conn!=null&&(!closed)){
                    ps= (PreparedStatement) conn.prepareStatement(sql);
                    ps.setString(1,"1");//第一个参数state 一定要和上面SQL语句字段顺序一致
                    ps.setString(2,phone);//第二个参数 phone 一定要和上面SQL语句字段顺序一致
                    result=ps.executeUpdate();//返回1 执行成功
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        DBOpenHelper.closeAll(conn,ps);//关闭相关操作
        return result;
    }

    /**
     * 批量向数据库插入数据   增
     * */
    public  int insertUserData(List<CostBean> list) {
        int result = -1;
        if ((list != null) && (list.size() > 0)) {
            //获取链接数据库对象
            conn = db.getConn();
            if(conn==null){
                Log.i("list","connnull");
            }
            //MySQL 语句
            String sql = "INSERT INTO yanhu (name,password) VALUES (?,?)";
            try {
                boolean closed = conn.isClosed();
                if ((conn != null) && (!closed)) {
                    for (CostBean user : list) {
                        ps = (PreparedStatement) conn.prepareStatement(sql);
                        String name = user.getName();
                        String password = user.getPassword();
                        ps.setString(1, name);//第一个参数 name 规则同上
                        ps.setString(2, password);//第二个参数 phone 规则同上

                        result = ps.executeUpdate();//返回1 执行成功
                    }
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        db.closeAll(conn, ps);//关闭相关操作
        return result;
    }



    /**
     * 删除数据  删
     * */

    /*public int delUserData(String phone) {
        int result = -1;
        if ((!StringUtils.isEmpty(phone)) && (PhoneNumberUtils.isMobileNumber(phone))) {
            //获取链接数据库对象
            conn = DBOpenHelper.getConn();
            //MySQL 语句
            String sql = "delete from user where phone=?";
            try {
                boolean closed = conn.isClosed();
                if ((conn != null) && (!closed)) {
                    ps = (PreparedStatement) conn.prepareStatement(sql);
                    ps.setString(1, phone);
                    result = ps.executeUpdate();//返回1 执行成功
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        DBOpenHelper.closeAll(conn, ps);//关闭相关操作
        return result;

    }*/
    public static void main(String[] args){
        List<CostBean>list=new ArrayList<CostBean>();
        CostBean costBean=new CostBean();
        costBean.setName("zhangziyi");
        costBean.setPassword("zhangziyi");
        list.add(costBean);
        //insertUserData(list);
    }
}

package com.example.kaoyanpai;

import android.content.Context;
import android.os.Handler;
import android.os.Looper;
import android.util.AttributeSet;

import androidx.annotation.NonNull;
import androidx.annotation.Nullable;
import androidx.viewpager.widget.ViewPager;

public class ScoViewParger extends ViewPager {
    private Handler handler;
    public ScoViewParger(@NonNull Context context) {
        this(context,null);
    }

    public ScoViewParger(@NonNull Context context, @Nullable AttributeSet attrs) {
        super(context, attrs);
        handler=new Handler(Looper.getMainLooper());



    }

    @Override
    protected void onAttachedToWindow() {
        super.onAttachedToWindow();
        startLooper();
    }
    private void startLooper(){
        handler.postDelayed(mTask,4000);
    }
    private Runnable mTask=new Runnable() {
        @Override
        public void run() {
            int currentItem=getCurrentItem();
            currentItem++;
            setCurrentItem(currentItem);
            postDelayed(this,4000);
        }
    };
    @Override
    protected void onDetachedFromWindow() {
        super.onDetachedFromWindow();
        stopLooper();
    }
    private void stopLooper(){
        handler.removeCallbacks(mTask);
    }
}

package com.example.kaoyanpai;

import androidx.annotation.NonNull;
import androidx.appcompat.app.AppCompatActivity;
import androidx.viewpager.widget.PagerAdapter;
import androidx.viewpager.widget.ViewPager;

import android.content.Intent;
import android.os.Bundle;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.ImageView;

import java.util.ArrayList;
import java.util.List;
import java.util.Timer;
import java.util.TimerTask;

public class startActivity extends AppCompatActivity {
    private ViewPager viewPager;
    private List<Integer> list=new ArrayList<>();
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_start);
        //10秒后向登录界面跳转
        initViews();
        initData();
        Timer timer=new Timer();
        TimerTask timerTask=new TimerTask() {
            @Override
            public void run() {
                startActivity(new Intent(startActivity.this,zhuce.class));
            }
        };
        timer.schedule(timerTask,10000);
        Log.i("message","chenggong");
    }
    private void initViews() {  //加载布局

        viewPager = (ViewPager) findViewById(R.id.im1);
        viewPager.setAdapter(my);
    }

    private PagerAdapter my=new PagerAdapter(){

        @Override
        public int getCount() {
            return list.size();
        }

        @Override
        public boolean isViewFromObject(@NonNull View view, @NonNull Object object) {
            return view==object;
        }
        //Alt+Insert
        @NonNull
        @Override
        public Object instantiateItem(@NonNull ViewGroup container, int position) {
            View item= LayoutInflater.from(container.getContext()).inflate(R.layout.item,container,false);
            ImageView iv=item.findViewById(R.id.im2);
            //设置数据

            iv.setImageResource(list.get(position));
            if(iv.getParent() instanceof ViewGroup){
                ((ViewGroup)iv.getParent()).removeView(iv);
            }
            container.addView(iv);
            return iv;
        }

        @Override
        public void destroyItem(@NonNull ViewGroup container, int position, @NonNull Object object) {
            container.removeView((View)object);
        }
    };


    private void initData() {    //加载数据
        list.add(R.mipmap.yan1);
        list.add(R.mipmap.yan2);
        list.add(R.mipmap.yan3);
        my.notifyDataSetChanged();
    }
}