java连接数据库并执行sql

import java.sql.* ; public class JDBCTest2 { public static void main ( String [] args ){ String driver = "com.mysql.jdbc.Driver" ; String url = "jdbc:mysql://127.0.0.1:3306/open" ; String user = "root" ; String password = "" ; try { Class . forName ( driver ); Connection conn = DriverManager . getConnection ( url , user , password ); if (! conn . isClosed ()) System . out . println ( "Succeeded connecting to the Database!" ); Statement statement = conn . createStatement (); String sql = "select SNO,SNAME from student order by SNO desc limit 0,5" ; ResultSet rs = statement . executeQuery ( sql ); System . out . println ( "-----------------" ); System . out . println ( "执行结果如下所示:" ); System . out . println ( "-----------------" ); System . out . println ( " 编号" + "\t" + " 名字" ); System . out . println ( "-----------------" ); String name = null ; while ( rs . next ()) { name = rs . getString ( "SNAME" ); //name = new String(name.getBytes("ISO-8859-1"),"GB2312"); System . out . println ( rs . getString ( "SNO" ) + "\t" + name ); } rs . close (); conn . close (); } catch ( ClassNotFoundException e ) { System . out . println ( "Sorry,can`t find the Driver!" ); e . printStackTrace (); } catch ( SQLException e ) { e . printStackTrace (); } catch ( Exception e ) { e . printStackTrace (); } } }