java语言的数据库模式的web程序入门(myeclipse+sqlserver)

package com.test.bean; import java.sql.SQLException; public class SqlTest { public static void main(String[] args) { try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); } catch (ClassNotFoundException e) { e.printStackTrace(); } java.sql.Connection con = null; java.sql.Statement stmt = null; java.sql.ResultSet rs = null; try { con = java.sql.DriverManager .getConnection( "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=shyhao", "sa", ""); stmt = con.createStatement(); rs = stmt.executeQuery("select * from Messages"); while (rs.next()) { System.out.println("编号=" + rs.getInt(1)); } } catch (SQLException e) { e.printStackTrace(); } finally { try { rs.close(); } catch (SQLException e) { } try { stmt.close(); } catch (SQLException e) { } try { con.close(); } catch (SQLException e) { } } } public String rtnTable() { String mystr = "<table border=\"1\" width=\"200\" cellpadding=\"0\" cellspacing=\"0\"> <tr align=\"center\"> <td>编号</td> <td>姓名</td> </tr> <tr align=\"center\">"; try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); } catch (ClassNotFoundException e) { e.printStackTrace(); } java.sql.Connection con = null; java.sql.Statement stmt = null; java.sql.ResultSet rs = null; try { con = java.sql.DriverManager .getConnection( "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=shyhao", "sa", ""); stmt = con.createStatement(); rs = stmt.executeQuery("select * from QQUser"); while (rs.next()) { mystr = mystr + "<tr align=\"center\"><td>" + rs.getInt(1) + "</td> <td>" + rs.getString(2) + "</td> </tr>"; } } catch (SQLException e) { e.printStackTrace(); } finally { try { rs.close(); } catch (SQLException e) { } try { stmt.close(); } catch (SQLException e) { } try { con.close(); } catch (SQLException e) { } } return mystr + "</table>"; } public String add() { return "<br>QQ<br>"; } }