关于WebServiceWebService怎么连接数据库

我的想法是这样的：首先建立一个showDatabase.java ,用于连接数据库，其源文件如下：

package stuTest

import java.sql.*

public class showDatabase {

public Connection getConnection()

{

Connection conn

try{

Class.forName("org.gjt.mm.mysql.Driver").newInstance()

conn=DriverManager.getConnection("jdbc:","root","a123456")

//conn.setAutoCommit(false)

}

catch(Exception e){throw new RuntimeException(e)}

return conn

}

public void closeCon(Connection conn)

{

try{

if(conn!=null) conn.close()

}

catch(SQLException e)

{

throw new RuntimeException(e)

}

}

public void rollback(Connection conn)

{

try

{

conn.rollback()

}

catch(SQLException e)

{

throw new RuntimeException(e)

}

}

}

转载，仅供参考。

详细实现写给你实在是没时间写的，可以告诉你思路。

首先呢，你现在页面上写几个按钮

然后呢，你用Jquery封装好的ajax访问后台

再然后，后台把接收到数据，存入数据库，就这么简单

全是自己一步一步手敲出来的 ，表为User，字段有 编号： int id，用户名：string UserName，密码：string UserPwd

/// <summary>

/// 添加

/// </summary>

/// <param name="name">用户名</param>

/// <param name="pwd">密码</param>

/// <returns></returns>

[WebMethod]

public int Add(string name,string pwd)

{

SqlConnection conn = new SqlConnection("连接字符串")

conn.Open()

string sql = "intsert into User (UserName,UsersPwd) values(@UserName,@UsersPwd)"

SqlCommand cmd = new SqlCommand(sql, conn)

SqlParameter parn = new SqlParameter("@UserName", name)

cmd.Parameters.Add(parn)

SqlParameter parp = new SqlParameter("@UsersPwd", pwd)

cmd.Parameters.Add(parp)

int result = cmd.ExecuteNonQuery()

conn.Close()

cmd.Dispose()

return result

}

/// <summary>

/// 修改

/// </summary>

/// <param name="name">用户名</param>

/// <param name="pwd">密码</param>

/// <param name="id">编号</param>

/// <returns></returns>

[WebMethod]

public int Update(string name, string pwd, int id)

{

SqlConnection conn = new SqlConnection("连接字符串")

conn.Open()

string sql = "update User set UserName=@UserName,UsersPwd=@UsersPwd where id=@id"

SqlCommand cmd = new SqlCommand(sql, conn)

SqlParameter parn = new SqlParameter("@UserName", name)

cmd.Parameters.Add(parn)

SqlParameter parp = new SqlParameter("@UsersPwd", pwd)

cmd.Parameters.Add(parp)

SqlParameter pari = new SqlParameter("@id", id)

cmd.Parameters.Add(pari)

int result = cmd.ExecuteNonQuery()

conn.Close()

cmd.Dispose()

return result

}

/// <summary>

/// 删除

/// </summary>

/// <param name="id">编号</param>

/// <returns></returns>

[WebMethod]

public int Delete(int id)

{

SqlConnection conn = new SqlConnection("连接字符串")

conn.Open()

string sql = "delete from User where id=@id"

SqlCommand cmd = new SqlCommand(sql, conn)

SqlParameter pari = new SqlParameter("@id", id)

cmd.Parameters.Add(pari)

int result = cmd.ExecuteNonQuery()

conn.Close()

cmd.Dispose()

return result

}

---