这里使用JAVA语言编写的简易的学生选课系统,展现的都是这个系统核心代码。
其中有不足欢迎批评和指正!
链接数据库的代码
package connection;
//连接数据库student
import java.sql.Connection;
import java.sql.DriverManager;
//import java.sql.Statement;
import java.sql.SQLException;
public class xu{
private static Connection conn = null;
static {
try {
// 注册驱动
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
// 获得一个数据库连接
conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=student","sa","123456");
}catch(ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getConnection() {
return conn;
}
}
选课的操作代码
package connection;
import java.sql.*;
import java.util.*;
public class test1{
private static String ID;// 此处的ID设为全局变量,在下面某些方法里会用到
private static Scanner console = new Scanner(System.in);
private static String managerPass = "123456";
private static Connection conn = xu.getConnection();
public static void main(String [] args) throws SQLException {
System.out.println("Welcome to the student selection system!\n\n"
+"if you are maneger please choose 6、7、8、9、10\n"
+"if you are student Please choose 1、2、3、4、5、10\n");
ShowMenu();
}
public static void ShowMenu() throws SQLException {
System.out.println("-----------option-------------\n");
System.out.println("1--Student login"); // 学生登录
System.out.println("2--Change password"); // 学生修改密码
System.out.println("3--Choose course"); // 学生选课
System.out.println("4--Get course list"); // 学生查看自己的课程表
System.out.println("5--Student rigistration"); // 学生注册账号
System.out.println("6--Create student"); // 管理员创建学生
System.out.println("7--Create course"); // 管理员创建课表
System.out.println("8--Get student list"); // 管理员查看学生表
System.out.println("9--Get course list1"); // 管理员查看选课表里的课程
System.out.println("10--exit\n"); // 退出
Test();
}
public static void Test() throws SQLException {
System.out.println("manager choose 1 ,student choose 0");
int choose1 = console.nextInt(); //int 用nextInt()
if(choose1 == 1) {
System.out.println("Please input your password :");
String password = console.next(); //String 用next()
if(password.equals(managerPass)) {
System.out.println("Welcome manager!\n");
ManagerMenu1();
}
else {
System.out.println("Your password is worry!"); }
}
else if(choose1 == 0) {
System.out.println("Welcome Student!");
StudentMenu1();
}
}<