第一个jdbc例子

import java.sql.*;
import java.util.Properties;
import java.util.Scanner;


public class TestJDBC {

public static void main(String[] args) {

Connection conn = null;
PreparedStatement prestmt = null;
ResultSet rs = null;
Scanner sc = new Scanner(System.in);
System.out.println("请输入两个数据：");
System.out.println("number:");
int nb = Integer.parseInt(sc.next());
System.out.println("name:");
String nm = sc.next();

try {
Driver driver = new com.mysql.jdbc.Driver();
String url="jdbc:mysql://127.0.0.1:3306/schadmin";
Properties info = new Properties();
info.put("user", "root");
info.put("password", "freshbin");

conn = driver.connect(url, info);
System.out.println(conn);
System.out.println("66666666!freshbin!");
prestmt = conn.prepareStatement("insert into test value (?,?)");
prestmt.setInt(1, nb);
prestmt.setString(2, nm);
prestmt.executeUpdate();
rs = prestmt.executeQuery("select * from test");
while(rs.next()) {
System.out.println(rs.getInt("number"));
System.out.println(rs.getString("name"));
}

} catch(SQLException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
finally {
try {
if(rs != null) {
rs.close();
}
if(rs != null) {
prestmt.close();
}
if(rs != null) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}


}