JAVA 操作MYSQL数据库 可查看,插入,删除 数据

package sql;
import java.sql.*;
import java.io.*;
public class ControlTheDatabase {
/**
* @param args
*/
private static Connection con;
private static Statement stmt;
private static ResultSet rs;
private static String com;
@SuppressWarnings("unused")
private static int rs1;
public static void main(String[] args) {
// TODO Auto-generated method stub
try{
Class.forName("com.mysql.jdbc.Driver");
getCon();
System.out.println("连接数据库成功，请选择您需要的操作(选择序号)");
System.out.println("1:visit"+" "+"2:control"+" "+"3:exit");
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
com = br.readLine();
if(com.equals("1")){getRs();}
if(com.equals("2")){getStmt();}
if(com.equals("3")){System.exit(0);}
}catch(Exception e){System.out.println(e.getMessage());}
}
/**
* @param con the con to set
*/
public void setCon(Connection con) {
ControlTheDatabase.con = con;
}
/**
* @return the con
*/
public static Connection getCon() {
String host="jdbc:mysql://localhost:3306/test";
System.out.println("请输入用户名：");
BufferedReader br1=new BufferedReader(new InputStreamReader(System.in));
String user = null;
try {
user = br1.readLine();
} catch (IOException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
}
System.out.println("请输入密码：");
BufferedReader br2=new BufferedReader(new InputStreamReader(System.in));
String password = null;
try {
password = br2.readLine();
} catch (IOException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
try {
con=DriverManager.getConnection(host,user,password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}
/**
* @param stmt the stmt to set
*/
public void setStmt(Statement stmt) {
ControlTheDatabase.stmt = stmt;
}
/**
* @return the stmt
* @throws SQLException
* @throws IOException
*/
public static Statement getStmt() throws SQLException, IOException {
stmt=con.createStatement();
System.out.println("输入SQL指令（警告：SQL指令为不能为空否则推出本
系统！）：");
BufferedReader br3=new BufferedReader(new InputStreamReader(System.in));
String sql=br3.readLine();
rs1=stmt.executeUpdate(sql);
System.out.println("1:visit"+" "+"2:insert"+" "+"3:delet");
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
com = br.readLine();
if(com.equals("1")){getRs();}
if(com.equals("2")){getStmt();}
if(com.equals("3")){System.exit(0);}
return stmt;
}
/**
* @param rs the rs to set
*/
public void setRs(ResultSet rs) {
ControlTheDatabase.rs = rs;
}
/**
* @return the rs
* @throws IOException
* @throws SQLException
*/
public static ResultSet getRs() throws IOException, SQLException {
Statement st=con.createStatement();
System.out.println("输入SQL指令（警告：SQL指令为不能为空否则推出本
系统！）：");
BufferedReader br3=new BufferedReader(new InputStreamReader(System.in));
String sql=br3.readLine();
rs=st.executeQuery(sql);
int i=0;
while(rs.next()){
i++;
String id=rs.getString("id");
String name=rs.getString("name");
String age=rs.getString("age");
System.out.println(i+" "+id+" "+name+" "+age);
}
System.out.println("1:visit"+" "+"2:control"+" "+"3:exit");
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
com = br.readLine();
if(com.equals("1")){getRs();}
if(com.equals("2")){getStmt();}
if(com.equals("3")){System.exit(0);}
return rs;
}
}。