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

1、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.JdbcOdbcDriv

2、er;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 co

3、n=DriverManager.getConnection(URL, USERNAME, PASSWORD);return con; catch (Exception e) e.printStackTrace();return null;/管理员登陆public boolean login() throws ExceptionScanner sc = new Scanner(System.in);System.out.print( 输入用户名 :);String username = sc.next();System.out.print( 输入密码 :);String password = s

4、c.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.getI

5、nt(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=+str0;try Connection connection

6、=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 c

7、onnection1 = connection();PreparedStatement statement1;try statement1 = connection1.prepareStatement(sql1);statement1.setString(1, str0);statement1.setString(2, str1);statement1.setString(3, str2);statement1.setString(4, str3);statement1.execute();System.out.println( 添加学生成功 !); catch (SQLException e

8、x) / 查询学生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

9、 = 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); c

10、atch (SQLException ex) System.out.println(nn);/删除学生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; t

11、ry 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

12、 = 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