insertandselect.java

一个专家资料的管理系统

package cn.com.likai.sms.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class InsertAndSelect {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO 自动生成方法存根
		Connection con = null;
		Statement sm = null;
		ResultSet rs = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager
			.getConnection(
					"jdbc:mysql://localhost/sms?useUnicode=true&characterEncoding=utf8",
					"root", "123456");
			sm = con.createStatement();
			// 清空表,然后插入四条记录,最后将它取出打印出来
			sm.executeUpdate("delete from test_Table");
			// 插入记录
			String s = "李凯";
			sm.executeUpdate("insert into test_table(name0) values('" + s + "')");
			sm.executeUpdate("insert into test_table(name1) values('" + s + "')");
			sm.executeUpdate("insert into test_table(name2) values('" + s + "')");
			sm.executeUpdate("insert into test_table(name3) values('" + s + "')");
			// 读取记录
			rs = sm.executeQuery("select * from test_table");
			while (rs.next())
				System.out.println(rs.getInt("id") + " "
						+ rs.getString("name0") + " " + rs.getString("name1")
						+ " " + rs.getString("name2") + " "
						+ rs.getString("name3"));
		} catch (Exception e) {
			e.printStackTrace();
		} finally {// 关闭链接,释放资源
			if (rs != null) {
				try {
					rs.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				rs = null;
			}
			if(sm != null) {
				try {
					sm.close();
				}catch(SQLException e){ e.printStackTrace();}
			}
			if(con != null){
				try{
					con.close();
				}catch(SQLException e){e.printStackTrace();}
			}
		}

	}
}