java database connectivityl

[saifjob40]

i am new learner in java and i wan to learn
how to do java database connectivity with MySql

i wrote the code still i face problem ,

will any ony plase let me know the wexxat coding for that .

plase help me i am in a greate need

[ceyesuma]

Where is your database? MYSQL,access? Are you using a particular IDE?

[peter_budo]

You can find this tutorial helpful http://java.sun.com/javaee/5/docs/tutorial/doc/

[ceyesuma]

control panel /Administrative Tools/data Sources / systemDSN /"ADD"/MICROSOFT aCCESS dRIVER/FIND your database finisssssssh

<%-- create a bean in application scope, so the bean is shared in the whole Web application --%>
<jsp:useBean id="dbconnection" class="finalWebsitePackage.DBConnection" scope="application"/>
<jsp:setProperty name="dbconnection" property="dbdriver" value="sun.jdbc.odbc.JdbcOdbcDriver"/> //this is for access
<jsp:setProperty name="dbconnection" property="connURL" value="jdbc:odbc:youdatabaseDSN"/>
<jsp:setProperty name="dbconnection" property="dbusername" value=""/>
<jsp:setProperty name="dbconnection" property="dbpassword" value=""/>
</jsp:useBean>

I had to download a driver fo SQL CONNETOR
mysql-connector-java-5.0.5
which I think is in the
mysql-noinstall-5.0.41-win32.zip file I down loaded
this stuff is not everything you need but bits and pieces may help
here is a bean

package finalWebsitePackage;
import java.sql.*;

public class DBConnection {
	static String dbdriver;
	static String connURL;
	static String dbusername="";
	static String dbpassword="";	
	static Connection connection=null;
	public String getDbdriver(){
		return dbdriver;		
	}
	public String getConnURL(){
		return connURL;
	}
	public String getDbusername(){
		return dbusername;
	}
	public String getDbpassword(){
		return dbpassword;
	}
	public void setDbdriver(String url){
		this.dbdriver=dbdriver;
	}
	public void setDbusername(String dbusername){
		this.dbpassword=dbpassword;
	}
	public static Connection getConnection(){
		if(connection==null){
			try{
				Class.forName(dbdriver);
				connection=DriverManager.getConnection(connURL, dbusername,dbpassword);
			}catch(Exception exc){ connection=null;}
		}	return connection;	
	}
	
}

package connectionBean.website;
import java.sql.*;
public class DBBean{
  private Statement stm = null;
  private ResultSet rst = null;
  private ResultSetMetaData rsmd =null;
  private String tableName;
  public String getTableName(){ return tableName;}
  public void setTableName(String tableName){
    this.tableName = tableName;}
  public String getData() throws SQLException{
    if(tableName==null || tableName.equals("")) return "";
    Connection conn= DBConnection.getConnection();
    Statement stm= conn.createStatement();
    ResultSet rst= stm.executeQuery("select * from " + tableName);
    ResultSetMetaData rsmd= rst.getMetaData();
    int num=rsmd.getColumnCount();
    StringBuffer sb = new StringBuffer();
    sb.append("<table border=1>\n");
    sb.append("<tr><th colspan="+num+">Records in Table: ");
    sb.append(tableName + "</th></tr>\n");
    sb.append("<tr>");
    for(int i=1; i<=num;i++){
      sb.append("<th>" + rsmd.getColumnName(i) + "</th>\n");
    }
    sb.append("</tr>\n");
    while(rst.next()){
      sb.append("<tr>\n");
      for(int i=1; i<=num; i++){
        sb.append("<td>"+rst.getString(i)+"&nbsp;</td>\n");
      }
      sb.append("</tr>\n");
    }
    sb.append("</table>\n");
    rst.close();
    stm.close();
    return sb.toString();
  }
}

Hope this helps. good luck!

[Ranjeet Kumar]

It's must halp you.......

import java.sql.*;
import java.util.*;

public class DatabaseTableViewer {
private static final String DB = "contacts",
TABLE_NAME = "records",
HOST = "jdbc:mysql://db_host:3306/",
ACCOUNT = "account",
PASSWORD = "nevermind",
DRIVER = "org.gjt.mm.mysql.Driver";

public static void main (String[] args) {
try {

// authentication properties
Properties props = new Properties();
props.setProperty("user", ACCOUNT);
props.setProperty("password", PASSWORD);

// load driver and prepare to access
Class.forName(DRIVER).newInstance();
Connection con = DriverManager.getConnection(
HOST + DB, props);
Statement stmt = con.createStatement();

// execute select query
String query = "SELECT * FROM " + TABLE_NAME + ";";
ResultSet table = stmt.executeQuery(query);

// determine properties of table
ResultSetMetaData meta = table.getMetaData();
String[] colNames = new String[meta.getColumnCount()];
Vector[] cells = new Vector[colNames.length];
for( int col = 0; col < colNames.length; col++) {
colNames[col] = meta.getColumnName(col + 1);
cells[col] = new Vector();
}

// hold data from result set
while(table.next()) {
for(int col = 0; col < colNames.length; col++) {
Object cell = table.getObject(colNames[col]);
cells[col].add(cell);
}
}

// print column headings
for(int col = 0; col < colNames.length; col++)
System.out.print(colNames[col].toUpperCase() + "\t");
System.out.println();

// print data row-wise
while(!cells[0].isEmpty()) {
for(int col = 0; col < colNames.length; col++)
System.out.print(cells[col].remove(0).toString()
+ "\t");
System.out.println();
}
}

// exit more gently
catch(Exception e) {
e.printStackTrace();
}
}
}

[peter_budo]

Please don't mind the examples above, study on your own speed. Right now this examples can be realy confusing a specialy because they do not provide explanation what they do...