jdbcinsert.java

和数据库的连接工作

//Program to Insert a Record into the ChinaCities Table
import java.sql.*;
public class JDBCInsert{
public static void main(String[]args){
		try{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException ce){
			System.out.println(ce.getMessage());
			ce.printStackTrace();
                }
		try{
			Connection con=DriverManager.getConnection("jdbc:odbc:个人资料");
			String sqlquery="INSERT INTO 个人资料 VALUES ('yuan','200232580170','J2EE')";
			Statement stmt=con.createStatement();
			int flag=stmt.executeUpdate(sqlquery);
			System.out.println(flag+"rows inserted");
			stmt.close();
			con.close();
		}
		catch(SQLException se){
			System.out.println("SqlException"+se.getMessage());
			se.printStackTrace();
		}
	}
}