bean.querySpecialBean.java
import java.sql.*;
public class querySpecialBean {
public String qyeryString_Statement;
public String param[];
public ResultSet rs=null;
public Connection conn=null;
public String getQyeryString_Statement() {
return qyeryString_Statement;
}
public void setQyeryString_Statement(String qyeryString_Statement) {
this.qyeryString_Statement = qyeryString_Statement;
}
public String[] getParam() {
return param;
}
public void setParam(String[] param) {
this.param = param;
}
public ResultSet getRs() {
return rs;
}
public void setRs(ResultSet rs) {
this.rs = rs;
}
public Connection getConn() {
return conn;
}
public void setConn(Connection conn) {
this.conn = conn;
}public void setConnection(String driverName,String jdbcURL,String username,String passwd) throws Exception
{
Connection conn1;
Class.forName(driverName);
conn1=DriverManager.getConnection(jdbcURL,username,passwd);
conn1.setAutoCommit(false);
this.conn = conn1;
} public void updateRecord() throws SQLException,java.io.UnsupportedEncodingException
{
try
{
PreparedStatement update_stm=conn.prepareStatement(qyeryString_Statement);
if (param!=null)
for (int i=0;i <param.length;i++)
update_stm.setString(i+1,param[i]);
update_stm.executeUpdate();
update_stm.close();
conn.commit();
}
catch(Exception e)
{
System.out.println(e);
conn.rollback();
}
}
}updateSpecial.jsp
<%@ page import="bean.querySpecialBean"%>
<jsp:useBean id="specialUpdate" class="bean.querySpecialBean" scope="request"></jsp:useBean>
<body><%
String prm1,prm2,prm3;
int flag=0;
boolean judge=false;
prm1 = null;
prm2 = null;
prm3 = null;
specialUpdate.setConnection( "sun.jdbc.odbc.JdbcOdbcDriver ","jdbc:odbc:music","sa","");
try{ String[] param = {prm1,prm2,prm3};
specialUpdate.setQyeryString_Statement("update special set slName=?,slImages=?,slDescription=?");
specialUpdate.setParam(param);
specialUpdate.updateRecord();
}catch(Exception e){System.out.println(e); }
while (flag>0){ %> <%
judge=true;
%>
<%}%> </body>
剩下的该如何写主界面啊,我是要对其进行修改操作啊,我是建音乐网站,web project+sql server2005+eclipse
import java.sql.*;
public class querySpecialBean {
public String qyeryString_Statement;
public String param[];
public ResultSet rs=null;
public Connection conn=null;
public String getQyeryString_Statement() {
return qyeryString_Statement;
}
public void setQyeryString_Statement(String qyeryString_Statement) {
this.qyeryString_Statement = qyeryString_Statement;
}
public String[] getParam() {
return param;
}
public void setParam(String[] param) {
this.param = param;
}
public ResultSet getRs() {
return rs;
}
public void setRs(ResultSet rs) {
this.rs = rs;
}
public Connection getConn() {
return conn;
}
public void setConn(Connection conn) {
this.conn = conn;
}public void setConnection(String driverName,String jdbcURL,String username,String passwd) throws Exception
{
Connection conn1;
Class.forName(driverName);
conn1=DriverManager.getConnection(jdbcURL,username,passwd);
conn1.setAutoCommit(false);
this.conn = conn1;
} public void updateRecord() throws SQLException,java.io.UnsupportedEncodingException
{
try
{
PreparedStatement update_stm=conn.prepareStatement(qyeryString_Statement);
if (param!=null)
for (int i=0;i <param.length;i++)
update_stm.setString(i+1,param[i]);
update_stm.executeUpdate();
update_stm.close();
conn.commit();
}
catch(Exception e)
{
System.out.println(e);
conn.rollback();
}
}
}updateSpecial.jsp
<%@ page import="bean.querySpecialBean"%>
<jsp:useBean id="specialUpdate" class="bean.querySpecialBean" scope="request"></jsp:useBean>
<body><%
String prm1,prm2,prm3;
int flag=0;
boolean judge=false;
prm1 = null;
prm2 = null;
prm3 = null;
specialUpdate.setConnection( "sun.jdbc.odbc.JdbcOdbcDriver ","jdbc:odbc:music","sa","");
try{ String[] param = {prm1,prm2,prm3};
specialUpdate.setQyeryString_Statement("update special set slName=?,slImages=?,slDescription=?");
specialUpdate.setParam(param);
specialUpdate.updateRecord();
}catch(Exception e){System.out.println(e); }
while (flag>0){ %> <%
judge=true;
%>
<%}%> </body>
剩下的该如何写主界面啊,我是要对其进行修改操作啊,我是建音乐网站,web project+sql server2005+eclipse
肯定就是几个让用户输入的框框,对应你的修改的参数prm1,prm2,prm3
<tr>
<td width="57">专辑ID</td>
<td width="168">专辑名称</td>
<td width="81">发行日期</td>
<td width="96">专辑封面</td>
<td width="50">专辑描述</td>
<td width="79">专辑投票</td>
<td width="131">歌手ID</td>
<td width="207">修改</td>
</tr>
<tr>
<td> </td>
<td><input type="text" name="slName" /></td>
<td> </td>
<td><input type="image" name="slImages" /><input type="button" name="slImagesBun" value="浏览" /></td>
<td><input type="text" name="slDescription" /></td>
<td> </td>
<td> </td>
<td><a href="#">修改</a></td>
</tr>
</table></body>
该怎么写啊?我把框架搭好了