源代码:
import java.sql.*;
import java.io.*;
public class DBOperation
{
public static void main (String arg[]){
try
{
BufferedReader stdin=new BufferedReader(new
InputStreamReader(System.in));
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:sqlserver://localhost:1433;
DatabaseName=123";
String user="sa";
String password="123456";
String op;
String id,name,age;
int i;
Connection
conn=DriverManager.getConnection(url,user,password);
Statement
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery("select * from 车次");
try{
while(true)
{
System.out.println("**************************************");
System.out.println("*操作指令列表: *");
System.out.println("*0:退出 *");
System.out.println("*1:查询 *");
System.out.println("*2:添加 *");
System.out.println("*3:修改 *");
System.out.println("*4:删除 *");
System.out.println("**************************************");
System.out.print("请选择操作指令:");
op=stdin.readLine();
if(op.equals("0"))
{
rs.close();