contactbean.java

来自「一个jsp+javabean实例的简单应用」· Java 代码 · 共 32 行

package com.jspdev.ch12;


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

public class ContactBean {
public static void main(String[] args){

try {
	Class.forName("com.mysql.jdbc.Driver");
	Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jspdev?user=root&password=123");
	Statement stmt= conn.createStatement();
	
	stmt.execute("insert into contact values ('126',123,'123','123','2008-01-22','123')");
	ResultSet rs = stmt.executeQuery("select * from contact"); 
	while(rs.next()) {
		System.out.println(rs.getString("userName"));
	}
	rs.close();
	conn.close();
} catch( ClassNotFoundException e){System.out.println(e.getMessage());}
	catch (SQLException ex){
		System.out.println("SQLException: " + ex.getMessage());
		System.out.println("SQLState: " + ex.getSQLState());
		System.out.println("VendorError: " + ex.getErrorCode());
		}
	}
}