发个基础jdbc

public class JDBCTest {

public static void main(String[] args) {


// �������
String driver = "com.mysql.jdbc.Driver";

// URLָ��Ҫ���ʵ���ݿ���scutcs
String url = "jdbc:mysql://127.0.0.1:3306/test";

// MySQL����ʱ���û���
String user = "root";

// MySQL����ʱ������
String password = "root";
ResultSetMetaData rsmd = null;
try {


// ���������
Class.forName(driver);

// l����ݿ�
Connection conn = DriverManager.getConnection(url, user, password);

if (!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");

// statement��4ִ��SQL���
Statement statement = conn.createStatement();

// Ҫִ�е�SQL���
String sql = "select * from teacher";

// ���
ResultSet rs = statement.executeQuery(sql);

rsmd = rs.getMetaData();
int colunmCount = rsmd.getColumnCount();
for(int i = 0;i<colunmCount;i++){
String columnName = rsmd.getColumnName(i+1); //��һ������
System.out.print(columnName+"\t");
}

System.out.println();


//String name = null;

int teacher_id = 0;
String teacher_name = null;
String teacher_phone = null;
String teacher_email = null;
while (rs.next()) {

teacher_id = rs.getInt("teacher_id");
teacher_name = rs.getString("teacher_name");
teacher_phone = rs.getString("teacher_phone");
teacher_email = rs.getString("teacher_email");
System.out.println(teacher_id+"\t"+"\t"+teacher_name+"\t"+teacher_phone+"\t"+teacher_email);
}

rs.close();
conn.close();

} catch (ClassNotFoundException e) {

System.out.println("Sorry,can`t find the Driver!");
e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

} catch (Exception e) {

e.printStackTrace();

}
}
}

//测试下

public class TestInsert {

/**
* @param args
* @throws ClassNotFoundException
* @throws SQLException
* @throws UnsupportedEncodingException
*/
public static void main(String[] args) throws ClassNotFoundException, SQLException, UnsupportedEncodingException {
// TODO Auto-generated method stub

Class.forName("com.mysql.jdbc.Driver"); 
Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://" + 
        "localhost:3306/test", "root", "root"); 
// 关闭事务自动提交 
con.setAutoCommit(false); 
 
SimpleDateFormat sdf = new SimpleDateFormat("HH:mm:ss:SS"); 
TimeZone t = sdf.getTimeZone(); 
t.setRawOffset(0); 
sdf.setTimeZone(t); 
Long startTime = System.currentTimeMillis(); 
 
String aa = "中国";
String bb = new String(aa.getBytes(),"gb2312");
PreparedStatement pst = (PreparedStatement) con.prepareStatement("insert into test_insert values (?,'"+bb+"')"); 
for (int i = 1; i < 101; i++) { 
    pst.setInt(1, i); 
    // 把一个SQL命令加入命令列表 
    pst.addBatch(); 
} 
// 执行批量更新 
pst.executeBatch(); 
// 语句执行完毕，提交本事务 
con.commit(); 
 
Long endTime = System.currentTimeMillis(); 
System.out.println("用时：" + sdf.format(new Date(endTime - startTime))); 
 
pst.close(); 
con.close();

}

}