当前位置 : 主页 > 编程语言 > java >

使用java语句对数据库表增删查改的简单操作

来源:互联网 收集:自由互联 发布时间:2021-06-28
SqlMain import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.util.Scanner;public class Sqlmain {public static void main(String[] args) {Connection con=null;@SuppressWarnings("unused")String drive
SqlMain
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Scanner;
public class Sqlmain {

	public static void main(String[] args) {
		Connection con=null;
		@SuppressWarnings("unused")
		String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
		String dbURL = "jdbc:sqlserver://localhost:1433;databasename=zcxDB"; // 1433是端口,"USCSecondhandMarketDB"是数据库名称
		String userName = "sa"; // 用户名
		String userPwd = "123456"; // 密
		System.out.println("恭喜你连接成功!");
		try {
			con = DriverManager.getConnection(dbURL, userName, userPwd);
			Scanner sc=new Scanner(System.in);	
			
			while (true){
			System.out.println("+---------请选择将要操作的表--------+");
			System.out.println("|         1:学生基本信息表                     |");
			System.out.println("|         2:成绩表                                    |");
			System.out.println("|         3:学生课程表                             |");
			System.out.println("+---------4:退出----------------+");
			System.out.print("请选择你将要操作的表:");
		    int input=sc.nextInt();
		    
		    switch(input){
		    	case 1:
		            new Student(con);
		    	    break;
		    	case 2:
		    		new Sc(con);
			    	break;
		    	case 3:
		    		new Course(con);
			    	break;
		    	case 4:
		    		return;
		    	
		    }
			
}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
}
}
学生表
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

public class Student {
	Statement stmt=null;
	Scanner sc = new Scanner(System.in);
	public Student(Connection con){
		while(true){
			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("请输入选项:");
			int input=sc.nextInt();
			
			switch(input){
			case 1:
				scinter(con);
				break;
			case 2:
				scalter(con);
				break;
			case 3:
				scdelete(con);
				break;
			case 4:
				select(con);
				break;
			case 5:
				return;
			
			}
		}
	}

private void select(Connection con){
	try {
		PreparedStatement ps = con.prepareStatement("SELECT * FROM Student");
		ResultSet res = ps.executeQuery();
		System.out.println(
				"学号" +  "              "+ 
		        "姓名" +  "                 "+ 
			    "性别" +  "                        "+ 
		        "生日" +  "                        "+
			    "专业编号"+"                        "+
		        "年级 \n");
		while (res.next()) {
			System.out.println(res.getString(1) + "       "+ 
		                       res.getString(2) + "       "+ 
					           res.getString(3) + "       "+ 
		                       res.getString(4) + "       "+
					           res.getString(5) + "       "+
		                       res.getString(6) + "\n");
		}
	} catch (SQLException e) {
		System.out.println("你的操作有误!");
}
}
private void scinter(Connection con){
	 try {
			stmt=con.createStatement();
			System.out.println("请问需要录入几名同学的信息");
			int input=sc.nextInt();
			System.out.println("请依次输入:学号 姓名 性别 生日 专业编号 年级");
			PreparedStatement sql = con.prepareStatement("insert into sc values(?,?,?,?,?,?)");
			for(int i=0;i
 

  
   成绩表
  

  
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
public class Sc {
	Statement stmt=null;
	Scanner sc = new Scanner(System.in);
	public Sc(Connection con) 
	{  
		while(true){
			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("请输入选项:");
			int input=sc.nextInt();
			
			switch(input){
			case 1:
				scinter(con);
				break;
			case 2:
				scalter(con);
				break;
			case 3:
				scdelete(con);
				break;
			case 4:
				select(con);
				break;
			case 5:
				return;
			
			}
		}
	}

private void select(Connection con) {

		try {
			PreparedStatement ps = con.prepareStatement("SELECT * FROM sc");
			ResultSet res = ps.executeQuery();
			System.out.println(
					"选课\t编号\t学号\t课程号  ");
			while (res.next()) {
				System.out.println(res.getString(1) + "\t" + res.getString(2) + "\t" + res.getString(3) + 
						"\t"+ res.getString(4) );
			}
		} catch (SQLException e) {
			System.out.println("你的操作有误!");
  }
 }
private void scinter(Connection con){
	  
	    	 try {
				stmt=con.createStatement();
				System.out.println("请问需要录入几名同学的信息");
				int input=sc.nextInt();
				System.out.println("请依次输入:选课编号 学号 课程号 成绩");
				PreparedStatement sql = con.prepareStatement("insert into sc values(?,?,?,?)");
				for(int i=0;i
   

    
     课程表
    

    
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;

public class Course {
	Scanner sc=new Scanner(System.in);
	public Course(Connection con){
		while(true){
			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("请输入选项:");
			int input=sc.nextInt();
			switch(input){
			case 1:cinser(con); 
			        break;
			case 4:cselect(con);
			        break;
			}
			
		}
		
	}
public void cinser(Connection con){
	try {
		System.out.println("请问需要录入几名同学的信息");
		int input=sc.nextInt();
		System.out.println("请依次输入:课程号 先选课程号 课程名称 开设年级 学分");
		PreparedStatement sql = con.prepareStatement("insert into sc values(?,?,?,?,?)");
		for(int i=0;i
网友评论