Java Connection.createStatement方法代码示例

import java.sql.Connection; //导入方法依赖的package包/类
public void mbushTabelen(){
    Thread t = new Thread(new Runnable() {
        public void run() {
            try {
                Connection conn = DriverManager.getConnection(CON_STR, "test", "test");
                Statement stmt = conn.createStatement();
                ResultSet rs = stmt.executeQuery("select * from Konsumatori");
                ObservableList<TabelaKonsumatori> data = FXCollections.observableArrayList();
                while (rs.next()){
                    data.add(new TabelaKonsumatori(rs.getInt("id"), rs.getString("emri"), rs.getString("mbiemri"),
                            rs.getString("makina"), rs.getString("komuna"), rs.getString("pershkrimi")));
                }
                table.setItems(data);
                conn.close();
            }catch (Exception ex){ex.printStackTrace();}
        }
    });
    t.start();
}
 

import java.sql.Connection; //导入方法依赖的package包/类
/**
 * Drop a table if it exists.
 */
public static void dropTable(String tableName, ConnManager manager)
    throws SQLException {
  Connection connection = null;
  Statement st = null;

  try {
    connection = manager.getConnection();
    connection.setAutoCommit(false);
    st = connection.createStatement();

    // create the database table and populate it with data.
    st.executeUpdate(getDropTableStatement(tableName));

    connection.commit();
  } finally {
    try {
      if (null != st) {
        st.close();
      }
    } catch (SQLException sqlE) {
      LOG.warn("Got SQLException when closing connection: " + sqlE);
    }
  }
}
 

import java.sql.Connection; //导入方法依赖的package包/类
public ObservableList<Sale> getList(String sqlQuery, ObservableList<Sale> saleListDetails) {
    String date, patientName, doctorName, companyName, mode;
    Long billNumber;
    Float amount;
    try {
        Connection dbConnection = JDBC.databaseConnect();
        Statement sqlStatement = dbConnection.createStatement();
        ResultSet saleResultSet = sqlStatement.executeQuery(sqlQuery);
        while (saleResultSet.next()) {
            date = saleResultSet.getString("date");
            patientName = saleResultSet.getString("patient_name");
            companyName = saleResultSet.getString("company");
            doctorName = saleResultSet.getString("doctor_name");
            mode = saleResultSet.getString("mode");
            billNumber = saleResultSet.getLong("bill_no");
            amount = saleResultSet.getFloat("total_amount");
            saleListDetails.add(new Sale(date, billNumber, patientName, doctorName, companyName, mode, amount));
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
    return saleListDetails;
}
 

import java.sql.Connection; //导入方法依赖的package包/类
public static void updateUnidadMedida(String id, String nombre,
		String abrev, String simbolo, String descripcion) {
	Connection conect = ConnectionConfiguration.conectar();
	Statement statement = null;
	String query = "update unidad_medida set ";
	// if (id!="") query+= "id=\""+id+"\", ";
	if (nombre != "")
		query += "nombre=\"" + nombre + "\", ";
	if (abrev != "")
		query += "abrev=\"" + abrev + "\", ";
	if (simbolo != "")
		query += "simbolo=\"" + simbolo + "\", ";
	if (descripcion != "")
		query += "descripcion=\"" + descripcion + "\", ";
	query = query.substring(0, query.length() - 2);
	query += "where id=" + id;

	try {
		statement = conect.createStatement();
		statement.execute(query);
		conect.close();
	} catch (SQLException e) {
		e.printStackTrace();
	}
}
 

import java.sql.Connection; //导入方法依赖的package包/类
public Team findTeamById(String term) throws SQLException {

		String query = "SELECT t.team_id, t.team_name, t.history, t.picture AS team_picture, h.name AS hero_name, h.picture AS hero_picture "
				+ "FROM team t LEFT JOIN team_hero th ON t.team_id = th.team_id "
				+ "LEFT JOIN heroes h ON th.hero_id = h.id " + "WHERE t.team_id='"+ term + "'";

		Connection connect = connectToMySQL();
		Statement statement = connect.createStatement();
		ResultSet resultSet = statement.executeQuery(query);
		if (resultSet.next()) {
			Team team = resultSetToTeam(resultSet);
			connect.close();
			return team;
		} else {
			connect.close();
			return null;
		}
	}
 

import java.sql.Connection; //导入方法依赖的package包/类
/**
 * Perform upgrade.
 */
public void upgrade(final Connection conn, final int upgradeToVersion) throws SQLException {
  final boolean savedAutoCommit = conn.getAutoCommit();
  Statement st = null; // NOPMD
  try {
    // create statement
    conn.setAutoCommit(true);
    st = conn.createStatement();

    LOG.debug("Altering table");
    PersistanceUtils.executeDDLs(st, new String[]{
            " alter table TEST_CASE drop constraint TEST_CASE_UC2",
            " alter table TEST_CASE add constraint TEST_CASE_UC2 unique (TEST_PACKAGE_ID, NAME)",
    });

    LOG.debug("Updating version");
    st.executeUpdate("update SYSTEM_PROPERTY set VALUE = '" + upgraderVersion() + "' where NAME = 'parabuild.schema.version' ");

    // finish
    conn.commit();

  } finally {
    IoUtils.closeHard(st);
    conn.setAutoCommit(savedAutoCommit);
  }
}
 

import java.sql.Connection; //导入方法依赖的package包/类
public boolean query(String sql) {
    try {
        Statement stmt = getStatement();
        if (stmt != null) {
            stmt.close();
        }
        ResultSet rs = getResultSet();
        if (rs != null) {
            rs.close();
        }
        Connection con = getConnection();
        if (con == null) {
            return false;
        }
        stmt = con.createStatement();
        setStatement(stmt);
        setResultSet(stmt.executeQuery(sql));
        return true;
    } catch (Exception e) {
        Debug.warning(e);
        return false;
    }
}
 

import java.sql.Connection; //导入方法依赖的package包/类
private void initStartCount(Connection conn) {
    try {
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt
                .executeQuery("SELECT MAX(TKEY) FROM " + TABLE_NAME);
        while (rs.next()) {
            count = rs.getInt(1);
        }
        rs.close();
        stmt.close();
    } catch (SQLException e) {
        e.printStackTrace();
        throw new RuntimeException(
                "Could not determine max id value in use.");
    }

}
 

import java.sql.Connection; //导入方法依赖的package包/类
public static boolean borradoSprProducto(SprProducto objeto, String usuarioResponsable){
  	 Connection conect=ConnectionConfiguration.conectar();
  	 Statement statement = null;
  	 objeto.changeBorrado();
  	 
	 String query = "update spr_producto set borrado='"+objeto.isBorrado()+"'";
	 		query += ", usuario_responsable='" + usuarioResponsable + "'";	
	 
	 query+=" where id ="+objeto.getId(); 	
	 try {
		statement=conect.createStatement();
		statement.execute(query);
	    conect.close();
	    return true;
	 }catch (SQLException e) {e.printStackTrace(); return false;}
}
 

import java.sql.Connection; //导入方法依赖的package包/类
public static void updateObjetoDeGasto(String id, String nombre,
		String descripcion, String abrev, String es_imputable,
		String numero_fila, String anho) {
	Connection conect = ConnectionConfiguration.conectar();
	Statement statement = null;
	String query = "update objeto_de_gasto set ";
	// if (id!="") query+= "id=\""+id+"\", ";
	if (nombre != "")
		query += "nombre=\"" + nombre + "\", ";
	if (descripcion != "")
		query += "descripcion=\"" + descripcion + "\", ";
	if (abrev != "")
		query += "abrev=\"" + abrev + "\", ";
	if (es_imputable != "")
		query += "es_imputable=\"" + es_imputable + "\", ";
	if (anho != "")
		query += "anho=\"" + anho + "\", ";
	query = query.substring(0, query.length() - 2);
	query += "where id=" + id;

	try {
		statement = conect.createStatement();
		statement.execute(query);
		conect.close();
	} catch (SQLException e) {
		e.printStackTrace();
	}
}
 

import java.sql.Connection; //导入方法依赖的package包/类
public static List<LaHasAreasAga> selectLaHasAreasAga(String conditionLaHasAreasAga) throws SQLException{
	Connection conect=ConnectionConfiguration.conectar();
	String query = " select * from la_has_areas_aga "+conditionLaHasAreasAga;

	Statement statement = null;
	ResultSet rs=null;
	List<LaHasAreasAga> objetos = new ArrayList<LaHasAreasAga>();

	try {
		statement = conect.createStatement();
		rs=statement.executeQuery(query);
		while(rs.next()){
			LaHasAreasAga objeto = new LaHasAreasAga();
	
			objeto.setLineaAccionId(rs.getInt("linea_accion_id"));
			objeto.setAreasAgaId(rs.getInt("areas_aga_id"));
			
			objetos.add(objeto);
		}
	}
	catch (SQLException e) {e.printStackTrace();}
	finally{
		if (statement != null) {statement.close();}
		if (conect != null) {conect.close();}
	}
	return objetos; 
}
 

import java.sql.Connection; //导入方法依赖的package包/类
/**
 * Tests fix for Bug#23212347, ALL API CALLS ON RESULTSET METADATA RESULTS IN NPE WHEN USESERVERPREPSTMTS=TRUE.
 */
public void testBug23212347() throws Exception {
    boolean useSPS = false;
    do {
        String testCase = String.format("Case [SPS: %s]", useSPS ? "Y" : "N");
        createTable("testBug23212347", "(id INT)");

        Properties props = new Properties();
        props.setProperty("useServerPrepStmts", Boolean.toString(useSPS));

        Connection testConn = getConnectionWithProps(props);
        Statement testStmt = testConn.createStatement();
        testStmt.execute("INSERT INTO testBug23212347 VALUES (1)");

        this.pstmt = testConn.prepareStatement("SELECT * FROM testBug23212347 WHERE id = 1");
        this.rs = this.pstmt.executeQuery();
        assertTrue(testCase, this.rs.next());
        assertEquals(testCase, 1, this.rs.getInt(1));
        assertFalse(testCase, this.rs.next());
        ResultSetMetaData rsmd = this.pstmt.getMetaData();
        assertEquals(testCase, "id", rsmd.getColumnName(1));

        this.pstmt = testConn.prepareStatement("SELECT * FROM testBug23212347 WHERE id = ?");
        this.pstmt.setInt(1, 1);
        this.rs = this.pstmt.executeQuery();
        assertTrue(testCase, this.rs.next());
        assertEquals(testCase, 1, this.rs.getInt(1));
        assertFalse(this.rs.next());
        rsmd = this.pstmt.getMetaData();
        assertEquals(testCase, "id", rsmd.getColumnName(1));
    } while (useSPS = !useSPS);
}
 

import java.sql.Connection; //导入方法依赖的package包/类
public void test() throws Exception {

        Connection conn = newConnection();
        Statement  stmt = conn.createStatement();

        stmt.executeQuery("SELECT * FROM INFORMATION_SCHEMA.SYSTEM_SESSIONS");
        conn.close();

        conn = newConnection();
        stmt = conn.createStatement();

        stmt.executeQuery("SELECT * FROM INFORMATION_SCHEMA.SYSTEM_SESSIONS");
        conn.close();
    }
 

import java.sql.Connection; //导入方法依赖的package包/类
public static List<ProductoPresupuestoDestinatario> selectAllProductosDestinatarios(String condition) throws SQLException{
 	 Connection conect=ConnectionConfiguration.conectar();
 String query = " select * from producto_presupuesto_destinatario "+condition;
 Statement statement = null;
 ResultSet rs=null;
 List<ProductoPresupuestoDestinatario> objetos = new ArrayList<ProductoPresupuestoDestinatario>();   		 

try {
	statement = conect.createStatement();
	rs=statement.executeQuery(query);
	while(rs.next()){
		ProductoPresupuestoDestinatario objeto = new ProductoPresupuestoDestinatario();
		
		objeto.setId(rs.getInt("id"));
		objeto.setDepartamento(rs.getInt("departamento"));
		objeto.setCantidad(rs.getDouble("cantidad"));
		objeto.setCatalogo_destinatario (rs.getInt("catalogo_destinatario"));
		objeto.setProducto(rs.getShort("producto"));
		objeto.setProyecto(rs.getShort("proyecto"));
		objeto.setSubprograma(rs.getShort("subprograma"));
		objeto.setPrograma(rs.getShort("programa"));
		objeto.setTipo_presupuesto(rs.getShort("tipo_presupuesto"));
		objeto.setEntidad(rs.getShort("entidad"));
		objeto.setNivel(rs.getShort("nivel"));
		objeto.setFechaActualizacion(rs.getTimestamp("fecha_actualizacion"));
		if (rs.getString("descripcion") != null) 
			objeto.setDescripcion((rs.getString("descripcion")));
		objeto.setBorrado(rs.getBoolean("borrado"));
		
		objetos.add(objeto);
	}
}
catch (SQLException e) {e.printStackTrace();}
finally{
	if (statement != null) {statement.close();}
	if (conect != null) {conect.close();}
}
return objetos;
 }
 

import java.sql.Connection; //导入方法依赖的package包/类
private void verifyTableColumnContents(Connection connection,
  String table, String column, ColumnGenerator gen)
    throws IOException, SQLException {
  Statement st = connection.createStatement();

  // create a target database table.
  assertTrue(st.execute("SELECT " + column + " FROM " + table));
  ResultSet rs = st.getResultSet();

  for (int row = 0; rs.next(); ++row) {
    assertEquals(gen.getVerifyText(row), rs.getString(1));
  }
}