package demo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class demo2 {
//查
public void findall() {
Connection con=null;
Statement sta=null;
ResultSet re=null;
try {
con= DriverManager.getConnection("jdbc:mysql://localhost:3306/studentmanager","root","123456");//必写
// con= DriverManager.getConnection("jdbc:mysql://localhost:3306/studentmanager","root","568065521");
sta= con.createStatement();//必写
String sql="select * from Classes";//sql语句 必写
re=sta.executeQuery(sql);//executeQuery用于查询 , executeUpdate用于修改记录 必写
while (re.next()){
System.out.println(re.getInt("ClassID")+"\t"+re.getString("ClassName"));
}
}catch (Exception e){
e.printStackTrace();
}
}
//增
public void insert(){
Connection con=null;
Statement sta=null;
int re=0;
try {
con= DriverManager.getConnection("jdbc:mysql://localhost:3306/studentmanager","root","123456");//必写
sta= con.createStatement();//必写
String sql="INSERT INTO classes VALUES('"+5+"','"+"21计应8"+"')";//mysql语句 必写
re= sta.executeUpdate(sql);executeQuery用于查询,executeUpdate用于修改记录 必写
if (re==1){
System.out.println("添加成功");
}else{
System.out.println("添加失败");
}
}
catch (Exception e){
e.printStackTrace();
}
}
//改
public void update(){
Connection con=null;
Statement sta=null;
int re=0;
try {
con= DriverManager.getConnection("jdbc:mysql://localhost:3306/studentmanager","root","123456");//必写
sta= con.createStatement();//必写
String sql="UPDATE Classes set ClassName='"+"21计应6班"+"' WHERE ClassName='"+"21计应3班"+"'";//必写
re= sta.executeUpdate(sql);//必写
if (re==1){
System.out.println("添加成功");
}else{
System.out.println("添加失败");
}
}catch (Exception e){
e.printStackTrace();
}
}
//删
private void delect() {
Connection con=null;
Statement sta=null;
int re=0;
try {
con= DriverManager.getConnection("jdbc:mysql://localhost:3306/studentmanager","root","123456");//必写
sta= con.createStatement();//必写
String sql="DELETE FROM classes WHERE ClassID='"+5+"';";//必写
re= sta.executeUpdate(sql);//必写
if (re==1){
System.out.println("添加成功");
}else{
System.out.println("添加失败");
}
}catch (Exception e){
e.printStackTrace();
}
}
public static void main(String[] args) {
demo2 ad=new demo2();
ad.findall();//查
//ad.insert();//增
//ad.update();//修
//ad.delect();//删
}
}