JAVA第四季测试 close;

package uill;


import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import java.util.Scanner;
import java.util.jar.Attributes.Name;


import org.omg.PortableInterceptor.USER_EXCEPTION;


import com.mysql.jdbc.ResultSetMetaData;


public class Testit {


static String name;


public static void main(String[] args) throws ClassNotFoundException, SQLException, IOException {
// TODO Auto-generated method stub
// 输入主菜单；
ShowMenu();
Scanner scan = new Scanner(System.in);
int choice = scan.nextInt();
while (choice != 5) {
switch (choice) {
case 1:
String name;
String gender;
int age;
String telephone;
System.out.println("请输入姓名:");
name = scan.next();
System.out.println("请输入性别:");
gender = scan.next();
System.out.println("请输入年龄:");
age = scan.nextInt();
System.out.println("请输入电话号码:");
telephone = scan.next();
Student stu = new Student(name, gender, age, telephone, age);
Save(stu);
System.out.println();
ShowMenu();
break;
case 2:// 删除学生信息
System.out.println("请输入要删除的学生的姓名:");
String student2 = scan.next();
delete(student2);
break;
case 3:
// 显示学生方法
show();
ShowMenu();
break;
case 4:
System.out.println("请输入学生姓名:");
export();
ShowMenu();
break;
default:
System.out.print("输入不正确,请重新输入!");
break;
}
ShowMenu();
System.out.println("请输入操作序号:");
choice = scan.nextInt();
}
System.out.println("再见！欢迎再次使用本系统。");
        scan.close();
}


// 删除学生方法
public static void delete(String student2) throws ClassNotFoundException, SQLException {
// TODO Auto-generated method stub
Connection conn = getConn();
Statement st = conn.createStatement();
ResultSet rst = st.executeQuery("select * from student where name='" + student2 + "'");
if (rst.next() == false) {
System.out.println("提示：你输入的学生不存在。");
return;
} else {
String str = "delete from student where name='" + student2 + "'";
System.out.println(str);
st.executeUpdate(str);
}
conn.close();
}


// Sava方法
public static void Save(Student student) throws SQLException, ClassNotFoundException {
// TODO Auto-generated method stub
Connection conn = getConn();
String str = "insert into student values(?,?,?,?,?)";
PreparedStatement ps = conn.prepareStatement(str);
ps.setInt(1, student.getId());
ps.setString(2, student.getName());
ps.setString(3, student.getGender());
ps.setInt(4, student.getAge());
ps.setString(5, student.getTelephone());
ps.executeUpdate();
System.out.println(str);
conn.close();
}


// 程序中输出主菜单方法
public static void ShowMenu() {
System.out.println(" **************************************\r\n" + " * 欢迎使用新趋势学生信息管理系统V1.0 *\r\n"
+ " *                                    *\r\n" + " * 请选择你要执行的命令：             *\r\n"
+ " *                                    *\r\n" + " * 1.输入学生信息  2.删除学生信息     *\r\n"
+ " * 3.查询学生信息  4.导出学生信息     *\r\n" + " * 5.退出系统                         *\r\n"
+ " **************************************");
System.out.print("\n" + "请输入操作序号:");
}


// 显示学生
public static Connection show() throws ClassNotFoundException, SQLException {
Connection conn = getConn();
Statement st = conn.createStatement();


ResultSet rs = st.executeQuery("select * from student");


ResultSetMetaData data = (ResultSetMetaData) rs.getMetaData();


for (int i = 1; i <= data.getColumnCount(); i++) {
System.out.print(data.getColumnName(i) + "\t");
}
System.out.println();


while (rs.next()) {
for (int i = 1; i < 6; i++) {
System.out.print(rs.getString(i) + "\t");
}
System.out.println();
}
return conn;


}


// 导出数据d:\\data.txt
public static void export() throws IOException, SQLException, ClassNotFoundException {
FileWriter fw = new FileWriter("d:\\data.txt");
PrintWriter pw = new PrintWriter(fw);
Connection conn = getConn();
Statement st = conn.createStatement();


ResultSet rs = st.executeQuery("select * from student");


java.sql.ResultSetMetaData data = rs.getMetaData();


for (int i = 1; i <= data.getColumnCount(); i++) {
System.out.print(data.getColumnName(i) + "\t");
}
// System.out.println();


while (rs.next()) {
for (int i = 1; i < rs.getMetaData().getColumnCount(); i++) {
pw.append(rs.getString(i) + "\t");
}
pw.println();
}


st.close();
pw.close();
fw.close();
st.close();
conn.close();
}
//输出学生到表格中  
public static Connection getconn() throws ClassNotFoundException, SQLException{
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/student", "root", "12345678");
return conn;
}


// 链接数据库
public static Connection getConn() throws ClassNotFoundException, SQLException {
// 加载驱动程序类到内存中
Class.forName("com.mysql.jdbc.Driver");
// 创建一个连接
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/student", "root", "12345678");
return conn;


}
}