import java.sql.*;
public class TestJDBC {
/**
* @param args
*/
public static void main(String[] args) {
Connection conn = null;
Statement st = null;
ResultSet rs = null;
try {
Class.forName( "com.mysql.jdbc.Driver" );
//注册
conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/scms" , "scms" , "scms" );
st = conn.createStatement();
st.executeUpdate( "INSERT INTO `menu` ( `parent_id` , `menu_name` , `menu_status` , `type` , `value` ) VALUES ( '0' , 'yeqing' , '1' , 'page' , '1' )" );
/*
rs = st.executeQuery( "SELECT * FROM `menu`" );
while ( rs.next() ) {
System.out.println(rs.getString( "menu_name" ) );
}
*/
} catch ( ClassNotFoundException e ) {
e.getStackTrace();
} catch ( SQLException e ) {
e.getStackTrace();
} finally {
try {
if ( st != null ) {
st.close();
st = null;
}
if ( conn != null ) {
conn.close();
conn = null;
}
} catch ( SQLException e ) {
e.getStackTrace();
}
}
}
}