Skip to main content

Posts

Showing posts from February, 2018

JAVA JDBC MySQL basic source for select, insert

package mysqlTest; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; public class dbstart { public static void main(String[] args)throws Exception { // library - mysql // connection Connection conn = getMySqlConnection(); //insert //insertUser(conn, "three", "pass", "michael", "aaa@aaa.com"); // read (select) ResultSet rs = getUsers(conn); while(rs.next()){ System.out.println(rs.getString(1) +" " + rs.getString(2) +" " + rs.getString(3)); } // update // delete } public static ResultSet getUsers(Connection conn) throws Exception{ return getResultSet(conn, "select * from users"); } public static ResultSet getResultSet(Connection conn, String sql) throws Exception { Class.forName("com.mysql.jdbc.Driver"); Statement stm = co...