java connect mysql_Java - Connect to mysql

static String driver = "com.mysql.jdbc.Driver";

static String ConnectionString = "jdbc:mysql://localhost:3306/test";

static String username = "test";

static String password = "test";

public final Connection getConnection()

{

try {

Class.forName(driver);

Connection conn = DriverManager.getConnection(ConnectionString, username, password);

return conn;

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

return null;

}

}

package io.hause.db;

import java.sql.*;

import java.util.ArrayList;

import io.hause.models.AustauschprogrammlisteModel;

import io.hause.utils.*;

public class Austauschprogrammliste

{

// CURD

DBConnector dbc;

Connection conn;

public Austauschprogrammliste()

{

dbc = new DBConnector();

conn = dbc.getConnection();

}

// select

public ArrayList select(String condition)

{

ArrayList alapls = new ArrayList();

try

{

if(condition.trim().equals(""))

{

condition = "1=1";

}

String queryStr = "SELECT * FROM Austauschprogrammliste WHERE " + condition;

PreparedStatement ps = conn.prepareStatement(queryStr);

ResultSet rs = ps.executeQuery();

while(rs.next())

{

AustauschprogrammlisteModel apl = new AustauschprogrammlisteModel();

apl.setId(rs.getInt("id"));

apl.setAustauschprogrammlisteName("programName");

alapls.add(apl);

}

return alapls;

}

catch (Exception ex)

{

return null;

}

}

// insert

public boolean insert(AustauschprogrammlisteModel m)

{

String insertStr = "INSERT INTO Austauschprogrammliste(programName) VALUES(?)";

PreparedStatement ps;

try {

ps = conn.prepareStatement(insertStr);

ps.setString(1, m.getAustauschprogrammlisteName());

ps.executeUpdate();

return true;

} catch (SQLException e) {

// TODO Auto-generated catch block

//e.printStackTrace();

return false;

}

}

// update

public boolean update(AustauschprogrammlisteModel m)

{

String insertStr = "UPDATE Austauschprogrammliste SET programName=? WHERE id=?";

PreparedStatement ps;

try {

ps = conn.prepareStatement(insertStr);

ps.setString(1, m.getAustauschprogrammlisteName());

ps.setInt(2, m.getId());

ps.executeUpdate();

return true;

} catch (SQLException e) {

// TODO Auto-generated catch block

//e.printStackTrace();

return false;

}

}

//delete by id

public boolean delete(int id)

{

String insertStr = "DELETE FROM Austauschprogrammliste WHERE id=?";

PreparedStatement ps;

try {

ps = conn.prepareStatement(insertStr);

ps.setInt(1, id);

ps.executeUpdate();

return true;

} catch (SQLException e) {

// TODO Auto-generated catch block

//e.printStackTrace();

return false;

}

}

// test

/*

public static void main(String args[])

{

Austauschprogrammliste aplist = new Austauschprogrammliste();

//ArrayList apls = aplist.select("");

//System.out.println("count:" + apls.size());

AustauschprogrammlisteModel m = new AustauschprogrammlisteModel();

//m.setId(3);

m.setAustauschprogrammlisteName("Landesprogramm South Australia");

if(aplist.insert(m))

{

System.out.println("Yes");

}

else

{

System.out.println("No");

}

}

*/

}