testdml.java

这是一个测试java jdbc数据库编程的标准程序模板

import java.sql.*;

public class TestDML {
	public static void main(String[] args) {
		if(args.length != 3) {
			System.out.println("the parameter is error,the number is three");
			System.exit(-1);
		}
		
		int deptno = 0;
		deptno = Integer.parseInt(args[0]);
		String dname = args[1];
		String loc = args[2];
		Connection conn = null;
		PreparedStatement pstmt = null;
		
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://localhost/temp?user=root&password=root");
			//String sql = "insert into dept values(?,?,?)";
			String s = "insert into dept values(?,?,?)";
			pstmt = conn.prepareStatement(s);
			pstmt.setInt(1,deptno);
			pstmt.setString(2,dname);
			pstmt.setString(3,loc);
			pstmt.execute();
		}catch(ClassNotFoundException e) {
			e.printStackTrace();
		}catch(SQLException e) {
			e.printStackTrace();
		}finally {
			try {
				if(pstmt != null) {
					pstmt.close();
					pstmt = null;
					
				}
				if(conn != null) {
					conn.close();
					conn = null;
				}
			}catch(SQLException e) {
				e.printStackTrace();
			}
		}
	}
}