import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Test {
public static void main(String[] args) throws Exception{
new Test().add();
}
public static void add() throws Exception{
String url="jdbc:mysql://127.0.0.1:3306/demo";
String user="root";
String password="123";
//加载驱动类
Class.forName("com.mysql.jdbc.Driver");
//建立连接
Connection coon=DriverManager.getConnection(url, user, password);
System.out.println(coon);
//准备sql
//String sql="INSERT INTO STUDENT(SID,SNAME) VALUES (3,'5')";
//String sql2="UPDATE STUDENT SET SID=0 WHERE SID=2";
String sql3="delete from student where sid=0";
String sql4="select * from student";
//创建执行对象
Statement s=coon.createStatement();
//s.executeUpdate(sql);
//s.executeUpdate(sql2);
//执行语句
s.executeUpdate(sql3);//增删改
ResultSet rs=s.executeQuery(sql4);
rs.next();//指针控制判断是否有下一行记录,如果有两个next则是第二条记录,有几个就是第几条
System.out.println(rs.getInt(1));
System.out.println(rs.getString(2));//rs.getString(2)返回该行的第二个字录,该记录为string类型
coon.close();
}
}