flex与Java整合(完整的增删改查)
连接数据库:
package com.db;
import java.sql.*;
public class DBUtlie {
private static final String
DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String
URL="jdbc:sqlserver://127.0.0.1:1433;databaseName=mytest";
private static final String USER="sa";
private static final String PWD="123";
private Connection con=null;
public Connection getConnection(){
try{
Class.forName(DRIVER);
con=DriverManager.getConnection(URL,USER,PWD);
}catch(Exception e){
e.printStackTrace();
}
return con;
}
public static void close(Connection con, PreparedStatement ps, ResultSet rs) {
try {
if (rs != null) {
rs.close();
}
if (ps != null) {
ps.close();
}
if (con != null) {
con.close();
}
} catch (SQLException se) {
se.printStackTrace();