import
java
.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;
public class CONN {
public static Connection createConn()
{
Connection conn=null;
try {
//Class.forName("com.mysql.jdbc.Driver");
Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
String url = "jdbc:db2://127.0.0.1:50000/sample";
Properties props = new Properties();
props.setProperty("user", "db2admin");
props.setProperty("password", "ibmdb2");
conn=DriverManager.getConnection(url,props);
}ca