public class JDBCTest {
public static void main(String[] arg) {
// 1. 注冊(cè)驅(qū)動(dòng)
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
// 聲明變量，使用，而后關(guān)閉
Connection conn = null; // 數(shù)據(jù)庫連接
Statement stmt = null; // 數(shù)據(jù)庫表達(dá)式
ResultSet rs = null; // 結(jié)果集
try {
// 2. 獲取數(shù)據(jù)庫的連接
conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/student", "root", "");
// 3. 獲取表達(dá)式
stmt = conn.createStatement();
System.out.println("請(qǐng)輸入操作指令：");
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. 執(zhí)行SQL
System.out.println("-----------------");
System.out.println("執(zhí)行結(jié)果如下所示:");
System.out.println("-----------------");
System.out.println(" 學(xué)號(hào)" + "\t" + " 姓名");
System.out.println("-----------------");
// 5. 現(xiàn)實(shí)結(jié)果集里面的數(shù)據(jù)
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();
}
}
}
}