java对数据库的操作

[xiqi330]

我没有用过java编程，现需编写用jsp实现对数据库的访问，急需知道java语言是怎样对mysql进行插入和删除操作的。请诸位帮忙！

[hfprogramer]

http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=15371

[hfprogramer]

http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=108260

[seaman0916]

这是操作数据库的JavaBean,你看看,默认是MySQL的数据库驱动!

/*
* DBconn.java
*/
package dataBean;

import java.sql.*;
public class DBconn
{
String dbDriver="org.gjt.mm.mysql.Driver";
String conStr="jdbc:mysql://localhost:3306/3dsoft";
String myUser="root";
String myPassword="";
Connection con = null;
ResultSet rs = null;
public DBconn()
{
try
{
Class.forName(dbDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("DBconn (): " + e.getMessage());
}
}

public String getDbDriver()
{
return dbDriver;
}
public void setDbDriver(String dbDriver)
{
this.dbDriver=dbDriver;
}
public String getConStr()
{
return conStr;
}
public void setConStr(String conStr )
{
this.conStr = conStr ;
}
public String getMyUser()
{
return myUser ;
}
public void setMyUser(String myUser )
{
this. myUser= myUser ;
}
public String getMyPassword()
{
return myPassword ;
}
public void setMyPassword(String myPassword )
{
this.myPassword = myPassword ;
}
public ResultSet executeQuery(String sql) throws SQLException, Exception
{
rs = null;
try
{
con = DriverManager.getConnection(conStr,myUser,myPassword);
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("executeQuery:"+ex.getMessage());
return null;
}
catch(Exception e)
{
System.err.println("executeQuery:"+e.getMessage());
return null;
}
return rs;
}

public int executeUpdate(String sql)
{
int n=0;
try
{
con = DriverManager.getConnection(conStr,myUser,myPassword);
Statement stmt = con.createStatement();
n=stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println("executeUpdate:"+ex.getMessage());
return 0;
}
catch(Exception e)
{
System.err.println("executeQuery:"+e.getMessage());
return 0;
}
return n;
}
}

试试看!