import java.sql.*;public class regbbs{
public static void main(String[] args){
String forwordTo = "";
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://192.168.10.141:1433; DatabaseName=fsbbs";
String userName = "sa";
String userPwd = "123";
Connection dbConn;
//String ta;
//SimpleDateFormat myFmt5=new SimpleDateFormat("yyyyMMddHHmmss");
//Date now=new Date();
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
//System.out.println("Connection Successful!");
Statement pStmt=dbConn.createStatement();
String sql = "insert into table1(fa,fb,fc,fd)" +
"values('aaa','bbb','ccc','ddd')";
pStmt.executeUpdate(sql);
forwardTo = "success";
}
catch (Exception e) {
e.printStackTrace();
forwardTo = "no";
}
return forwardTo ;
}
}
public static void main(String[] args){
String forwordTo = "";
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://192.168.10.141:1433; DatabaseName=fsbbs";
String userName = "sa";
String userPwd = "123";
Connection dbConn;
//String ta;
//SimpleDateFormat myFmt5=new SimpleDateFormat("yyyyMMddHHmmss");
//Date now=new Date();
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
//System.out.println("Connection Successful!");
Statement pStmt=dbConn.createStatement();
String sql = "insert into table1(fa,fb,fc,fd)" +
"values('aaa','bbb','ccc','ddd')";
pStmt.executeUpdate(sql);
forwardTo = "success";
}
catch (Exception e) {
e.printStackTrace();
forwardTo = "no";
}
return forwardTo ;
}
}
解决方案 »
- 如何实现自动生成订单号,并防止多人同时生成
- java jsp ajax
- Java程序员需要掌握哪些?请教大侠们了
- springMVC 跳转页面问题
- jk(apache+tomcat),项目中.htaccess实现301重定向的问题
- 救命。。。各位大哥大姐,tongweb 谁用过
- 这是什么错误 web配置
- 怎样在EJB中实现复杂查询,动态条件查询
- 我基本上把J2SE的基础学了一片,但没怎么用过,我想做J2EE,我的下一不该怎么走???J2EE对J2SE的要求有好高呢??
- struts的问题,常用struts的朋友近来解决一下,我急用,谢谢!!!!
- 寻求jboss关于XML文件配置方面的资料
- 在weblogic 8.1上部署EJB时出错,在线等待
提醒以下:
我觉得你这个已经违背了struts框架的精髓了,
数据库方便的操作写在DAO里