选课管理系统研讨.docVIP

PAGE  PAGE 17 课程设计 附录1 程序清单 附录2 执行结果 学 生 姓 名江陈瓒专 业计算机科学技术学 号120511628学 院计算机科学技术 二〇一四年七月 类DB_conn package soft.jcz.mouth; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; //连接数据库 public class DB_conn { static Connection conn = null; public static Connection getConn(){ try { Class.forName(com.mysql.jdbc.Driver); conn = DriverManager.getConnection(jdbc:mysql://localhost:3306/sell,root,root); return conn; } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; } } 类DB_help package soft.jcz.mouth; import java.util.Scanner; //系统帮助 public class DB_help { public void help(){ System.out.println(月入功能为每月数据统计用。); System.out.println(数据一经删除就无法恢复！); System.out.println(本程序由java语言编写。); System.out.println(本程序采用mysql数据库。); System.out.println(修改履历：2014/7/9); System.out.println(程序员：江陈瓒); System.out.println(学号：120511628); Scanner scanner = new Scanner(System.in); System.out.println(输入任意字符退出帮助！); String s = scanner.nextLine(); System.out.println(正在返回上层！); } } 类DB_insert package soft.jcz.mouth; 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.text.SimpleDateFormat; import java.util.Date; import java.util.Scanner; import javax.xml.crypto.Data; //便条录入,录入数据 public class DB_insert { Connection conn = null; PreparedStatement ps = null; public void insert(){ Scanner reader = new Scanner(System.in); try { //插入数据 DB_conn db_conn = new DB_conn(); conn = db_conn.getConn(); ps = conn.prepareStatement(insert into dayin(sell_id,pro_id,pro_num,date) values(?,?,?,?)); System.out.print(请输入销售员代号：); int sell_id = reader.nextInt(); System.out.print(请输入产品代号