📄 zxc.java
字号:
import java.sql.*;
import java.util.*;
import java.io.*;
public class zxc {
public static void main(String args[])
{
int a=0;
Scanner reader=null;
while(true)
{
System.out.println("请选择:");
System.out.println(" ");
System.out.println("1:学生表");
System.out.println("2:系别表");
System.out.println("3:教师表");
System.out.println("4:课程表");
System.out.println("5:退出");
System.out.println("-------------------》");
System.out.print("请输入：");
System.out.println(" ");
Scanner f=new Scanner(System.in);
int p=f.nextInt();
switch(p){
case 1:
while(true)
{
System.out.println("\t"+"----请选项：----");
System.out.println(" ");
System.out.println("1.查询");
System.out.println("2.添加");
System.out.println("3.删除");
System.out.println("4.修改");
System.out.println("5.退出");
System.out.println(" ");
System.out.print("所选的项是：");
reader=new Scanner(System.in);
a=reader.nextInt();
if (a==1)
{
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chenjm";
String user="ming";//这里替换成你自已的数据库用户名
String password="123456";//这里替换成你自已的数据库用户密码
String sqlStr="select zhuanye,sname,sex,jibie,xi,kcname from student where sname like ? and jibie like ?";
System.out.println(" ");
System.out.println("\t"+"-----查询功能:-----");
System.out.println(" ");
System.out.print("请输学生名:");
InputStreamReader stdin=new InputStreamReader(System.in);
BufferedReader br=new BufferedReader(stdin);
String s="";String zhuanye="";String sname="";String sex="";String jibie="";String xi="";String kcname="";
try{
s=br.readLine();
System.out.print("请输入要查询的学生名字:");
sname=br.readLine();
//System.out.print("请输入要查询的高达图片:");
//tupian=br.readLine();
System.out.print("请输入要查询的学生专业:");
xi=br.readLine();
}catch(IOException e){}
//sqlStr="select bianhao,mingzi,jiage,tupian,xinghao from cpsm where jiage like '%"+jiage+"%' and xinghao like '%"+xinghao+"%'";
try
{ //这里的异常处理语句是必需的.否则不能通过编译!
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
// System.out.println("类实例化成功!");
Connection con = DriverManager.getConnection(url,user,password);
// System.out.println("创建连接对像成功!");
PreparedStatement st = con.prepareStatement(sqlStr);
// System.out.println("创建Statement成功!");
st.setString(1,"%"+sname+"%");
st.setString(2,"%"+zhuanye+"%");
ResultSet rs = st.executeQuery(sqlStr); //向SQL发送数据命令update
// System.out.println("操作数据表成功!");
System.out.println("----------------!");
System.out.println("专业\t\t名字\t\t性别\t\t级别\t\t系\t\t课程名");
int numb=0;
while(rs.next())
{
numb++;
System.out.print(rs.getString("zhuanye")+"\t");
System.out.print(rs.getString("sname")+"\t"+"\t");
System.out.print(rs.getString("sex")+"\t"+"\t");
System.out.print(rs.getString("jibie")+"\t");
System.out.print(rs.getString("xi")+"\t");
System.out.print(rs.getString("kcname")+"\t");
System.out.println("");
}
System.out.println("找到"+numb+"个结果");
System.out.println("");
rs.close();
st.close();
con.close(); }
catch(Exception err){
err.printStackTrace(System.out);
}
}
else if (a==2)
{
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chenjm";
String user="ming";//这里替换成你自已的数据库用户名
String password="123456";//这里替换成你自已的数据库用户密码
String sqlStr="";
System.out.println(" ");
System.out.println("\t"+"-----添加功能:-----");
System.out.println(" ");
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager.getConnection(url,user,password);
Statement st = con.createStatement();
ResultSet rs=null;
String b="";
String s="";
boolean tips=true;
do{
System.out.println("学生名");
reader=new Scanner(System.in);
s= reader.nextLine();
sqlStr="select * from student where sname = '"+s+"'";
rs = st.executeQuery(sqlStr);
tips=rs.next();
if(tips)
System.out.println("已经有这个学生的资料,请再输入");
}while(tips);
do{
System.out.println("请输入专业");
b= reader.nextLine();
sqlStr="select * from student where zhuanye = '"+b+"'";
rs = st.executeQuery(sqlStr);
tips=rs.next();
if(!tips)
System.out.println("没有学生资料,请再输入");
}while(!tips);
rs.close();
System.out.print("请输入性别:");
String i= reader.nextLine();
System.out.print("请输入级别:");
String h= reader.nextLine();
System.out.print("请输入系:");
String x= reader.nextLine();
System.out.print("请输入课程名:");
String y= reader.nextLine();
sqlStr="Insert cpsm values('"+b+"','"+s+"','"+i+"','"+h+"','"+x+",'"+y+"')";
int rsint = st.executeUpdate(sqlStr);
if (rsint==0)
System.out.println("--------添加失败--------!");
else
System.out.println("--------添加成功--------!");
st.close();
con.close();
}
catch(Exception err)
{
err.printStackTrace(System.out);
}
}
else if (a==3)
{
System.out.println(" ");
System.out.println("\t"+"-----删除功能:-----");
System.out.println(" ");
System.out.print("输入你要删除数据的学生名:");
reader=new Scanner(System.in);
String s=reader.nextLine();
System.out.println(" ");
System.out.println("您输入的数据是:"+"“"+s+"”");
System.out.println(" ");
System.out.println("是否删除该资料:1是;2不是");
System.out.println("你的选择:");
int d=0;
Scanner h=new Scanner(System.in);
d=h.nextInt();
while(true){
if(d==1){
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chenjm";
String user="ming";//这里替换成你自已的数据库用户名
String password="123456";//这里替换成你自已的数据库用户密码
String sqlStr="delete from student where sname like '%"+s+"%'";
try
{ //这里的异常处理语句是必需的.否则不能通过编译!
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
// System.out.println("类实例化成功!");
Connection con = DriverManager.getConnection(url,user,password);
// System.out.println("创建连接对像成功!");
Statement st = con.createStatement();
// System.out.println("创建Statement成功!");
// ResultSet rs = st.executeQuery(sqlStr); //向SQL发送数据命令update
int rs = st.executeUpdate(sqlStr);
// System.out.println("操作数据表成功!";break;);
System.out.println("----------------!");
System.out.println(" ");
System.out.println("数据删除成功!");
System.out.println(" ");
st.close();
con.close();
}
catch(Exception err)
{
err.printStackTrace(System.out);
}
{ System.out.print("你的操作已成功"); break;} }
else if(d==2)
{ System.out.print("你的操作已取消"); break;}
}
}
else if (a==4)
{ String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chenjm";
String user="ming";//这里替换成你自已的数据库用户名
String password="123456";//这里替换成你自已的数据库用户密码
String sqlStr="select * from student";
System.out.println(" ");
System.out.println("\t"+"-----修改功能:-----");
System.out.println(" ");
System.out.println(" ");
System.out.println("是否修改该资料:1是;2不是");
System.out.println("你的选择:");
int d=0;
Scanner h=new Scanner(System.in);
d=h.nextInt();
while(true){
if(d==1){
InputStreamReader stdin=new InputStreamReader(System.in);
BufferedReader br=new BufferedReader(stdin);
System.out.print("\n请要修改的学生名是：");
reader=new Scanner(System.in);
String s= reader.nextLine();
System.out.print("请输入要修改的项目:");
String y= reader.nextLine();
System.out.print("请输入原来的资料:");
String t= reader.nextLine();
System.out.print("请输入要更新的资料:");
String u= reader.nextLine();
sqlStr="update student set "+y+"='"+u+"' where "+y+"='"+t+"'";
try
{ //这里的异常处理语句是必需的.否则不能通过编译!
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
// System.out.println("类实例化成功!");
Connection con = DriverManager.getConnection(url,user,password);
// System.out.println("创建连接对像成功!");
Statement st = con.createStatement();
// System.out.println("创建Statement成功!");
// ResultSet rs = st.executeQuery(sqlStr); //向SQL发送数据命令update
// System.out.println("操作数据表成功!");
System.out.println("----------------!");
int rs = st.executeUpdate(sqlStr);
System.out.println(" ");
System.out.println("数据修改成功!");
System.out.println(" ");
st.close();
con.close();
}
catch(Exception err)
{
err.printStackTrace(System.out);
}
{ System.out.print("你的操作已成功"); break;} }
else if(d==2)
{ System.out.print("你的操作已取消"); break;}
}
}
else if (a==5)
{
System.out.println(" ");
System.out.println("\t"+"-----退出-----");
System.out.println(" ");
break;
}
else
{
System.out.println("有错误");
}continue;
}
case 2:
while(true)
{
System.out.println("\t"+"----请选项：----");
System.out.println(" ");
System.out.println("1.查询");
System.out.println("2.添加");
System.out.println("3.删除");
System.out.println("4.修改");
System.out.println("5.退出");
System.out.println(" ");
System.out.print("所选的项是：");
reader=new Scanner(System.in);
a=reader.nextInt();
if (a==1)
{
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chenjm";
String user="ming";//这里替换成你自已的数据库用户名
String password="123456";//这里替换成你自已的数据库用户密码
String sqlStr="select * from xibie";
System.out.println(" ");
System.out.println("\t"+"-----查询功能:-----");
System.out.println(" ");
sqlStr="select * from xibie ";
try
{ //这里的异常处理语句是必需的.否则不能通过编译!
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
// System.out.println("类实例化成功!");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -