67,515
社区成员
发帖
与我相关
我的任务
分享
package news.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class Sample
{
public static void main(String[] args)
{
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}
catch(ClassNotFoundException e)
{
System.out.println("驱动类没有找到!");
}
Connection con=null;
try
{
con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=news","sa","sa");
}
catch (SQLException e)
{
System.out.println("数据库连接失败:"+e.getMessage());
}
System.out.println("连接数据库成功!");
String sql="insert into FirstLevelTitle values(?,?,?,?)";
try
{
PreparedStatement ps=con.prepareStatement(sql);
ps.setString(1, "666");
ps.setString(2, "测试添加");
ps.setString(3, "qunhao");
ps.setString(4, "");
if(ps.executeUpdate()==1)
System.out.println("添加成功");
else
System.out.println("添加失败");
}
catch (Exception e)
{
e.printStackTrace();
}
}
}