一、Studnet表:
属性:sno int(20)、cno int(4)、grade int(4)。即学号、课程号、成绩。
二、Java中的类
用到的类: DBUtil(连接、关闭数据库)、Student(学生信息)、Userdemo(接口:实现Student表的增删该查)、UserdemoImpl(实现Userdemo接口里的方法)、Test(测试台);
1、Student
//Student表
public class Student
{
private int sno;
private int cno;
private int grade;
public Student(int sno, int cno, int grade)
{
this.sno = sno;
this.cno = cno;
this.grade = grade;
}
public Student()
{
}
public String toString()
{
return this.sno+","+this.cno+","+this.grade;
}
public int getSno()
{
return sno;
}
public void setSno(int sno)
{
this.sno = sno;
}
public int getCno()
{
return cno;
}
public void setCno(int cno)
{
this.cno = cno;
}
public int getGrade()
{
return grade;
}
public void setGrade(int grade)
{
this.grade = grade;
}
}
2、DBUtil
import java.io.*;
import java.util.*;
import java.sql.*;
public class DBUtil
{
private static String driver = "com.mysql.cj.jdbc.Driver"; //用于加载驱动
private static String url = "jdbc:mysql://localhost:3306/sc3?serverTimezone=UTC"; //数据库地址
private static String username = "root"; //用户名
private static String password = "123456"; //密码
//连接数据库
public static Connection open()
{
try
{
Class.forName(driver); //加载驱动
return DriverManager.getConne