xml文件
<?xml version="1.0" encoding="utf-8"?>
<ScrollView xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:app="http://schemas.android.com/apk/res-auto"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical"
tools:context=".ScActivity">
<LinearLayout
android:id="@+id/main_ll1"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="vertical">
<TextView
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="趣味科普"
android:textSize="30dp"
android:gravity="center"
android:textStyle="bold"/>
<View
android:id="@+id/main_top_layout"
android:layout_width="wrap_content"
android:layout_height="30dp"
android:background="@color/grey_EEEEE"/>
<ListView
android:id="@+id/sc_lv"
android:layout_width="match_parent"
android:layout_height="640dp"
android:layout_marginTop="20dp"
android:background="@color/white"
android:divider="@null"
android:dividerHeight="6dp"
android:padding="10dp"
android:scrollbars="none" />
</LinearLayout>
</ScrollView>
对应Java文件:
package com.hui.weblab;
import androidx.appcompat.app.AppCompatActivity;
import android.content.Intent;
import android.net.Uri;
import android.os.Bundle;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import android.widget.Toast;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import bean.bilibili;
public class ScActivity extends AppCompatActivity {
ArrayList<bilibili> bilibiliArrayList=null;
/*
public ArrayList<bilibili> run() {
String diver = "com.mysql.jdbc.Driver";
//加入utf-8是为了后面往表中输入中文,表中不会出现乱码的情况
String url = "jdbc:mysql://10.99.116.217:3306/exercise";
String user = "qc";//用户名
String password = "123456";//密码
/*
* 连接数据库10.99.116.217
* */
/*
try {
Class.forName(diver);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection conn=null;
try {
conn = DriverManager.getConnection(url, user, password);
} catch (SQLException e) {
e.printStackTrace();
}
Statement st=null;
ResultSet rs=null;
ArrayList<bilibili> bilibiliArrayList1=null;
String sql = "select * from bilibili";
try {
st = conn.createStatement();
rs = st.executeQuery(sql);
while (rs.next()) {
bilibili bi = new bilibili();
bi.setAuthor(rs.getString("author"));
bi.setTitle(rs.getString("title"));
bi.setId(rs.getInt("id"));
bilibiliArrayList1.add(bi);
System.out.print(bi.getId());
}
st.close();
conn.close();
System.out.println("连接数据库成功");
} catch (SQLException e) {
e.printStackTrace();
System.out.println("连接数据库失败");
}
return bilibiliArrayList1;
}*/
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_sc);
/*
Connection conn=null;
Statement st=null;
ResultSet rs=null;
*/
// bilibiliArrayList=run();
String[] str= {"美丽科学BOS","爆炸实验室BoomLab","宝藏资源库","化学小莫","白小白很不乖","奇奇实验坊","龙虾麻麻的宝藏育儿库","唐唐频道","魔力科学小实验","H2元素实验室","氟氟今天吃什么"};
String[] url={"https://www.bilibili.com/video/BV1oa4y1x7Wr?spm_id_from=333.337.search-card.all.click","https://www.bilibili.com/video/BV1zW411B7Q1?spm_id_from=333.337.search-card.all.click", "https://www.bilibili.com/video/BV1Qv4y1N7DL?spm_id_from=333.337.search-card.all.click","https://www.bilibili.com/video/BV1c4411r7fB?spm_id_from=333.337.search-card.all.click","https://www.bilibili.com/video/BV1Ei4y1Q75M?spm_id_from=333.337.search-card.all.click","https://www.bilibili.com/video/BV1Hh411B7Sa?spm_id_from=333.337.search-card.all.click","https://www.bilibili.com/video/BV1yF411B7LV?spm_id_from=333.337.search-card.all.click","https://www.bilibili.com/video/BV1bb411E7TY?spm_id_from=333.337.search-card.all.click"};
// int i=0;
/* for(bilibili it : bilibiliArrayList)
{
str[i++]=it.getTitle();
}*/
ArrayAdapter<String> adapter=new ArrayAdapter<String>(ScActivity.this,
android.R.layout.simple_list_item_1,str);
ListView listView=(ListView)findViewById(R.id.sc_lv);
listView.setAdapter(adapter);
listView.setOnItemClickListener(new AdapterView.OnItemClickListener() {
@Override
public void onItemClick(AdapterView<?> arg0, View arg1, int arg2,
long arg3) {
Intent intent= new Intent();
intent.setAction("android.intent.action.VIEW");
Uri content_url = Uri.parse(url[arg2]);
intent.setData(content_url);
startActivity(intent);
}
});
}
}
原创文章,作者:dweifng,如若转载,请注明出处:https://blog.ytso.com/tech/pnotes/273150.html