Java 学生管理系统v1

1360阅读　0评论2015-03-04　vibe26
分类：Java


点击(此处)折叠或打开

  1. package cn.com.xiebiao.jdbcTest;

  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.PreparedStatement;
  6. import java.sql.ResultSet;
  7. import java.sql.SQLException;
  8. import java.sql.Statement;
  9. import java.util.Scanner;
  10. /**
  11.  *
  12.  * Title : JdbcStudents.java
  13.  * Company: ZhenBot
  14.  * Author : Vibe Xie @
  15.  * Time : Mar 4, 2015 9:34:54 PM
  16.  * Copyright: Copyright (c) 2015
  17.  * Description:学生管理系统v1(mysql实现)
  18.  *
  19.  * ******Statement可以优化为prepareStatement与编译sql语句。
  20.  *
  21.  */
  22. public class JdbcStudents {    
  23.     public static Connection connection;
  24.     public static Statement statement;
  25.     public static ResultSet resultSet;
  26.     public static PreparedStatement preparedStatement;
  27.     
  28.     static final String url="jdbc:mysql://localhost:3306/xiebiaoDB";
  29.     static final String user="xiebiao";
  30.     static final String password="*********";
  31.     
  32.     public static String sql;

  34.     public static Scanner in=new Scanner(System.in);
  35.     
  36.     /*静态代码块，加载jdbc和连接Mysql数据库*/
  37.     static{
  38.         try {
  39.             Class.forName("com.mysql.jdbc.Driver");
  40.         } catch (ClassNotFoundException e) {
  41.             // TODO Auto-generated catch block
  42.             e.printStackTrace();
  43.         }
  44.         
  45.         try {
  46.             connection=DriverManager.getConnection(url, user, password);
  47.             if(connection!=null){
  48.                 System.out.println("连接:"+url+"成功");
  49.             }else {
  50.                 System.out.println("连接:"+url+"失败");
  51.                 quit();
  52.             }
  53.         } catch (SQLException e) {
  54.             // TODO Auto-generated catch block
  55.             e.printStackTrace();
  56.         }
  57.     }
  58.     
  59.     /*销毁资源*/
  60.     public static void destoryResource(){
  61.         try {
  62.             if(resultSet!=null){
  63.                 resultSet.close();
  64.                 resultSet=null;
  65.             }
  66.             
  67.             if(statement!=null){
  68.                 statement.close();
  69.                 statement=null;
  70.             }
  71.             
  72.             if(connection!=null){
  73.                 connection.close();
  74.                 connection=null;
  75.             }
  76.             
  77.         } catch (SQLException e) {
  78.             // TODO Auto-generated catch block
  79.             e.printStackTrace();
  80.         }
  81.     }
  82.     
  83.     public static void add(){
  84.         int addId;
  85.         String addName;
  86.         String addClass;
  87.         
  88.         System.out.print("请输入Id:");
  89.         addId=in.nextInt();
  90.         System.out.print("请输入Name:");
  91.         addName=in.next();
  92.         System.out.print("请输入Class:");
  93.         addClass=in.next();
  94.         
  95.         try{
  96.             statement=connection.createStatement();
  97.             sql="insert into students values ("+addId+",'"+addName+"','"+addClass+"');";
  98.             int result=statement.executeUpdate(sql);
  99.             if(result>0){
  100.                 System.out.println("添加成功");
  101.             }else {
  102.                 System.out.println("添加失败");
  103.             }
  104.         }catch(Exception ex){
  105.             ex.printStackTrace();
  106.         }
  107.     }
  108.     
  109.     public static void delete(){
  110.         int choice;
  111.         int deleteId;
  112.         String deleteName;
  113.         String deleteClass;
  114.         
  115.         System.out.printf("1-按Id删除\n"
  116.                  + "2-按Name删除\n"
  117.                  + "3-按Class删除\n"
  118.                  + "请输入选项:");
  119.         choice=in.nextInt();
  120.         
  121.         switch (choice) {
  122.         case 1:
  123.             System.out.print("请输入Id:");
  124.             deleteId=in.nextInt();
  125.             sql="delete from students where id="+deleteId+";";
  126.             break;
  127.         case 2:
  128.             System.out.print("请输入Name:");
  129.             deleteName=in.next();
  130.             sql="delete from students where name='"+deleteName+"';";
  131.             break;
  132.         case 3:
  133.             System.out.print("请输入Class:");
  134.             deleteClass=in.next();
  135.             sql="delete from students where class='"+deleteClass+"';";
  136.             break;
  137.         default:
  138.             break;
  139.         }
  140.             
  141.         try{
  142.             statement=connection.createStatement();
  143.             int result=statement.executeUpdate(sql);
  144.             if(result>0){
  145.                 System.out.println("删除成功");
  146.             }else {
  147.                 System.out.println("删除失败");
  148.             }
  149.             
  150.         }catch(Exception ex){
  151.             
  152.         }
  153.     }
  154.     
  155.     public static void alter(){
  156.         int id;
  157.         int alterId;
  158.         String alterName;
  159.         String alterClass;
  160.         
  161.         System.out.print("请输入要修改的Id:");
  162.         id=in.nextInt();
  163.         System.out.print("开始修改!\n");
  164.         System.out.print("请输入Id:");
  165.         alterId=in.nextInt();
  166.             
  167.         System.out.print("请输入Name:");
  168.         alterName=in.next();
  169.             
  170.         System.out.print("请输入Class:");
  171.         alterClass=in.next();
  172.         sql="update students set id="+alterId+",name='"+alterName+"',class='"+alterClass+"' where id="+id+";";
  173.             
  174.         try{
  175.             statement=connection.createStatement();
  176.             int result=statement.executeUpdate(sql);
  177.             if(result>0){
  178.                 System.out.println("修改成功");
  179.             }else {
  180.                 System.out.println("修改失败");
  181.             }
  182.             
  183.         }catch(Exception ex){
  184.             
  185.         }
  186.     }
  187.     
  188.     public static void query(){
  189.         int choice;
  190.         int queryId;
  191.         String queryName;
  192.         String queryClass;
  193.         
  194.         System.out.printf("1-按Id查询\n"
  195.                  + "2-按Name查询\n"
  196.                  + "3-按Class查询\n"
  197.                  + "请输入选项:");
  198.         choice=in.nextInt();
  199.         
  200.         switch (choice) {
  201.         case 1:
  202.             System.out.print("请输入Id:");
  203.             queryId=in.nextInt();
  204.             sql="select * from students where id="+queryId+";";
  205.             break;
  206.         case 2:
  207.             System.out.print("请输入Name:");
  208.             queryName=in.next();
  209.             sql="select * from students where name='"+queryName+"';";
  210.             break;
  211.         case 3:
  212.             System.out.print("请输入Class:");
  213.             queryClass=in.next();
  214.             sql="select * from students where class='"+queryClass+"';";
  215.             break;
  216.         default:
  217.             break;
  218.         }
  219.         
  220.         try{
  221.             statement=connection.createStatement();
  222.             resultSet=statement.executeQuery(sql);
  223.             
  224.             while(resultSet.next()){
  225.                 System.out.println("学号："+resultSet.getInt("id")+" 姓名："+resultSet.getString("name")+" 班級："+resultSet.getString("class"));
  226.                 
  227.             }
  228.             
  229.         }catch(Exception ex){
  230.             ex.printStackTrace();
  231.         }
  232.     }
  233.     
  234.     public static void queryAll(){
  235.         sql="select * from students;";
  236.         try{
  237.             statement=connection.createStatement();
  238.             resultSet=statement.executeQuery(sql);
  239.             
  240.             while(resultSet.next()){
  241.                 System.out.println("学号："+resultSet.getInt("id")+" 姓名："+resultSet.getString("name")+" 班級："+resultSet.getString("class"));
  242.                 
  243.             }
  244.             
  245.         }catch(Exception ex){
  246.             ex.printStackTrace();
  247.         }
  248.     }
  249.     
  250.     public static void quit(){
  251.         System.out.println("成功退出");
  252.         destoryResource();
  253.         System.exit(0);
  254.     }

  256.     public static void menu(){
  257.         System.out.printf("***********学生数据管理系统(Mysql实现)*************\n"
  258.                         + " 1-增加\n"
  259.                         + " 2-删除\n"
  260.                         + " 3-修改\n"
  261.                         + " 4-查询\n"
  262.                         + " 5-查询所有\n"
  263.                         + " 6-退出\n"
  264.                         + "************************************************\n"
  265.                         + "请输入选项:");
  266.     }
  267.     
  268.     public static void main(String[] args){
  269.         int choice;
  270.         while (true){
  271.             menu();
  272.             choice=in.nextInt();
  273.             switch (choice) {
  274.             case 1:
  275.                 add();
  276.                 break;
  277.             case 2:
  278.                 delete();
  279.                 break;
  280.             case 3:
  281.                 alter();
  282.                 break;
  283.             case 4:
  284.                 query();
  285.                 break;
  286.             case 5:
  287.                 queryAll();
  288.                 break;
  289.             default:
  290.                 quit();
  291.                 break;
  292.             }
  293.         }
  294.     }
  295. }


上一篇：chrome插件
下一篇：eclipse快捷键