public static void insert() throws SQLException {
Statement st = null;
String sql = "INSERT INTO employee" + "(name, salary) " + "VALUES" + "('test', 12.0)";
try {
st = Database.getConnection().createStatement();
st.executeUpdate(sql);
}
catch (SQLException e) {
e.printStackTrace();
}
}public void insertData() throws SQLException {
//......
}<p:panelGrid columns="2">
<h:outputLabel value="Name: " />
<p:inputText value="#{emploee.name}"/>
<h:outputLabel value="Salary: " />
<p:inputText value="#{emploee.salary}"/>
<f:facet name="footer">
<h:commandButton value="Add" action="#{emploee.insertData()}"/>
</f:facet>
</p:panelGrid>public static void insert(String aName, double aSalary) throws SQLException {
PreparedStatement ps = null;
try {
ps = Database.getConnection().prepareStatement("INSERT INTO table (name, salary) VALUES (?, ?)");
ps.setString(1,aName);
ps.setDouble(2, aSalary);
ps.executeUpdate();
}
catch (SQLException e) {
e.printStackTrace();
}
}public void insertData() throws SQLException {
EmployeeDAO.insert(this.name, this.salary);
}
Простой