学生信息管理系统 java 连接数据库

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Date;

import java.util.Scanner;

public class Student {

public static final String DRIVER="sun.jdbc.odbc.JdbcOdbcDriver";

public static final String URL="jdbc:odbc:student";

public static final String USERNAME="root";//用户名

public static final String PASSWORD="root";//密码

private static String name;//当前登录管理员的名字

private static int userid;//当前登录管理员的主键

//获得jdbc链接

public Connection connection(){

try {

Class.forName(DRIVER);

Connection con=DriverManager.getConnection(URL, USERNAME, PASSWORD);

return con;

} catch (Exception e) {

e.printStackTrace();

}

return null;

}

//管理员登陆

public boolean login() throws Exception{

Scanner sc = new Scanner(System.in);

System.out.print("输入用户名:");

String username = sc.next();

System.out.print("输入密码:");

String password = sc.next();

//查找该用户

String sql = "select username,id from muser where username='" + username

+ "' and password='" + password + "'";

Connection connection = connection();

Statement statement = connection.createStatement();

ResultSet rs = statement.executeQuery(sql);

if (rs.next()) {

name = rs.getString(1);

userid = rs.getInt(2);

return true;

}

return false;

}

//添加学生

//添加学生

public void addstudent(){

System.out.print("请依次输入学号,姓名,年龄,地址(用逗号隔开):");

Scanner scanner = new Scanner(System.in);

String[] str = scanner.next().split(",");

/**********************begin 验证学号是否重复*************************/ String sql = "select * from student where 1=1 and stuno="+str[0];

try {

Connection connection = connection();

Statement statement = connection.createStatement();

ResultSet rs = statement.executeQuery(sql);

if(rs.next()){

System.out.println("该学号已经存在,请更换");

return;

}

} catch (SQLException ex) {

}

/**********************end 验证学号是否重复*************************/

String sql1 = "insert into student(stuno,stuname,stuage,stuaddress) values(?,?,?,?)"; Connection connection1 = connection();

PreparedStatement statement1;

try {

statement1 = connection1.prepareStatement(sql1);

statement1.setString(1, str[0]);

statement1.setString(2, str[1]);

statement1.setString(3, str[2]);

statement1.setString(4, str[3]);

statement1.execute();

System.out.println("添加学生成功!!");

} catch (SQLException ex) {

}

}

// 查询学生

public void checkstudent(String sno) throws SQLException {

System.out.println("\n学生列表:");

String sql = "select * from student where 1=1 ";

if (sno!=null && !"".equals(sno)) {

sql = sql + " and stuno="+sno;

}

System.out.println("学号"+"\t"+"姓名"+"\t"+"年龄"+"\t"+"地址");

try {

Connection connection = connection();

Statement statement = connection.createStatement();

ResultSet rs = statement.executeQuery(sql);

while(rs.next()){

// int theid = rs.getInt(1);

String sno1 = rs.getString(2);

String name1 = rs.getString(3);

String age1 = rs.getString(4);

String address1 = rs.getString(5);

//打印出来

System.out.println(sno1+"\t"+name1+"\t"+age1+"\t"+address1);

}

} catch (SQLException ex) {

}

System.out.println("\n\n");

}

//删除学生

public void deletestudent() {

System.out.print("请输入要删除的学号:");

Scanner scanner = new Scanner(System.in);

String stuno = scanner.next();

String sql = "delete from student where stuno="+stuno;

Connection connection = connection();

PreparedStatement statement;

try {

statement = connection.prepareStatement(sql);

statement.execute();

System.out.println("删除学生成功!!");

} catch (SQLException ex) {

}

}

// 主函数入口

public static void main(String[] args) throws Exception {

Student theLibrary = new Student();

// 登陆

boolean loginflag = true;

while (loginflag) {

if(theLibrary.login()){//

loginflag = false;

}else {

System.out.println("用户名或者密码错误,请检查.");

}

}

//登陆成功提示

System.out.println("\n-------------------------你好,"+ name +"! 欢迎来到学生管理系统-------------------------");

boolean flag = true;

while (flag) {

System.out.print("\n操作说明: '1' 添加学生,'2' 删除学生,'3' 查找学生, '4' 显示所有学生,'-1' 退出系统:");

Scanner scanner = new Scanner(System.in);

int input = 0;

try {

input = scanner.nextInt();

} catch (Exception e) {

System.out.println("-----------请选择一个操作----------");

continue;

}

if (input==-1) {

System.out.println("谢谢使用,再见!!");

flag = false;

}else {

//添加学生

if (input==1) {

theLibrary.addstudent();

}

//删除学生

else if (input==2) {

theLibrary.deletestudent();

}

//查找学生

else if (input==3) {

System.out.print("\n请输入要查找学生学号:");

Scanner sc = new Scanner(System.in);

theLibrary.checkstudent(sc.next());

}

//查找学生

else if (input==4) {

theLibrary.checkstudent("");

}

else {

System.out.println("-----------请输入有效的操作数字-----------");

}

}

}

}

}