JDBC
Main.javapackage chap05app;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.SQLException;import org.apache.commons.codec.digest.DigestUtils;public class Main {private static void loadJDBCDriver() {try {Class.forName("org.postgresql.Driver");} catch (ClassNotFoundException e) {throw new RuntimeException(e);}}private static Connection getConnection() {try {return( DriverManager.getConnection("jdbc:postgresql://localhost:5432/BookStore", "okada","okada") );} catch (SQLException e) {throw new RuntimeException(e);}}private static void closeConnection(Connection con) {try {con.close();} catch (SQLException e) {e.printStackTrace();}}private static String getStringDigest( String inString ){return( DigestUtils.md5Hex( inString + "digested" ) );}public static void main(String[] args) {loadJDBCDriver();Connection con = getConnection();try {PreparedStatement ps = con.prepareStatement("insert into t_customer ( uid, passwordmd5, name, email ) " +"values( ?, ?, ?, ? )" );ps.setString( 1, "gonta" );ps.setString( 2, getStringDigest( "gontapass" ) );ps.setString( 3, "岡田 賢治" );ps.setString( 4, "gonta@bar.com" );ps.executeUpdate();ps.close();} catch (SQLException e) {e.printStackTrace();// エラー処理を行う。} finally {closeConnection(con);}}}代码来自日本的技术图书：http://www.shuwasystem.co.jp/products/7980html/2197.html
页:
[1]