java课程设计+Mysql--小型学生管理系统(无窗体)

《java课程设计+Mysql--小型学生管理系统(无窗体)》由会员分享，可在线阅读，更多相关《java课程设计+Mysql--小型学生管理系统(无窗体)（16页珍藏版）》请在装配图网上搜索。

1、package Student;import java.sql.*;import java.util.*;public class AdEnter /* * param args * throws Exception */public AdEnter() throws ExceptionSystem.out.println(欢迎使用小型学生管理系统!);System.out.println(请根据提示进行操作!);System.out.println();System.out.println(1.增加学生信息);System.out.println(2.查找学生信息);System.out.p

2、rintln(3.修改学生信息);System.out.println(4.删除学生信息);System.out.println(5.显示所有学生信息);System.out.println(6.排序学生信息);System.out.println(请输入您的选择:);Scanner c = new Scanner(System.in);int a = c.nextInt();switch(a)case 1 : new add();break;case 2 : new find();break;case 3 : new change();break;case 4 : new del();bre

3、ak;case 5 : new show();break;case 6 : new sort();break;default :System.out.println(请输入正确选项!);new AdEnter();break;public static void main(String args) throws Exception / TODO Auto-generated method stubAdEnter h = new AdEnter();package Student;import java.sql.Connection;import java.sql.SQLException;im

4、port java.sql.Statement;import java.util.Scanner;public class add Statement stmt;public int x = 0;public add() throws Exceptionchar m;String id;String name;String col;String cl;String math;String os; String java;doScanner c = new Scanner(System.in);System.out.print(请输入学生学号:);id = c.nextLine();System

5、.out.println(n);System.out.print(请输入学生姓名:);name = c.nextLine();System.out.println(n);System.out.print(请输入学生学院:);col = c.nextLine();System.out.println(n);System.out.print(请输入学生班级:);cl = c.nextLine();System.out.println(n);System.out.print(请输入学生数学成绩:);math = c.nextLine();System.out.println(n);System.ou

6、t.print(请输入学生os成绩:);os = c.nextLine();System.out.println(n);System.out.print(请输入学生java成绩:);java = c.nextLine();System.out.println(n);Connection conn = DBUtil.getDBConn();String sql = create table IF NOT EXISTS stus(stuid int, stuname varchar(20), stucollege varchar(20), +stuclass varchar(20), stumat

7、h decimal, stuos decimal, stujava decimal);Statement stmt = conn.createStatement();stmt.executeUpdate(sql);stmt = conn.createStatement();String sql1 = INSERT INTO stus VALUES(+id+,+name+,+col+,+cl+,+math+,+os+,+java+);int efr = stmt.executeUpdate(sql1);stmt.close();if(efr 0)System.out.println(学生信息添加

8、成功!);x+;System.out.println(是否继续录入学生信息?(y/n);m = c.next().charAt(0);while(m = y | m = Y);new AdEnter();package Student;import java.sql.Connection;import java.sql.SQLException;import java.sql.Statement;import java.util.Scanner;public class change private static String id;private static String id1;priv

9、ate static String name;private static String col;private static String cl;private static String math;private static String os; private static String java; public change() throws Exception System.out.println(欢迎使用简易学生信息管理系统修改功能n);Scanner c = new Scanner(System.in);System.out.println(请输入要修改信息的学生学号:);id

10、1 = c.nextLine();System.out.println(请输入学生学号:);id = c.nextLine();System.out.println(请输入学生姓名:);name = c.nextLine();System.out.println(请输入学生学院:);col = c.nextLine();System.out.println(请输入学生班级:);cl = c.nextLine();System.out.println(请输入学生数学成绩:);math = c.nextLine();System.out.println(请输入学生os成绩:);os = c.nex

11、tLine();System.out.println(请输入学生java成绩:);java = c.nextLine();Connection conn = DBUtil.getDBConn();String sql = update stus set stuid = +id+,stucollege = +col+, stuclass = +cl+, stumath = +math+, +stuos = +os+, stujava = +java+ where stuid = +id1+; Statement stmt = conn.createStatement();stmt.execute

12、Update(sql);stmt.close();System.out.println(修改成功!);new AdEnter(); package Student;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;public class DBUtil private static Connection conn;statictry Class.forName(com.mysql.jdbc.Driver);conn = D

13、riverManager.getConnection(jdbc:mysql:/localhost:3306/stu, root, 123456); catch (Exception e) e.printStackTrace();public static Connection getDBConn()return conn;package Student;import java.sql.Connection;import java.sql.SQLException;import java.sql.Statement;import java.util.Scanner;public class de

14、l private static String name;Statement stmt;/* * param args * throws Exception */public del() throws Exception / TODO Auto-generated method stubSystem.out.println(欢迎使用简易学生信息管理系统删除功能n);Scanner c = new Scanner(System.in);System.out.println(请输入学生姓名:);name = c.nextLine();Connection conn = DBUtil.getDBCo

15、nn();tryString sql = delete from stus where stuname = +name+;stmt = conn.createStatement();stmt.executeUpdate(sql);stmt.close();catch(SQLException e)/ TODO Auto-generated catch blocke.printStackTrace();finallySystem.out.println(删除成功!);new del();new AdEnter();package Student;import java.sql.Connectio

16、n;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Scanner;public class find_stuid public find_stuid() throws Exception System.out.println(请输入您要查找的学生学号:);Scanner c = new Scanner(System.in);String id = c.nextLine();Connection conn = DBUtil.getDBConn();

17、tryString sql = select * from stus where stuid = +id+;Statement stmt = conn.createStatement();ResultSet rs = null;rs = stmt.executeQuery(sql);while(rs.next() System.out.println(学号: + rs.getString(stuid); /引号里面写上你的数据库表的列名 System.out.println(姓名: + rs.getString(stuname); /引号里面写上你的数据库表的列名 System.out.pri

18、ntln(学院: + rs.getString(stucollege);/引号里面写上你的数据库表的列名 System.out.println(班级: + rs.getString(stuclass); System.out.println(高数成绩: + rs.getString(stumath); System.out.println(os成绩: + rs.getString(stuos); System.out.println(java成绩: + rs.getString(stujava); rs.close();catch(SQLException e)/ TODO Auto-gene

19、rated catch blocke.printStackTrace();finally/System.out.println(查无此人!);new AdEnter();package Student;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Scanner;public class find_stuname public find_stuname() throws ExceptionSy

20、stem.out.println(请输入您要查找的学生姓名:);Scanner c = new Scanner(System.in);String name = c.nextLine();Connection conn = DBUtil.getDBConn();tryString sql = select * from stus where stuname = +name+;Statement stmt = conn.createStatement();ResultSet rs = null;rs = stmt.executeQuery(sql);while(rs.next()System.o

21、ut.println(学号: + rs.getString(stuid); /引号里面写上你的数据库表的列名 System.out.println(姓名: + rs.getString(stuname); /引号里面写上你的数据库表的列名 System.out.println(学院: + rs.getString(stucollege); /引号里面写上你的数据库表的列名 System.out.println(班级: + rs.getString(stuclass); System.out.println(高数成绩: + rs.getString(stumath); System.out.pr

22、intln(os成绩: + rs.getString(stuos); System.out.println(java成绩: + rs.getString(stujava); rs.close();catch(SQLException e)/ TODO Auto-generated catch blocke.printStackTrace();finallynew AdEnter();package Student;import java.util.Scanner;public class find public find() throws ExceptionSystem.out.println

23、(欢迎使用简易学生信息管理系统查找功能 +n);System.out.println(-);System.out.println(1.按学号进行查找);System.out.println(2.按姓名进行查找+n);System.out.println(请输入您的选择:);Scanner c = new Scanner(System.in);int a = c.nextInt();switch(a)case 1 : new find_stuid();break;case 2 : new find_stuname();break;default : System.out.println(请输入正

24、确选择!);new find();break;package Student;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class show public show() throws ExceptionConnection conn = DBUtil.getDBConn();tryString sql = select * from stus;ResultSet rs = null;Statement stm

25、t = conn.createStatement(); rs = stmt.executeQuery(sql); while(rs.next() System.out.println(学号: + rs.getString(stuid); /引号里面写上你的数据库表的列名 System.out.println(姓名: + rs.getString(stuname); /引号里面写上你的数据库表的列名 System.out.println(学院: + rs.getString(stucollege); /引号里面写上你的数据库表的列名 System.out.println(班级: + rs.get

26、String(stuclass); System.out.println(高数成绩: + rs.getString(stumath); System.out.println(os成绩: + rs.getString(stuos); System.out.println(java成绩: + rs.getString(stujava); rs.close();catch(SQLException e)/ TODO Auto-generated catch blocke.printStackTrace();finally/System.out.println(表中没有学生信息!);new AdEnt

27、er();package Student;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class sort public sort() throws ExceptionConnection conn = DBUtil.getDBConn();tryString sql = select * from stus order by stumath desc;Statement stmt = conn.createS

28、tatement();ResultSet rs = null;rs = stmt.executeQuery(sql);while(rs.next() System.out.println(学号: + rs.getString(stuid); /引号里面写上你的数据库表的列名 System.out.println(姓名: + rs.getString(stuname); /引号里面写上你的数据库表的列名 System.out.println(学院: + rs.getString(stucollege); /引号里面写上你的数据库表的列名 System.out.println(班级: + rs.g

29、etString(stuclass); System.out.println(高数成绩: + rs.getString(stumath); System.out.println(os成绩: + rs.getString(stuos); System.out.println(java成绩: + rs.getString(stujava); rs.close();catch(SQLException e)/ TODO Auto-generated catch blocke.printStackTrace();finally/System.out.println(查无此人!);new AdEnter();