今日总结
今天写了一堆代码(一堆BUG),明天来改
package com.example.stusign;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.service.autofill.OnClickAction;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import androidx.annotation.Nullable;
import androidx.appcompat.app.AlertDialog;
import androidx.appcompat.app.AppCompatActivity;
import com.example.stusign.pojo.Sign;
import com.example.stusign.pojo.StuDay;
import com.example.stusign.utils.MysqlUtils;
import com.example.stusign.utils.SignUtils;
import com.example.stusign.utils.StuUtils;
import java.sql.Connection;
import java.time.LocalDate;
public class SignActivity extends AppCompatActivity implements View.OnClickListener {
@Override
protected void onCreate(@Nullable Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.everyday);
Button button=findViewById(R.id.add);
button.setOnClickListener(this);
button=findViewById(R.id.close);
button.setOnClickListener(this);
}
@Override
public void onClick(View view) {
switch (view.getId()){
case R.id.add:
EditText editText=findViewById(R.id.id);
int id=Integer.parseInt(editText.getText().toString());
editText=findViewById(R.id.keywords);
String keywords=editText.getText().toString();
editText=findViewById(R.id.summary);
String summary=editText.getText().toString();
String sqlpath=getFilesDir()+"/sign.db";
SignUtils signUtils=SignUtils.getSignUtils(this);
SQLiteDatabase sqLiteDatabase=openOrCreateDatabase(sqlpath, Context.MODE_PRIVATE,null);
AlertDialog.Builder builder=new AlertDialog.Builder(this);
builder.setTitle("打卡结果");
if(signUtils.add(sqLiteDatabase,new Sign(id, LocalDate.now().toString(),keywords,summary))){
StuDay stuDay=MysqlUtils.getdays(id);
builder.setMessage("打卡成功\n已坚持天数:\n"+Integer.toString(stuDay.getDays())+"最长坚持天数:"+Integer.toString(stuDay.getLongdays()));
}
else{
builder.setMessage("打卡失败");
}
builder.setPositiveButton("确定",null);
sqLiteDatabase.close();
builder.show();
break;
case R.id.close:
finish();
break;
}
}
}package com.example.stusign;
import androidx.appcompat.app.AppCompatActivity;
import android.content.Context;
import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.TextView;
import com.example.stusign.utils.MysqlUtils;
import com.example.stusign.utils.SignUtils;
import com.example.stusign.utils.StuUtils;
import com.example.stusign.pojo.*;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
public class MainActivity extends AppCompatActivity implements View.OnClickListener {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
Button b1 = findViewById(R.id.b1);
b1.setOnClickListener(this);
Button b2 = findViewById(R.id.b2);
b2.setOnClickListener(this);
Button b3 = findViewById(R.id.b3);
b3.setOnClickListener(this);
SQLiteDatabase sqLiteDatabase1 = openOrCreateDatabase(getFilesDir() + "/stu.db", Context.MODE_PRIVATE, null);
SQLiteDatabase sqLiteDatabase2 = openOrCreateDatabase(getFilesDir() + "/sign.db", Context.MODE_PRIVATE, null);
StuUtils stuUtils = StuUtils.getStuUtils(this);
stuUtils.onCreate(sqLiteDatabase1);
Stu stu = stuUtils.getstu(sqLiteDatabase1);
SignUtils signUtils = SignUtils.getSignUtils(this);
signUtils.onCreate(sqLiteDatabase2);
Sign sign = signUtils.getsign(sqLiteDatabase2);
TextView textView=findViewById(R.id.test);
textView.setText(String.valueOf(MysqlUtils.getConnection()));
/* MysqlUtils.addstu(stu);
MysqlUtils.addsign(sign);
stuUtils.delete(sqLiteDatabase1);
signUtils.delete(sqLiteDatabase2);
sqLiteDatabase1.close();
sqLiteDatabase2.close();
if (sign != null) {
List<Sign> signs = MysqlUtils.select(sign.getId());
int res = 0;
int k = 0;
for (int i = 0; i < signs.size() - 1; i++) {
Sign st = signs.get(i);
Sign en = signs.get(i + 1);
try {
DateFormat dft = new SimpleDateFormat("yyyy-mm-dd");
Date start = dft.parse(st.getDate());
Date end = dft.parse(en.getDate());
if (((long) end.getTime() - (long) start.getTime()) / 24 / 3600 / 1000 == 1) {
k++;
} else {
res = Math.max(res, k);
k = 0;
}
} catch (Exception e) {
e.printStackTrace();
}
}
MysqlUtils.addStuDay(new StuDay(sign.getId(), signs.size(), res));
MysqlUtils.update(new StuDay(sign.getId(), signs.size(), res));
}
MysqlUtils.close();*/
}
@Override
public void onClick(View view) {
switch (view.getId()){
case R.id.b1:
startActivity(new Intent(MainActivity.this,ResigerActivity.class));
break;
case R.id.b2:
startActivity(new Intent(MainActivity.this,SignActivity.class));
break;
case R.id.b3:
break;
}
}
}package com.example.stusign.utils;
import android.database.Cursor;
import com.example.stusign.pojo.Sign;
import com.example.stusign.pojo.Stu;
import com.example.stusign.pojo.StuDay;
import java.sql.*;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.util.ArrayList;
import java.util.List;
public class MysqlUtils {
private static String driver;
private static String url;
private static String username;
private static String password;
private static Connection connection;
private static PreparedStatement preparedStatement;
// static {
// try {
// driver="com.mysql.cj.jdbc.Driver";
// url="jdbc:mysql://172.18.56.110:3306/exam";
// username="root";
// password="111111";
// Class.forName(driver);
// connection=DriverManager.getConnection(url,username,password);
// }
// catch (Exception e){
// e.printStackTrace();
// }
// }
public static Connection getConnection(){
try {
driver="com.mysql.cj.jdbc.Driver";
url="jdbc:mysql://172.18.56.110:3306/exam";
username="root";
password="111111";
Class.forName(driver);
connection=DriverManager.getConnection(url,username,password);
}
catch (Exception e){
e.printStackTrace();
}
return connection;
}
public static void addstu(Stu stu){
try {
if(stu!=null) {
preparedStatement = connection.prepareStatement("insert ignore into stu values(?,?,?,?)", ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
preparedStatement.setInt(0, stu.getId());
preparedStatement.setString(1, stu.getName());
preparedStatement.setString(2, stu.getPhone());
preparedStatement.setString(3, stu.getUnit());
preparedStatement.execute();
}
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
public static void addsign(Sign sign){
try {
if(sign!=null) {
preparedStatement = connection.prepareStatement("insert ignore into `sign` values(?,?,?,?)", ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
preparedStatement.setInt(0, sign.getId());
preparedStatement.setString(1, sign.getDate());
preparedStatement.setString(2, sign.getKeywords());
preparedStatement.setString(3, sign.getSummary());
preparedStatement.execute();
}
}
catch (SQLException e) {
e.printStackTrace();
}
}
public static List<Sign> select(int id){
try {
preparedStatement=connection.prepareStatement("select * from `sign` where id=? order by date",ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
preparedStatement.setInt(0,id);
ResultSet resultSet=preparedStatement.executeQuery();
List<Sign> signs=new ArrayList<>();
while(resultSet.next()){
signs.add(new Sign(resultSet.getInt("id"),resultSet.getString("date"), resultSet.getString("keywords"),resultSet.getString("summary")));
}
return signs;
}catch (Exception e){
e.printStackTrace();
}
return null;
}
public static void update(StuDay stuDay){
try {
if(stuDay!=null) {
preparedStatement = connection.prepareStatement("update studay set days=?,longdays=? where id=?", ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
preparedStatement.setInt(2, stuDay.getId());
preparedStatement.setInt(0, stuDay.getDays());
preparedStatement.setInt(1, stuDay.getLongdays());
preparedStatement.execute();
}
}
catch (Exception e){
e.printStackTrace();
}
}
public static void addStuDay(StuDay stuDay){
try {
if(stuDay!=null) {
preparedStatement = connection.prepareStatement("insert ignore into studay values(?,?,?)", ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
preparedStatement.setInt(0, stuDay.getId());
preparedStatement.setInt(1, stuDay.getDays());
preparedStatement.setInt(2, stuDay.getLongdays());
preparedStatement.execute();
}
}
catch (Exception e){
e.printStackTrace();
}
}
public static StuDay getdays(int id){
try {
preparedStatement=connection.prepareStatement("select * from studay where id=?",ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
preparedStatement.setInt(0,id);
ResultSet resultSet=preparedStatement.executeQuery();
resultSet.next();
return new StuDay(resultSet.getInt("id"),resultSet.getInt("days"),resultSet.getInt("longdays"));
}
catch (Exception e){
e.printStackTrace();
}
return null;
}
public static void close(){
try {
connection.close();
preparedStatement.close();
}catch (Exception e){
e.printStackTrace();
}
}
}
浙公网安备 33010602011771号