public class JDBCTest {
public static void main(String[] arg) {
// 1. 注冊驅動
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
// 聲明變量，使用，而后關閉
Connection conn = null; // 數據庫連接
Statement stmt = null; // 數據庫表達式
ResultSet rs = null; // 結果集
try {
// 2. 獲取數據庫的連接
conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/student", "root", "");
// 3. 獲取表達式
stmt = conn.createStatement();
System.out.println("請輸入操作指令：");
BufferedReader sReader = new BufferedReader(new InputStreamReader(
System.in));
String aaString = sReader.readLine();
String args[]=aaString.split(" ");
// stmt.execute(delsql);
if (args[0].equals("add")) {
// str=new String(rs.getBytes(1),"UTF-8")
// args[2] = new String(args[2]);
String addString="insert into stuinfo (stuno,stuname) values ('"+args[1]+"','"+args[2]+"')";
stmt.execute(addString);
}else if (args[0].equals("del")) {
String delsql = "delete from stuinfo where stuno="+args[1];
stmt.execute(delsql);
}
else if (args[0].equals("update")) {
String update="update stuinfo set stuname='"+args[2]+"' where stuno='"+args[1]+"'";
stmt.executeUpdate(update);
}
else if (args[0].equals("select")) {
// String sql = "select * from stuinfo ";
// String selString="SELECT * FROM `stuinfo` WHERE stuname="+arg[2];
String selString2="select * from stuinfo where stuno='"+args[1]+"'";
// rs = stmt.executeQuery(selString);
rs=stmt.executeQuery(selString2);
}
// 4. 執行SQL
System.out.println("-----------------");
System.out.println("執行結果如下所示:");
System.out.println("-----------------");
System.out.println(" 學號" + "\t" + " 姓名");
System.out.println("-----------------");
// 5. 現實結果集里面的數據
String name = null;
while (rs.next()) {
name = rs.getString("stuname");
// name = new String(name.getBytes("ISO-8859-1"), "GB2312");
System.out.println("" + rs.getString("stuno") + "\t" + name);
}
} catch (Exception ex) {
ex.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
if (conn != null) {
conn.close();
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
}