数据库面试技巧，通过JDBC展示自己专业性，摘自java web轻量级开发面试教程

             1
            import
             java.sql.Connection;

             2
            import
             java.sql.DriverManager;

             3
            import
             java.sql.ResultSet;

             4
            import
             java.sql.SQLException;

             5
            import
             java.sql.Statement;

             6
            public
            class
             ResultDemo {

             7
            public
            static
            void
             main(String[] args) {

             8
            try
             {

             9
            //
            需要确保支持MySQL的jar能被读到
            10               Class.forName("com.mysql.jdbc.Driver");
11             } catch (ClassNotFoundException e) {
12                 System.out.println("Where is your MySQL JDBC Driver?");
13                e.printStackTrace();
14return;
15            }
16             Connection connection = null;
17             Statement stmt = null;
18try {
19//这里是连接字符串20                 connection = DriverManager.getConnection(
21                     "jdbc:mysql://localhost:3306/class3", "root", "123456");
22if (connection != null) {
23                     stmt = connection.createStatement();
24                     String query = "select ID,Name from student";
25                     ResultSet rs=stmt.executeQuery(query);
26while(rs.next())
27                    {
28                        System.out.println(rs.getString(“ID”));
29                         System.out.println(rs.getString("Name"));
30                    }
31                 } else {
32                     System.out.println("Failed to make connection!");
33                }
34             } catch (SQLException e) {
35     System.out.println("Check the JDBC Driver or Connection!");
36                e.printStackTrace();
37             } finally {
38//close the connection 39try {
40                        stmt.close();
41                connection.close();
42                 } catch (SQLException e) {
43                    e.printStackTrace();
44                }
45            }
46        }
47     }

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCBatch {
	public static void main(String[] args) {
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			System.out.println("Where is your MySQL JDBC Driver?");
			e.printStackTrace();
			return;
		}
		Connection connection = null;
	        PrepareStatement pstmt;
			try {
	        //这里是连接字符串
				connection = DriverManager.getConnection(
						"jdbc:mysql://localhost:3306/class3", "root", "123456");
				if (connection != null) {
					String query = "insert into student values (?,?)";
					pstmt = connection.preparedStatement(query);//开始设置参数
					pstmt.setString(1,"1");
					pstmt.setString(2,"Peter");
					pstmt.addBatch();
					//设置第二个参数
					pstmt.setString(1,"2");
					pstmt.setString(2,"Mike");
					pstmt.addBatch();
					//执行批处理
					pstmt.executeBatch();				
				} else {
					System.out.println("Failed to make connection!");
				}
			} catch (SQLException e) {
				System.out.println("Some of Students were not inserted correctly, please check the student table and insert manually.");
				e.printStackTrace();
			} finally {
				try {
					connection.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		}
	}