学生管理系统
来源:互联网 发布:平面设计网络课程 编辑:程序博客网 时间:2024/05/19 12:13
package xuesheng;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
public class daoimpl implements dao {
Scanner sc = new Scanner(System.in);
public void add() {
// TODO Auto-generated method stub
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Connection conn;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test1", "root", "root");
System.out.println("添加学生信息");
System.out.println("请输入学生姓名");
String xingming=sc.next();
System.out.println("性别");
String xingbie=sc.next();
System.out.println("年龄");
String nianling=sc.next();
System.out.println("所在学院");
String xueyuan=sc.next();
System.out.println("所学专业");
String zhuanye=sc.next();
System.out.println("年级");
String nianji=sc.next();
System.out.println("班级");
String banji=sc.next();
System.out.println("电话号");
String tel=sc.next();
Statement sta = conn.createStatement();
String sql = "insert into student values(0,'"+xingming+"','"+xingbie+"','"+nianling+"','"+xueyuan+"','"+zhuanye+"','"+nianji+"','"+banji+"','"+tel+"')";
int a = sta.executeUpdate(sql);
if(a>=1){
System.out.println("添加成功");
}else{
System.out.println("添加失败");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void cxdg() {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Connection conn;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test1", "root", "root");
String sql ="select * from student";
Statement sta = conn.createStatement();
ResultSet re = sta.executeQuery(sql);
while (re.next()) {
String sno = re.getString("sno");
String studentname = re.getString("studentname");
System.out.println(studentname);
}
System.out.println("请输入要查询的学生姓名");
String chaxun = sc.next();
Statement sta1 = conn.createStatement();
String sql1 ="select * from student where studentname='"+chaxun+"'";
ResultSet re1 = sta.executeQuery(sql1);
while (re1.next()) {
String sno = re.getString("sno");
String studentname = re1.getString("studentname");
String sex = re1.getString("sex");
String age = re1.getString("age");
String xueyuan = re1.getString("xueyuan");
String zhuanye = re1.getString("zhuanye");
String grade = re1.getString("grade");
String banji = re1.getString("banji");
String tel = re1.getString("tel");
System.out.println(sno+','+studentname+','+sex+','+age+','+xueyuan+','+zhuanye+','+grade+','+banji+','+tel);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// TODO Auto-generated method stub
}
public void delete() {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Connection conn;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test1", "root", "root");
String sql ="select * from student";
Statement sta = conn.createStatement();
ResultSet re = sta.executeQuery(sql);
while (re.next()) {
String sno = re.getString("sno");
String studentname = re.getString("studentname");
String sex = re.getString("sex");
String age = re.getString("age");
String xueyuan = re.getString("xueyuan");
String zhuanye = re.getString("zhuanye");
String grade = re.getString("grade");
String banji = re.getString("banji");
String tel = re.getString("tel");
System.out.println(sno+','+studentname+','+sex+','+age+','+xueyuan+','+zhuanye+','+grade+','+banji+','+tel);
}
System.out.println("请输入要删除的学生");
String shanchu = sc.next();
Statement sta1 = conn.createStatement();
String sql1 = "delete from student where studentname= '"+shanchu+"'";
int a = sta.executeUpdate(sql);
if (a>=1) {
System.out.println("删除成功");
}else{
System.out.println("删除失败");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// TODO Auto-generated method stub
}
public void update() {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Connection conn;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test1", "root", "root");
String sql ="select * from student";
Statement sta = conn.createStatement();
ResultSet re = sta.executeQuery(sql);
while (re.next()) {
String sno = re.getString("sno");
String studentname = re.getString("studentname");
String sex = re.getString("sex");
String age = re.getString("age");
String xueyuan = re.getString("xueyuan");
String zhuanye = re.getString("zhuanye");
String grade = re.getString("grade");
String banji = re.getString("banji");
String tel = re.getString("tel");
System.out.println(sno+','+studentname+','+sex+','+age+','+xueyuan+','+zhuanye+','+grade+','+banji+','+tel);
}
System.out.println("请输入要修改的学生姓名");
String xingming = sc.next();
System.out.println("请输入要修改学生的性别");
String xingbie= sc.next();
System.out.println("请输入要修改学生的年龄");
String nianling= sc.next();
System.out.println("请输入要修改学生的所在学院");
String xueyuan = sc.next();
System.out.println("请输入要修改学生的所学专业");
String zhuanye= sc.next();
System.out.println("请输入要修改学生的年级");
String nianji= sc.next();
System.out.println("请输入要修改学生的班级");
String banji= sc.next();
System.out.println("请输入要修改学生的手机号");
String shoujihao= sc.next();
Statement sta1 = conn.createStatement();
String sql1 = "update student set studentname='"+xingming+"', sex='"+xingbie+"' ,age='"+nianling+"', xueyuan='"+xueyuan+"', zhuanye='"+zhuanye+"', grade='"+nianji+"', banji='"+banji+"', tel='"+shoujihao+"' where studentname='"+xingming+"'";
int a = sta.executeUpdate(sql1);
if (a>=1) {
System.out.println("修改成功");
}else{
System.out.println("修改失败");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// TODO Auto-generated method stub
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
public class daoimpl implements dao {
Scanner sc = new Scanner(System.in);
public void add() {
// TODO Auto-generated method stub
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Connection conn;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test1", "root", "root");
System.out.println("添加学生信息");
System.out.println("请输入学生姓名");
String xingming=sc.next();
System.out.println("性别");
String xingbie=sc.next();
System.out.println("年龄");
String nianling=sc.next();
System.out.println("所在学院");
String xueyuan=sc.next();
System.out.println("所学专业");
String zhuanye=sc.next();
System.out.println("年级");
String nianji=sc.next();
System.out.println("班级");
String banji=sc.next();
System.out.println("电话号");
String tel=sc.next();
Statement sta = conn.createStatement();
String sql = "insert into student values(0,'"+xingming+"','"+xingbie+"','"+nianling+"','"+xueyuan+"','"+zhuanye+"','"+nianji+"','"+banji+"','"+tel+"')";
int a = sta.executeUpdate(sql);
if(a>=1){
System.out.println("添加成功");
}else{
System.out.println("添加失败");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void cxdg() {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Connection conn;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test1", "root", "root");
String sql ="select * from student";
Statement sta = conn.createStatement();
ResultSet re = sta.executeQuery(sql);
while (re.next()) {
String sno = re.getString("sno");
String studentname = re.getString("studentname");
System.out.println(studentname);
}
System.out.println("请输入要查询的学生姓名");
String chaxun = sc.next();
Statement sta1 = conn.createStatement();
String sql1 ="select * from student where studentname='"+chaxun+"'";
ResultSet re1 = sta.executeQuery(sql1);
while (re1.next()) {
String sno = re.getString("sno");
String studentname = re1.getString("studentname");
String sex = re1.getString("sex");
String age = re1.getString("age");
String xueyuan = re1.getString("xueyuan");
String zhuanye = re1.getString("zhuanye");
String grade = re1.getString("grade");
String banji = re1.getString("banji");
String tel = re1.getString("tel");
System.out.println(sno+','+studentname+','+sex+','+age+','+xueyuan+','+zhuanye+','+grade+','+banji+','+tel);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// TODO Auto-generated method stub
}
public void delete() {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Connection conn;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test1", "root", "root");
String sql ="select * from student";
Statement sta = conn.createStatement();
ResultSet re = sta.executeQuery(sql);
while (re.next()) {
String sno = re.getString("sno");
String studentname = re.getString("studentname");
String sex = re.getString("sex");
String age = re.getString("age");
String xueyuan = re.getString("xueyuan");
String zhuanye = re.getString("zhuanye");
String grade = re.getString("grade");
String banji = re.getString("banji");
String tel = re.getString("tel");
System.out.println(sno+','+studentname+','+sex+','+age+','+xueyuan+','+zhuanye+','+grade+','+banji+','+tel);
}
System.out.println("请输入要删除的学生");
String shanchu = sc.next();
Statement sta1 = conn.createStatement();
String sql1 = "delete from student where studentname= '"+shanchu+"'";
int a = sta.executeUpdate(sql);
if (a>=1) {
System.out.println("删除成功");
}else{
System.out.println("删除失败");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// TODO Auto-generated method stub
}
public void update() {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Connection conn;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test1", "root", "root");
String sql ="select * from student";
Statement sta = conn.createStatement();
ResultSet re = sta.executeQuery(sql);
while (re.next()) {
String sno = re.getString("sno");
String studentname = re.getString("studentname");
String sex = re.getString("sex");
String age = re.getString("age");
String xueyuan = re.getString("xueyuan");
String zhuanye = re.getString("zhuanye");
String grade = re.getString("grade");
String banji = re.getString("banji");
String tel = re.getString("tel");
System.out.println(sno+','+studentname+','+sex+','+age+','+xueyuan+','+zhuanye+','+grade+','+banji+','+tel);
}
System.out.println("请输入要修改的学生姓名");
String xingming = sc.next();
System.out.println("请输入要修改学生的性别");
String xingbie= sc.next();
System.out.println("请输入要修改学生的年龄");
String nianling= sc.next();
System.out.println("请输入要修改学生的所在学院");
String xueyuan = sc.next();
System.out.println("请输入要修改学生的所学专业");
String zhuanye= sc.next();
System.out.println("请输入要修改学生的年级");
String nianji= sc.next();
System.out.println("请输入要修改学生的班级");
String banji= sc.next();
System.out.println("请输入要修改学生的手机号");
String shoujihao= sc.next();
Statement sta1 = conn.createStatement();
String sql1 = "update student set studentname='"+xingming+"', sex='"+xingbie+"' ,age='"+nianling+"', xueyuan='"+xueyuan+"', zhuanye='"+zhuanye+"', grade='"+nianji+"', banji='"+banji+"', tel='"+shoujihao+"' where studentname='"+xingming+"'";
int a = sta.executeUpdate(sql1);
if (a>=1) {
System.out.println("修改成功");
}else{
System.out.println("修改失败");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// TODO Auto-generated method stub
}
}
阅读全文
0 0
- 一个学生管理系统
- 学生同学录管理系统
- 学生管理系统
- 销售学生管理系统
- 学生通讯管理系统
- 学生管理系统
- 学生管理系统
- 学生管理系统
- 学生管理系统
- 学生学籍管理系统
- 学生管理系统
- 学生通讯录管理系统
- 学生管理系统
- 学生管理系统源程序
- 学生管理系统源程序
- 学生管理系统实现
- 学生管理系统
- 学生管理系统
- sap SLD和solution manger 的联系
- jquery操作radio和checkbox
- Web界面检查点和测试原则
- NSUserDefaults
- 动态申请权限允许后fragment崩溃
- 学生管理系统
- Spring Cloud入门三- Zuul作api-gateway
- python-安装pip以及setuptools
- 鼠标拖拽窗口效果(不允许拖出屏幕的可视区域)
- 前台控制开始日期小于结束日期
- java从FTP下载文件功能
- 5个月ReactNative感受
- linux 下配置opencv3.3.0及 opencv_contrib
- 子元素浮动父容器高度不能自适应的CSS解决方法